I'd bet credits to Navy beans that a legacy system also has legacy code. Search sys.SQL_Modules.Definition for the column name using LIKE '%columnamehere%' and then use the OBJECT_NAME(OBJECT_ID) on...

Grant Fritchey (2/26/2009)

---

There's a heck of lot here to chew on, but the first thing that jumped out at me was the this little bit of RBAR (row-by-agonizing-row) processing:

while @RevStateyr...

Darwin knew this was possible...

http://www.sqlservercentral.com/Forums/Topic665342-148-1.aspx

Grant Fritchey (2/26/2009)

---

In general DBA's are considered trusted employees because they can access the data. That's one of the reasons the job pays more. If they can't trust the DBA,...

How's the performance, Roy?

GilaMonster (2/26/2009)

---

Jeff Moden (2/26/2009)

---

All SQL Keywords in UPPER CASE.

All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase with no underscores....

Works better on old eyes like mine. That and...

Heh... correct... well... except in...

Looks like a final exam to me... who gets the "A" if we answer them?

It's time to hucker down and do you own work... heh... c'mon, it'll be fun! 😉

I follow the following casing standard...

All SQL Keywords in UPPER CASE.

All database names, table names, procedure names, column names, column aliases, variable names (basically, my stuff) etc, in MixedCase with...

GSquared (2/26/2009)

---

Actually, difference is microseconds per calculation, but for the sake of argument, let's...

Bruce W Cassidy (2/26/2009)

---

[font="Verdana"]One of the recent (i.e. in the last ten years) changes in data warehousing has been a move away from specialised ETL tools like Informatica, Data Stage,...

mark_92708 (2/26/2009)

---

Hi all,

I was reading this thread because I was looking for a solution to this identical problem - trying to concatenate the result strings of one field from a...

Yep... it's call a "Cross-Tab" or "Pivot"... and the type of table you have is called an "NVP" or "Name/Value Pair" table...

SELECT ID,

...

I can understand maybe doing this on numbers for a check...

Derek Dongray (2/26/2009)

---

Then someone could...