That also means that you've learned...

But, again, and as Flo suggested... SQL Server is NOT the place to do such formatting unless it's for direct output to a file sans any trip through a GUI...

scorpio_zz19 (3/10/2009)

---

hi,

i searched how to split the date from datetime data type and i came up with this code(below), the problem is that i dont know where to put it.

...

I just got done doing one like this a coupe of weeks ago. The problem is the aggregation... you're trying to aggregate in the presence of way too many...

As Flo implied, variable length columns in SQL Server 2005 are handled quite a bit differently than they were in SQL Server 2000. For example, the following would cause...

Chris Morris (3/10/2009)

---

Wayne (3/9/2009)

---

Jeff is right. I have to cater for non-trading days other than weekends (which are not included in my sample data) so having a 7 day...

GSquared (3/10/2009)

---

Jeff Moden (3/10/2009)

---

You bet, Todd... Thanks for the feedback. Heh... It's amazing how long the myth of Select/Into has managed to survive.

I'll have to look for it, but...

Yeah... I agree... the written requirements weren't that clear. The desired return posted along with the attempted code and the existing data was the key.

Richard Hurst (3/10/2009)

---

Alternatively you could just do a find and replace on the original file and get rid of them that way.

I just did because the whole thing was driving...

Spikemarks (3/10/2009)

---

Absolutely brilliant but they have now thrown a curved ball and state that some of the phone numbers are from other countries and so the zero needs also to...

robert.mason (3/10/2009)

---

Jeff Moden (3/6/2009)

---

If someone ever starts sending you data with milliseconds, you code will produce incorrect results. If some newbie in a hurry sees your code and decides...

You bet, Todd... Thanks for the feedback. Heh... It's amazing how long the myth of Select/Into has managed to survive.

I'll have to look for it, but I've got a...

Thanks for the kudo, Ross :blush:

I also understand that there are times when the Consultant or other 3rd party wants to protect proprietary code through encryption... that, too, should be...

The problem with your tests is that the time to display the results are being included. Also, as you saw in your own testing, converting the date to CHAR(8)...

Man, it just amazes me that people hire consultants/3rd parties without a contract...