Search the Community

Sql Query: I need to compare data for 2 dates while using GROUP BY <InvDate> results in multiple rows like Row1 - InvDate1 | Sum(Data Col1) | Row2 - InvDate2 | Sum(Data Col1) | But I need like Row1 - Sum(Data Col1) for InvDate1 | Sum(Data Col1) for InvDate2 Kindly help resolving it! Thanks! Jenender

Hi, I am not sure how to write a query for the below case, Pls help me out. ID description values M1 ab1 23 M1 ab2 54 M1 ab3 23 M2 ab1 67 M2 ab2 56 M2 ab3 91 M3 ab1 41 M3 ab2 53 M3 ab3 27 M3 ab4 41 Conditions: I need to pick the row when values are same for different description under similar ID, Example: Under ID (M1) , I have the description (ab1 and ab3) have same values (23), Similarly ID (M3) have same values 41 for descripttion ab1 and ab4. hence the result must be only Red texted in the table. Thanks In advance.

Hi, Need help in code trying to find employees old positon number but the job table gives current row position number since the employee was rehired. Please help.

PLEASE HELP IN A QUERY. i AM TRYING TO DO SELF JOIN WITH A QUERY WHICH 2 OR MOR ELEFT OUTER JOINS IN IT. HOW TO DO SELF JOIN HERE . THANKS IN ADVANCE.

RcptNo Discoount ProductCode Price 111 10 1122 1000 111 10 1123 1500 111 10 1124 2000 123 20 1123 2000 124 30 1125 1000 124 30 1120 2000 I want This Result Rcpt No:111 Discount :10 TOT price :1000+1500+2000-10=------; By Which Query This Result can be Obtained

Hi I've been looking at the tutorial and spoken to a few people regarding a query which requires me to join two tables together and data within a specific data range. The environment I am running this in is SQL Server 2005. The following is the query I have tried to run: select *from individual (this is a table name)where update_timestamp <= 31/12/2008join delegate (this is a table name)as on member.member_ref=delegate.member_Refwhere start_date >= 31/12/2008 but when I run this, I get:Msg 156, Level 15, State 1, Line 4Incorrect syntax near the keyword 'join'. Someone advised me to try the following: select *from individualjoin delegateon member.member_ref=delegate.member_Refwhere start_date >= 31-dec-2008where update_timestamp <= 31-dec-2008 but when I do this, I get:Msg 156, Level 15, State 1, Line 6Incorrect syntax near the keyword 'where'. Can anyone advise me where I'm going wrong? If you require further info, please let me know. Thanks