ramachandran narayanan (1/31/2016)

---

i have scenario ,SalaryCode,SalaryName

salarycode salaryname

1 basic

1 ...

Jeff Moden (1/29/2016)

---

I use it...

http://poorsql.com/%5B/url%5D is another free tool that works pretty well. You can use the website or they have an SSMS plugin you can use. Oddly until today i never noticed the...

Congrats!

I didn't say that, I just said I don't get paid for providing assistance on the...

For me IT is my...

VoldemarG (1/28/2016)

---

Thank you !!! You are the man.

I really appreciate your help.

Question:

are you actually really coaching some dumber folks like myself in SQL server remotely (I mean for...

You could use ROW_NUMBER in a cte and then select those rows where RowNum = 1.

It is hard to figure out from your posted query exactly what you are trying...

Ed Wagner (1/28/2016)

---

Sean Lange (1/28/2016)

---

Grant to follow the theme about poorly named products in your article about estimated execution plans. (http://www.cnet.com/pictures/25-worst-named-tech-products-pictures/24/%5B/url%5D). That has to be one of the worst webpage...

Grant to follow the theme about poorly named products in your article about estimated execution plans. (http://www.cnet.com/pictures/25-worst-named-tech-products-pictures/24/%5B/url%5D). That has to be one of the worst webpage designs ever. It has...

vijay.singh 14112 (1/28/2016)

---

Hi,

I have made a sample of result set in attached xlxs as well as in below script but the values are dummy. Please get back to me if...

How about if you create and post a temp table of the values and columns you expect as output and I can help you with the query to get there.

vijay.singh 14112 (1/28/2016)

---

Hi,

Thanks the quick Reply.

As My Table Structure, all are columns.

I Want ID to be pivoted and rest of the column value should also be pivoted accordingly.

Some_Derived_Column nameIDIDIDID

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

Value OF...

vijay.singh 14112 (1/28/2016)

---

Hi Experts,

-->Below is my table and Data.

CREATE TABLE #Temp

(

IDBIGINT,

SDIDBIGINT,

CountofrecordsBIGINT,

CountOfProductsBIGINT,

CountOfPrdCodeBIGINT,

SumOfSalesBIGINT,

TotalUnitstoBesoldBIGINT,

NumberofnotNotSoldBIGINT,

NumberofItesmBIGINT

)

GO

INSERT #TEMP

SELECT 1175388162,27,49407,875,3299,316333.7000,0,0,0

UNION ALL SELECT 1175388162,26,49415,874,3272,326385.6500,0,0,0

UNION ALL SELECT 1175388162,25,49415,874,3283,319124.3800,0,0,0

UNION ALL SELECT 1175388162,24,49415,875,3259,333208.3800,0,0,0

UNION ALL SELECT 1175388162,23,49415,874,3277,323890.4600,0,0,0

UNION ALL SELECT 1175388162,22,49415,874,3277,328882.6200,0,0,0

UNION ALL SELECT...

Take a look at transactional replication. Sounds like it might be a pretty fit for your requirements.