milzs (7/2/2012)

---

Thanks... I'll check out your link. BTW, this is a super-simplified example of my real problem which is for a system on a classified network. That's why...

milzs (7/2/2012)

---

Thanks... I'll check out your link. BTW, this is a super-simplified example of my real problem which is for a system on a classified network. That's why...

With almost 3,000 points it is hard to believe you didn't post any consumable ddl and sample data.

Take a look at the link in my signature about splitting strings. It...

eagb (6/28/2012)

---

I've been given an old script, and need to create it into a stored procedure. The script uses a cursor to delete from a table which has a trigger...

It is hard to say if you are on the right track or not. I would lean towards not because looping in t-sql is horribly slow. This is now the...

Welsh Corgi (6/28/2012)

---

I just checked and none of the CASE Statements are updating all of the records.

Does anyone have an example of a Sercehed CASE Statement used to perform UPDATES.

One...

Short meeting, the kind I like best!!!! Glad you were able to get it working.

BenWard (6/28/2012)

---

lol if I copy and paste the query out of the udf it completes in just 5 seconds.

I just can't get my head around why exactly the same...

HOLY COW!!! This thing must take forever to run. Any chance you can pull it out of a scalar function? They are notoriously bad for performance and with this one...

NO dumps are against the agreements with MS. If it is determined you used dumps to achieve your certs MS will revoke them.

Get some study materials and learn the...

To add to the above you might even consider adding some sort of sanity check inside your recursion. Make an iteration count or something along those lines that gets passed...

adiehl (6/28/2012)

---

Thank you, I am trying out the Cross Join now. Of course, I was told there would only be 1 row in the database and there are actually...

I know your question was about getting these results into multiple result sets, which is a bit odd but I think you have been shown how to do that now.

The...

rhythmk (6/28/2012)

---

Mahesh Gupta-325917 (6/28/2012)

---

I’m trying to insert data from 1 table to another in a specific order.

Lets say in table1, I have data saying 4,2,3,1

Now I need to insert...

3935 (6/27/2012)

---

Insert into #Ashah (Invoice_Number)

values RIGHT ('0000'+Store#,4)+ RIGHT('0'+CAST(DATEPART(DAY,GETDATE()) AS varchar),2)

...