http://www.sqlservercentral.com/articles/TSQL/62867/

That article has data on how to split a delimited string efficiently, and a bunch of other good stuff that's related to that.

"IF" doesn't work that way. "Where" does.

SELECT A, B, C

FROM table1

where var1 = 1

UNION

SELECT A, B, C

FROM table2

where var2 = 1

UNION

SELECT A, B, C

FROM table3

where var3 = 1

Edit: The...

Are the other two columns numeric, or strings?

Why?

I think you just have to install the instance. Same as installing any instance on a cluster.

Is one of the profiles set up as the default? Are they listed as Public?

Option 2. Re-index after insert, so you don't fragment the index. Usually faster, too.

I've seen the Management Studio "Open Table" method for editing table data fail where there is no primary key. I see an identity column in your table, but I...

You can use the Like operator in joins.

select *

from dbo.Table1

inner join dbo.Table2

on Table1.Col1 like '%' + Table2.ColA + '%' -- Table1.Col1 contains Table2.ColA

or Table2.ColA like '%'...

Is there a physical relationship between the items? Like, PartA is a component of PartB? (Classic bill of materials.) Or is the connection between items arbitrary? ...

Look up "DBCC SQLPERF (LOGSPACE)" in Books Online. That should have what you need.

Michael, the original spec said that joins aren't allowed. Loops, If/Else, etc., are, but joins aren't. I'm guessing the person who wrote the question thinks he came up...

Row By Agonizing Row (Jeff has it in his signature)

It refers to code that makes the database do row-by-row calculations/instructions, instead of being able to operate...

I'm actually trained in using data to gather information about businesses and turn it into management plans. That and marketing.

My last job, the database I built turned into a...

I'm very much in favor of more nuclear power. The US Navy has been operating nuclear power plants for decades without, to my knowledge, a single "meltdown". (I...