March 14, 2012 at 10:18 am
Hi,
I am a beginner and don't know where to post my problem, hope i have posted it right. waiting for solution.
I have table with column wise record
example
column name as = idno, Name, April, May, Jun...March_,... Total
Record as = 1, ABC, 1, 2, 3, 4,... 12
and the second table where records are column wise
example
column name= idno, Name, Month , Year, Sub_amount
Records as = 1 ABC, May , 2012 100
second record= 2 ABC June 2012 200
now i want to insert and update the destination table as
column name as = idno, Name, April, May, Jun....March,... Total
Record as = 1, ABC, 1, 0, 0, 4,... 12
means the destination table should have the same structure and content as first table .
but after checking from the second table if records are found for that months for a person then update the amount with 0 for the matching month.
hope i am able to explain the problem correctly.
hoping for a faster response.
Regards
March 14, 2012 at 12:15 pm
Duplicate post, please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1266908-338-1.aspx
_______________________________________________________________
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/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply