AndrewSQLDBA (12/12/2012)

---

Yes, that is exactly what I need / want. I mean, there will not be 2 million different LabNames, but one userID could have 3, and another have 30...

AndrewSQLDBA (12/12/2012)

---

I found that out about the table variable, so i now use a temp table. Not a big deal. I would much rather use a table variable, especially for...

Complain

This looks like homework or an interview question so ill post some usable data. Can you show what you have tried so far?

CREATE TABLE tmpProduct (

Product VARCHAR(32),

[Year] INT,

QTY INT,

CONSTRAINT...

This looks like a running total (from the math in the rCTE). Have a look at Jeff Modens article on the "Quirky Update" http://www.sqlservercentral.com/articles/T-SQL/68467/ It will at least...

AndrewSQLDBA (12/12/2012)

---

The thing of the data is this. I have no idea what will be in that column, so a case statement will not work, that I see.

And there are...

No problem. the only issue is i dont think it will work with the table variables. for those you may need dynamic sql or just use a temp...

one option is to create the table with an IDENTITY (1,1) and then a DBCC CHECKIDENT to reseed the table at the given value passing a variable to it

IF OBJECT_ID('dbo.Test')...

GSquared (12/11/2012)

---

CELKO (12/11/2012)

---

>> --But I need the result as below (i.e, the order should be same as how I had input the value in the IN() ) <<

You have no...

DarthBurrito (12/6/2012)

---

So I spent most of the dya searching for an answer, which I did find. As the title states, I was trying to find a method to pass multiple...

Rob-350472 (12/6/2012)

---

I'd have to review the split function you linked to - I opened it and had a quick look but I've not had the time to read it yet.

As...

well the process ran yesterday evening with no ill affects. unfortunately i don't believe i can speed it up any more because of business rules about the data. ...

I know this is an old post but needed to update. i just experienced this same error (only on 2008) and changing to the local system account for the...

This looks like a gaps and island problem. it also from the problem description sounds like homework or an interview question.

Take a look at this for a detailed explanation...

Another person who posts the same dynamic sql article.

i highly recommend the suggested reading.