unpivot issue

-

hi excel have source below..

kindly me on unpivot , move table

location total avail opt sold avail opt sold avail opt sold avail opt sold
india 132 62 9 61 66 3 63            
china 66 20 1 45 24 0 42            
usa 49 10 0 39 11 0 38            

shanmugaraj

the number of columns with avail opt sold are  dynamic , can grow on each week / month .. 

hi shanmugaraj,

below link helps in unpivoting data excel , move table

http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/

regards

naveen



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

Motherboard replacement

-
running windows 10 technical preview, need replace motherboard can run the  sysprep  command restoring pc ? or there easier  or more preferred way ? thanks if replace motherboard within same family of chipsets (i.e. intel > intel or amd > amd), should okay restarting pc twice. carey frisch Windows 10 Insider Preview  >  Windows 10 Insider Preview General
Read more

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder. ...
Read more

Remote Desktop App - Error 0x207 or 0x607

-
hi all, i manage windows 2012 r2 network, including connection broker, session hosts , remote apps virtual servers.  i've used remote desktop app on own android phone, no issues @ - connects published gateway url , can login , access network. we looking move business onto nokia handsets ms operating system (currently on blackberry), not able connect via remote desktop app on nokia lumia handset. setup, per android config , brings remote apps , remote desktop screen, know can connect.  when select remote desktop, shows following process: initiating remote connection securing remote connection certificate can't verified - choose connect it digitally signed cert (digicert sha2), pc name different physical connection broker name (inherited domain name old gov project - can't publish publicly) initiating establishing securing connection error have been 0x207 getting 0x607 a bit baffled, work on android (and ipad @ home using app). assume ms use d...
Read more