I'm not completely clear what you mean here or need to accomplish?

Are you and the client both loading files separately? Do you need to create a file for them? Or...

Are you using a FQDN in there for the alias?

Are you trying to build up the select statement with IFs? Can a CASE work

CASE when @home = home

then a.xxx

Or are you trying to build dynamic SQL? Honestly...

It's good you find some inspiration from Randy, but I wouldn't pity yourself. Move forward, look to make changes, and look to make life better where and when you can.

Take...

Protein bar, coffee and water here. Had to take a large supply of bars to the UK last year. Had a hard time finding them.

I struggled with breakfast. Lots of...

As an FYI, I'm not upset about the complaints. I completely understand how it looks from your side and I apologize.

The QOD is a hard place to get a good...

I think my brain has lots of little tables, very little DRI, and way too many cross joins occurring on a regular basis.

If you monitored the mpg, was that not at least interesting?

I think that you have to make the choice about fun v economical and bear the costs. When I got...

OK, this is more my fault than Kevin's.

To start, "is" changed to "are" and "select all that apply" added. I should have done that.

The engine is built to show...

Scott,

Thanks for the editorial and it's provoked an interesting debate.

I wasn't sure what people would say, and I don't completely disagree with Scott's arguments, but I don't think they're great....

"Enjoy driving", OK to be fair it's not enjoyable. It's like a bus around here moving kids, but it's not really any different than a lot of cars. The 911,...

Closing the thread on this one. I don't see anyone being rude except the OP and no racism.

I found this: http://heyna.wordpress.com/2008/06/12/my-prius-battery/

Also, on Prius Chat I saw that depending on the generation of the car (1-3) it seems to be as low as $2500, as high as $5k....

You need to break out each part of the substring (len, charindex, etc) and see what values they are returning. That will help you find the error.

As mentioned above, DO NOT SHRINK the database or log file. It's unnecessary.

You should allocate space in the data file to handle growth for the next few months, and then...