Ummm... will that create the sub-directory if it doesn't already exist?

Heh... just reverse the IDENTITY number...

That's good feedback... thanks. I always wonder if articles like that help folks. 😀

tbeadle (9/11/2008)

---

Hello,

Concatenating strings is no problem but you may have to get a bit creative to avoid the limitations on text lenghts.

Look at the spec difference between varchar's...

Search for "CASS CERTIFICATION" software... it does the whole thing from womb-to-tomb and provides updates as new address information comes available from the US Postal Service. I believe "ZP4"...

If you used a conversion to group by date, then you probably did it...

arbarnhart (9/19/2008)

---

Jeff Moden (9/19/2008)

---

p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including...

p.s. I also want to say that when I say "developers", I'm talking about the greater populous... there are some individual developers that I'm NOT including in my rant,...

Heh... most of the companies that have hired me to fix things, have rooms full of developers that hate "old style DBA's" or think they know things like what Agile...

A very hearty congratulations! This is really cool feedback and you need to be very proud of yourself, as well! Yes, the information is here and there are...

rbarryyoung (9/18/2008)

---

Actually it's much easier than that and you don't need any evil Cursors either:

Declare @sql as NVarchar(MAX)

Set @sql = ''

Select @sql = @sql + 'EXEC sp_refreshview ''['

...

It's even easier than that...

SELECT *

INTO #MyFiles

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

Much simpler than all that... check out the ROUND function or the STR function (which also right justifies if you need that for a report or file). 🙂

Heh... and the PIVOT operator is slower and uglier than the CrossTab that Chris showed. Think not? Check it out...

http://www.sqlservercentral.com/articles/T-SQL/63681/

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...