Thanks Roy. I just hope the OP realizes how important it is to not run this in production. The first time I ran this on a production box it took...

Here is some code I put together a few years ago. This code is horribly slow!!!! There is now way around this being slow. DO NOT RUN THIS ON YOUR...

Since you are wanting to get each value only once something like this should work.

;with data (col1, col2)

as (

select 'aaa', 'sss' union all

select 'aaa', 'ttt' union all

select 'bbb', 'ttt' union...

angela.nira (12/22/2011)

---

Hi Drew,

What is obvious is that the users on this message board are much more knowledgable with Excel and SQL than I am and perhaps I should have mentioned...

Shamshad Ali (12/21/2011)

---

Thanks, is there anyway to make a single query? For depending on parameter we put Cade in where clause

Where domain is not null or empty and domain like...

yuvipoy (12/21/2011)

---

Hi,

What information you need?

where did you need me to explain?.

i have given conditions i think you where not able to read my post correctly.Other peoples who have...

or something like...

select [columns]

from tracking t

where not exists

(

select * from Exclusions where t.domain like '%' + e.domain + '%'

)

Pretty sparse on details to come up with some code but something like this should work.

select [columns]

from tracking t

left join Exclusions e on t.domain like '%' + e.domain + '%'

where...

This is why you should store date data in a datetime column. Since your are on 2008 and your data does not appear to have time values associated the date...

Hadrian (12/20/2011)

---

I have to insert into a excel file the questions and question pool level (which come from alttext colum -@1-.@2-,@3-.@4-.@5-)

questionID Question Pool Level 1 ...

Better yet, parameterize your queries or turn it into a stored proc. If you are doing inserts with a pass through query you are vulnerable for sql injection. It strongly...

OK so now we have ddl and sample data. What do you want for output? Your original description is very unclear.

igngua (12/19/2011)

---

Lowell (12/19/2011)

---

i'm guessing nwdetcot is a list of all possible prices, possibly for all products thru the begfinning of time..i'm betting you need to limit it to just...

select count(*) from

(

SELECT COUNT(*) as myCount

FROM Departments INNER JOIN

Employees ON Departments.Id = Employees.DepartmentId INNER JOIN

Results ON Employees.Id = Evaluation.EmployeeId

WHERE (Results.Year = 2011)

and Employees.OrgId = 73

GROUP BY Employees.DepartmentId

) x

Notice that for...

Krasavita (12/16/2011)

---

Hello,

I found that previous programer created Scalar valued fauncion on a seperate database that stored procedure is running and we are not using this db anymore,is there reason that...