Is there a question here, or is this just a demo of the most convoluted way possible to do table auditing?

If your comma-separated lists are uniform, then you could search them like this

select * from #Temp

where ',' + Client_List + ',' like '%,9,%'

But only you can know if it will...

Came across this: http://i.imgur.com/dsCw0.gif

As an ex-teacher, I love stuff like this that explains/shows the meaning behind these numbers and symbols.

tripri (9/8/2011)

---

But i'm getting an error when i execute this code

Query:

select name , ' Geo: ' + Geo + ' Sci: ' + Sci

from name

Error:

Msg 245, Level...

Add a new column in table1 called something like "DuplicateOf" which contains the uniqueidentifier of the row it was copied from. Now you can join table2 to this new column...

Clearly, this is the way to do it:

select f.*

from @form f left join

(select...

david 98157 (8/29/2011)

---

I am running a query collecting data from multiple tables and connecting it to a master part number on the same row. The problem that i am running...

That takes care of #2, but the important question being...

Seconded. A good setup gets your question answered quickly. With tested code! 😎

ColdCoffee (8/31/2011)

---

This will be more robust:

select ColA, ColB

from TestTable

order by isnull( ColA , ColB) ,

case when ColA is not...

Nice shot, CC. You got there seconds before me 😉

select * from TestTable

order by

ISNULL(ColA, ColB) + ISNULL(ColB, ColA)

Case when ISNULL(Field1,0) = 0 then 0 else 1 end +

Case when ISNULL(Field2,0) = 0 then 0 else 1 end +

Case when ISNULL(Field3,0) = 0 then 0 else 1 end...

Umm...when we say "try this"...

Give this a try:

update a

set order_attribution = 'Y'

from TMPDATA a

where

mmc_vendor = 'email'

and mmc_placement = '_bmui'

and exists (

select 1

from TMPDATA b

where

b.session_start_time > a.session_start_time

and b.mmc_vendor = 'free_search'

)

You don't want to do this because now...