Declare @detail table

(

grn_no varchar(55),

po_no varchar(50),

vendor_no numeric(10,2),

Formul_id varchar(50),

Adjust_code varchar(50),

adjus_value float

)

insert into @detail

values ('Grn/0001/14-15','po/00011/14-15/','5000','ED12','ED12','500')

,('Grn/0001/14-15','po/00011/14-15/','5000','CST','CST12','50')

,('Grn/0001/14-15','po/00011/14-15/','5000','CES6','CES6','5')

,('Grn/0001/14-15','po/00011/14-15/','5000','VAT','VAT','0')

, ('Grn/0001/14-15','po/00011/14-15/','5000','HCES2','HCES2','2.50')

Select grn_no, po_no, [ED12], [CST], [CES6], [VAT], [HCES2]

from

(

select grn_no, po_no, Formul_id, adjus_value

from @detail

) T1

Pivot (max(adjus_value) for...

Because you were getting the Primary key violation on...

Nice question. Thanks for sharing

hmmm seems to me that execution SP code is not actually the part of the SP itself, comment out the last line from the procedure,

and its always a good...

Koen Verbeeck (10/27/2014)

---

mohammedaala (10/26/2014)

---

Hello Team,

I have installed Sql Server 2008 R2 in my local machine and when I tried to open SSIS solution on my local machine I am getting...

Nice question Steve, checked on SQL SERVER 2012 working fine on that, do not know about 2014 thou.

Nice question. Thanks for sharing

great question Sean. Thanks for sharing

karen.blake (10/17/2014)

---

Thanks SSC will take a read!

Twin Devil yep, only they need to be able to specify as many words as they want, hence why the query is the way...

That's what i have understand so far.

Input string : John Smith

on the basis of this you need something like this

Where Name like '%John%' OR Name like '%Smith%'

Am i right...

Nice question. Thanks for sharing

Miles Neale (10/16/2014)

---

After 5 pages of bloviation we get to the point of saying This was an excellent question and another great opportunity to learn something. I have not...

Apologies everyone wrong radio button was selected ... Still wondering how.

As for the point, i would say ..

Sometimes in the real world, even if you are right you still...

glad to help, just edited the post for review.

+1, Koen. i-e One should always test the script.

but author intentions was right about the question so for this i would say nice question Jaime 🙂