GSquared (2/21/2011)

---

jcrawf02 (2/21/2011)

---

GSquared (2/21/2011)

---

Jeff Moden (2/21/2011)

---

Heh... no one even noticed recently... I slipped over the 24,000 post line, Gail topped 22,000 posts, and Gus has put the hammer on 10,000...

Jeff Moden (2/16/2011)

---

WayneS (2/15/2011)

---

Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on up to a varchar(8000), and I...

My first thought was I would like to see the difference in the execution plans. If I get time to do some tests I'll post...

First, you have to identify the set of userIDs which exist more than once.

Try this:

SELECT a.id,a.title,uao.userid

FROM user_artist_owned uao

INNER JOIN artists a on a.id=uao.objectid

where userid in (

SELECT userid

FROM...

You should test them side by side to be sure, but in my experience the cross-tab runs just a hair faster on average.

Is this an SQL question?

That is not a sarcastic remark. What are you running? What do you mean you "closed the page"? ...

It might be easier to follow if we could see the actual code, but....

Remember that a CTE does not produce a temporary table. It is just a symbolic...

In the absence of a preexisting table, you can generate a sequential list of hours very simply by means of a tally table.

;with hoursTbl as (

select dateadd(hour,N-1,cast('Feb 10 2011' as...

QA is where some developers send their code to see if it works correctly or not. Often they do this without verifying that it works in their development...

Just out of curiosity, how do you use ROW_NUMBER() at all without using OVER? I'll encourage you to read up on ROW_NUMBER(), RANK(), and the other windowed functions...

If you are using the code shown to insert into another table, you are only going to get one "duplicate" at a time. To insert all...

If you index the table variable on [Code], and if the table to...

Mike, respectfully, you need to work on stating your question more...

More information would help. What columns are you going to index on? What are your joins going to look like to your permanent tables?...

LutzM (12/30/2010)

---

The Dixie Flatline (12/30/2010)

---

Good for you, Robert, and thanks for letting us know that you have a solution now. Good luck to you in the coming...