Hi greatheep,

Something unorthodox....have you tried to introduce a separate table for keeping the status, with the new table forming a 1-1 relationship with the original. The idea behind it is...

For those that are using cursors or are considering using them for accessing various tables depending on some condition there is as I mentioned before the option to make a...

sharad sinha (4/29/2009)

---

Approach 2:

Use separate queries ...1 for each database...and then return the union of these resultsets...The problem with this approach is that the number of history databases keep...

I am happy to take a look at it, but right now I have to finish some actual work :(. In the meantime if you can make a test case...

Thanks min.li for the complement and as you I am happy with the outcome.

Be aware though that technically CTEs are not strictly required for this solution, they do however really...

Back...

First I modified one of the source tables after looking at the queries.

create nonclustered index ix_TestData_DataID on dbo.TestData ( DataID );

I also added one more result column to my previous...

Again, I don't see anything that needs a cursor, let me have a go at it!

Stored procedures aren't bad when they are used for guiding a procedure of a series of actions; it is what they are for basically. What is bad is procedural LOOPING...

What is counter intuitive to people new to SQL Server is that each statement in a batch carries quite a large overhead. It’s an overhead that is reasonable small in...

JJ B (4/28/2009)

---

Thanks Jeff and Lynn. I knew that CROSS APPLY wouldn't...

min.li (4/28/2009)

---

Thanks Samuel and Peter.

The real environment where this function to be used, the 'TestData' table is not really large. Or to be exact, the TestData table is large, but...

I did a quick optization of your own code which is interesting to know in case the time to alter existing code is limited!

I changed the declaration of the cursor...

Back min.li ( I couldn't resist the challenge)

First I modified your test case in one important way!

alter table dbo.TestData add constraint pk_TestData primary key clustered ( RowNumber );

Adding a clustered...

Thank you min.li, I ran the test code and that works and is a good starting point. I will take a deeper look at the actual code later today, problably...

min.li (4/28/2009)

---

Hello,

I recently had to use curosr to do a function in my work. Although I knew I should try to avoid cursor, but could not find a way. I...