vigneshlagoons (10/9/2013)
Hi Sean,I really appreciate it. I am new to this forum and new to SQL too and will do the one you tod me going forward. As of now this is all I have right now. Is there any way you can help me on this.
Moreover this is my original data that I have furnished here.
We are all willing and able to help but you have to help us by providing details to work with. I understand you are a bit overwhelmed since you are new to sql. That is ok, we can work with that.
There is no data here. All you provided was a few table names and the column names for those tables. We don't know what datatypes you are using and we have no idea what the data might look like. We aren't even really sure what you are trying to do. Once you provide the details for your question we can help you formulate an answer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/