don (3/26/2009)

---

In SQL 2008, the error is produced by the Between clause, not the initial Insert and Unions.

The Help states the expressions used in the Between statement must...

OK. Again, sorry for the SQL 2005 solution if you really need one for SQL 2000. I'm not real happy with this one either as it may not...

james (3/23/2009)

---

Yes, I understood what was going on (answered correctly) until I read the explanation. It should be mentioned somewhere in there that the NULL does not compare well...

What's happening here is that comparisons with NULL always return "false". Not even NULL compares true to NULL. So, even though NULL (row 4) doesn't contain string "del", it...

Arrrrggghhhh!!!!!

My apologies... I saw the topic in the daily e-mail and lost track of which forum we're in....

Vijayd,

You may want to see if you can more clearly state the requirements. I may be interpreting differently than Arun did. The way I took them:

-- Each userID...

Interesting QOD. It's good to know that SQL 2008 has raised a limit that some may have come up against. Also interesting that (as of this posting), the...

ghollis (3/19/2009)

---

Wouldn't using Top 25 WITH TIES accomplish the same thing, rather than using the CTE (assuming they are using the group by and order by clauses without the...

One more "real-world" caveat: there could be a tie for the number 25 spot, so simply using "Top 25" in the select may leave a worthy salesperson off the...

So maybe if the second choice had still been "T", I would have picked another response. I am puzzled how I hadn't seen the default length of 30 before,...

Bob Hovious (3/16/2009)

---

Took me a while to sort out the identities by join date.

The obvious question to ask is:

If the other Mh wasn't the person that started this thread, why...

Using the name "GO" is a red herring here and is not so strange as the fact that this is both recursive and self-modifying code. Generally, self-modifying code...

Yes, you CAN create a uniquely named table in each run of your SSIS package. You could simply build a create table DDL statement using variables, part of which...

What index(es) do you have on those tables? which index is used for the seek? which for the scan? It looks as though the difference in the query...

verena_techie (3/6/2009)

---

Not sure why but I chose ISNUMERIC() and it says I got it wrong! oh well, it's my first time to decide to work on the question (to avoid...