Carmen Electra

Try filtering them out in your WHERE clause. Something like...

WHERE query NOT IN ('Unwanted value', 'Another unwanted value')

Alternatively,...

Can you write a SELECT which retrieves only the rows which you want to insert into the new table?

renvilo (10/14/2010)

---

Something is strange 🙁

I test your code and works 100%

This is what I have:

SELECT top 1000

SourceID,

...

I don't see a problem.

-- set up some sample data

DROP TABLE #Sample

CREATE TABLE #Sample (SourceID CHAR(3), VisitID VARCHAR(15), Query VARCHAR(10), Response VARCHAR(4))

INSERT INTO #Sample (SourceID, VisitID, Query, Response)

SELECT 'BLA', 'V1002900877',...

What's the error message?

Read the articles Wayne recommended. You will gain a comprehensive understanding of how this works:

DROP TABLE #Sample

CREATE TABLE #Sample (SourceID CHAR(3), VisitID INT, Query VARCHAR(10), Response VARCHAR(4))

INSERT INTO #Sample (SourceID,...

You could use the OUTPUT clause, returning the new PK and an old PK for the backlink. This would allow you to do all of the inserts in one go,...

You can say that again.

The Dixie Flatline (10/13/2010)

---

Gail, this is a quote from that link. There is just something I always find curious about posts like these....

crookj (10/13/2010)

---

Chris Morris-439714 (10/13/2010)

---

Joe, is this...

Tell me - not sure I can afford all the beers I must...

Joe, is this the thing that...

Heh you beat me to it Wayne, and yours is nicer too.

SELECT d.ID,

speak_flag = REPLACE(iTVF1.RowsToString + '$', ',$', ''),

read_flag = REPLACE(iTVF1.RowsToString + '$', ',$', ''),

ia_flag = REPLACE(iTVF3.RowsToString +...

Paul White NZ (10/13/2010)

---

sivaj2k (10/13/2010)

---

Yes, definetly. You have to use dynamic query. First frame a query using the variables supplied to the procedure. Store query to a variable and then...