Heh... dammit... I hate tabs. 😛 Thanks, Christopher.

As a sidebar, what's the first thing you do when you buy a new car? You find out how to operate...

vbugarsk (12/11/2008)

---

Thanks guys for answers.

I am fully aware of possible problems:

1. Overruns will never happen, meaning that client will never have more then 200 orders per year. If it will...

The scope of a temporary stored proc is a bit different than that of a temp table... if you create a temp stored proc using dynamic SQL, it IS callable...

Heh... no, no... I wasn't trying to be sarcastic or smug in any way. From BOL...

[font="Arial Black"]Arguments[/font]

procedure_name

Is the name of the new stored procedure. Procedure names must conform to...

Ok... here it is... first, we need to make a UDF from Matt's code to drive a point home later...

CREATE FUNCTION dbo.MillerCode

(

@STR...

engintoksoz (12/11/2008)

---

I loved the Matt's solution too and learned how to use patindex. But I dont agree about your reasoning. patindex itself is a function and I can not imagine...

Ron,

I'm not sure what to tell you... I saved the file attached to the post above from SMS and renamed it .txt. That's all I did to it and...

Just testing... please ignore this post....

Garadin (12/11/2008)

---

You know, I never really stopped to think about it, but you're right, it doesn't even make commenting out easier. I do think it makes it a little...

Chris Morris (12/11/2008)

---

Jeff Moden (12/11/2008)

---

Heh... I think it's a bit odd that anyone would write code to make commenting it out easy when they refuse to comment code to make...

In all fairness, cursor solutions for such small rowcounts such as working on a list of databases will never become a performance problem unless you just want to consider the...

Kris (12/11/2008)

---

pretty much, it wasn't my decision, I simply have to make a program to fit within their protocol. With reporting services, the excel format is easy, so long as...

Jeez... good luck with that... As I said, SUM and AVG don't work with OVER in SQL Server the same way as they do in Oracle. Test it and...

No problem... Skull Killer is right though... it would be handy if you could describe what the archive...