Ya that's a cool feature. Do you know if there are some whitepapers on Microsecond tuning? I was thinking that Hala from MySpace.com could come up with one,...

Check out books online in the convert section. You'll get all 10 000 possible presentation you can have in SQL Server. That said, do the formatiing in the...

Sorry but I need to to be 100% clear. Kids cover your hears :

DON'T f*ck WITH SYSTEM TABLES, EVER.

As Joe Celko would put it :

SELECT Squid FROM FOO ORDER BY Britney Spears

I don't see how the heck the server could handle this one.

Can you tell us more...

:w00t:, what class was that in Gail? I got to hear that story when the recordings come out.

One more thing to consider now protecting ourselves from... user laziness. ...

Just a couple pointers, there's lots of things to check and I don't have enough time, not info to do this.

1 - Move the join syntax into joins and outside...

One thing you can do to aleviate this is call the proc. In the proc raise an custom error. Set that error to start a JOB. In...

You know what guys, I think she REALLY means it :w00t:.

Translation request : RPAD?

Let's put it this way :

2007 = smallint (2 bytes)

12 = tinyint (1 byte)

31 = tinyint (1 byte)

So you have to process 4 bytes here in 3 columns (small...

Have you tried adding one more cast as date to the startdatetime variable?

Always the small details that gets us :hehe:.

Well I'm as MS sql server engineer so I should be able to access that list ;).

Ya let us know how this one turns out. This is invaluable for the next poster who finds this thread with the same problem.

Ya, but if you want to be able to do that no matter how many rows you want to concat, for any number of master jey, let ME know ;).