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 ;).

Can we get their contact info??? That'd be nice to have in out contacts :w00t:.

HTH.

Why exactly did you want to do this process async from the other operations?

Are you guys all trying to make me believe that there are some bad vendor apps out there :hehe:??