Grant Fritchey (1/9/2009)

---

Here in New England... it's a New England winter only a little more so. We could use a bit of global warming. There's about 3 inches of completely...

There are several ways of doing this. Can you explain a little more about the problem? For instance, how often do you want to do this? How large are the...

Performance will improve using UNION ALL, as you mention in your first post. Of course, always test first.

SELECT your column-delimited list of columns here

FROM yourtable

There isn't an easy way to do this, Lee. It can be done by gathering the column list for your table from syscolumns...

Hi Eddy, thanks for your kind words.

As for there was nothing faster than index seeks - in this case it's difficult to compare the original query with the new...

This should fix the problem - but without any data to test against, it's hard to tell..

[font="Courier New"]SELECT DISTINCT b.BranchName + ', ' + CONVERT(VARCHAR, na.WeekEndingDate, 101) AS [Member Firm],...

RBarryYoung (1/8/2009)

---

OK, I checked and yes, "YYYY-MM-DD" is the ISO 8601 standard for "unambiguous numerical text date format". (see here: http://www.uic.edu/depts/accc/software/isodates/index.html).

Also, as to the representation of date constants, here is...

stricknyn (1/8/2009)

---

Hello everyone,

Ok this is weird. When I run the statement below it is returning 1. Can someone explain to me why this is returning 1?

select datediff(year, '2008-01-09...

Come from table how? Please post the entire stored procedure.

RBarryYoung (1/8/2009)

---

Heh, that was going to be my next question...

Does this statement have the locking hint NOLOCK?

rsteeves (1/8/2009)

---

I need to update a date field for all records in a table to change the year from 2008 to 2009. I have tried thsi SQL with no success...

Garadin (1/8/2009)

---

My turn to Google! Never heard of Muffin the Mule before... but...

Garadin (1/8/2009)

---

The joke doesn't make nearly as much sense if you haven't seen the movie. The butler in the movie is "very sneaky", and keeps appearing randomly whenever he's...

Gits unite old, yes!