Start out with the assumption that it's an innocent error. Your boss may not even know it's not a licensed copy. Alert him to the issue, pointing out...

Nadrek (11/18/2009)

---

Jeff Moden (11/17/2009)

You and another poster said about the same thing... I'm going to have to give it a try. Although it's not likely to have 8000 spaces (almost...

blandry (11/18/2009)

---

Throughout the 30 plus years of my career I have listened to techies arguing the speed issue. I understand that for some businesses, this is crucial, but we...

Elliott W (11/17/2009)

---

I think GSquared and I are having philosophical differences today. I generally don't do SELECT INTO because at design time I want to know exactly what the...

John Rowan (11/17/2009)

---

I've always forced our guys to define all temp tables at the beginning of the stored procedure. Interleaving DDL with DML causes the SPs to recompile. ...

Again, the problem with replacing SQL with a more "relational" database engine and language is that, despite numerous attempts to do so, nobody has been able to come up with...

You're welcome.

It hasn't been a problem in over a decade, but that doesn't stop lots of DBAs from thinking it is one.

I've done a lot of load and speed testing with...

The problem I've seen is that every non-relational data engine I've tested has had worse problems than SQL RDBMSs do. Sure, some of them solve some of the problems...

It won't let you install SSMS? That seems strange. Did it give you an error message on that?

Are you trying to figure out how many rows of each column are null, vs how many have each distinct value?

You won't be able to get that from metadata. ...

Try replacing your final select with:

;with CTE as

(SELECT ResultID ,

QuestionID ,

OptionTextboxValue ,

...

Use cursors when you need to iterate through databases and tables where the command isn't something that can be written as a single T-SQL command.

For example, if you want to...

What does "cope with" mean in this context?

Do you mean you want each of those combinations to be handled differently? If so, how?

Yes, it can.

But I'm not clear on what exactly you are trying to do here. Are you trying to select all the rows that contain two spaces? If...