Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to change order of variable that contains array of dat
prabhu p
Feb 5 2016 10:54 AM
312
Reply
Iam writing stored procedure in that iam using pivot for columns and assign columns to variable
@sqlquery1 = jan2015,feb2015,march2015
@sqlquery2 = jan-Transferdate,feb-transferdate,mar-transferdate
Iam calling this two variable in select statement like '+@sqlquery1+','+@sqlquery2+' but out came like
jan2015,feb2015,march2015,jan-Transferdate,feb-transferdate,mar-transferdate
but i need out put like
jan2015,jan-Transferdate,feb2015,feb-transferdate,,march2015,mar-transferdate
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Union and Joins
Join 3 tables and fetch for latest record from 3rd table