What is the benefit of the ADO piece? Why not just use a stored procedure?

I do agree the first one is easyer to read. I was pulling some old code and ran into the second way of doing it and I could not remember...

Thank You

Thanks

When I run it says 'concat' is not a recognized built0in function name.

So much for early registration guess I'll be missing out on the fun. The code was not available when I registered.

PASS and use SSC2010 as the code.

Note that if you're...