IgorMi (12/18/2013)

---

Sean Lange (12/18/2013)

---

From the sample output you posted you don't have any duplicates. There are unique values in one of those columns (I can't tell from the garbled display...

From the sample output you posted you don't have any duplicates. There are unique values in one of those columns (I can't tell from the garbled display which one). What...

Try this link. It will be a great starting point for helping us find you an answer.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Good to virtually see you again Craig. Hope all is...

If you know how many products you can do something like this.

with MyData as

(

select SUM(SalesofProductA) as Sales, Customer, 'A' as ProductType

from #abc

where Year = @Year and Month = @Month

group by...

Duplicate post. Original thread here. http://www.sqlservercentral.com/Forums/Topic1523885-3077-1.aspx

anushakadiyala 52521 (12/17/2013)

---

Thank you for taking a look, This is the code I have been trying.

UPDATE TA

SET ServerName= REPLACE(ServerName, '%.%.dim.com', '')

WHERE Servername like '%.%.dim.com%'

basically I want to remove anything that...

bharat sethi (12/17/2013)

---

Hi!

This SP has

an initial query to load data in temp. table with 5 tables joins. This query executed within 15 seconds.

...

Or maybe this...

if (@req_1 !='AAM' AND @req_2 !='VVE')

print 'TRUE'

ELSE

print 'FALSE'

It all depends on what you are trying to do here.

Going to need more details than that to help here. From what you posted there is no need for the IF condition but I suspect you have probably have something...

jcrawf02 (12/17/2013)

---

Sean Lange (12/17/2013)

---

Stefan Krzywicki (12/17/2013)

---

Sean Lange (12/17/2013)

---

Ed Wagner (12/17/2013)

---

jasona.work (12/17/2013)

---

Ed Wagner (12/16/2013)

---

jasona.work (12/13/2013)

---

Ed Wagner (12/13/2013)

---

jasona.work (12/13/2013)

---

OK, where did the year go?

I mean seriously, 12 days until X-Mas? It...

bharat sethi (12/17/2013)

---

HI! As per my understanding posted almost all info. about the problem. Please let me know what exactly you required to solve this problem. I am really eager...

defyant_2004 (12/17/2013)

---

I am still not seeing what functions on the server they would need. If they can work in SSMS from their machine, why do they need to login...

Stefan Krzywicki (12/17/2013)

---

Sean Lange (12/17/2013)

---

Ed Wagner (12/17/2013)

---

jasona.work (12/17/2013)

---

Ed Wagner (12/16/2013)

---

jasona.work (12/13/2013)

---

Ed Wagner (12/13/2013)

---

jasona.work (12/13/2013)

---

OK, where did the year go?

I mean seriously, 12 days until X-Mas? It feels like it...

Take a look at the articles in my signature about cross tabs. I suspect you will need to use the dynamic version here.