Tagged Questions
1
vote
1answer
291 views
Cursor doesn't print text when I tell it to
I have used WAITFOR combined with a cursor in the following script:
create table orders(orderId int primary key,productId int,productName varchar(20));
insert into orders values(1,11,'book');
insert ...
2
votes
1answer
2k views
declaring cursor to loop over some values in SQL server 2008 R2
I have some business unit such as India, International, US, UK. I have to:
Create a table variable (virtual in-memory table) with columns that match SPROC SP_Report resultset.
Declare a cursor that ...
2
votes
1answer
488 views
View SQL 2008 sp_cursorexecute Underlying Query and Execution Plan
I'm performance tuning a Dynamics AX application and see in a SQL trace a long-running, high-I/O query of the form exec sp_cursorexecute 1073742882 ... When I try and run that query in a new SQL ...
0
votes
1answer
263 views
Date Format in Sql Server
I am importing data from another sources, which has multiple columns but I am facing problem in date column like I have multiple format in this column like:
dd/mm/yyyy
mm/dd/yyyy
mmm-yyyy
Can you ...
1
vote
1answer
715 views
Inner cursor performance issues
Before I tried to avoid using cursor because of performance issues. But now I have to do some calculations to reach some goals. I have a stored procedure that has a code like this:
DECLARE ...
