Implicit conversions will take care of it all... no formatting is necessary...

DECLARE @SomeDateCol DATETIME

SET @SomeDateCol = '06-Sep-2008'

SELECT @SomeDateCol

Numeric primary key... Holiday date can appear more than once depending on things like Country or State.

... and let's not forget what everyone else forgets... Delete Triggers and Indexed Views... they will certainly take a toll on performance, as well.

Ummm... BCP can execute an "EXEC" as part of that query...

Dave... anything in MSRS for over 24 hours?

Almost the same size as the tables I deal with at work...

Tell me... what identifies a "user"... the PH column?

Nice... thanks for that tip!

Even though we all, including the OP, recognize that this is a terrible requirement, has anyone actually come up with a solution that shifts the data left without resorting it?...

Those are great questions, Phil... Now, all I have to do is find someone that knows how to get the current system date and time without using a GUI! ...

Outstanding! Good luck with your tests! It's a worthy cause! I'd be interested in the results of your tests. I don't know how to write CLR's,...

GilaMonster (5/27/2008)

---

The best is one I got as a PM (and promptly deleted) It was sent on friday, asked a question, gave some data and them the poster said he...

Sangeeta Satish Jadhav (5/27/2008)

---

Use bulk insert...

--Step 1:create table to insert data from file

Create Table TmpTbl

(Column names

)

--Step 1: Build Valid BULK INSERT Statement

Set @FilePath = 'c:\test.txt'

EXEC Master..xp_fileexist @FilePath, @File_Exists OUT

IF...

pduplessis (5/27/2008)

---

Buwahahahahaha

Imagine selling csv burgers at the next microsoft launch....

c - chips

s - soda

v - viennas

Maybe we have a hit here that will feed a lot of developers and make...

No SSMS in 2k... no reporting service in 2k. Could be, it's a simple text report created by a scheduled job... makes a "great" presentation layer for those that...

Francis... you already have the hardpart done... if the Quarter = 1 then show the column, otherwise show a blank. Simple case statement should do it.