Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imgajin
Starting Member
5 Posts |
 Posted - 2010-10-22 : 04:21:33
|
| Hi, i am using C# + sqlserver 2005 . i have code in Ms access 2000 SQl query how to convert this ms access code to sql server query . anyone help me. TRANSFORM Sum(SAIZAN_M.tot) AS caltot SELECT SAIZAN_M.cuscode, Sum(SAIZAN_M.tot) AS tot1 FROM SAIZAN_M GROUP BY SAIZAN_M.cuscode PIVOT IIf([SAIZAN_M.nmonth]>"07","vin",[SAIZAN_M.nmonth]) In ("vin","07","06","05","04","03","02","01","00");ms access output================cuscode tot1 vin 07 06 05 04 03 02 01 0012345 17894 17894 |
|
|
Sachin.Nand
2937 Posts |
|
|
michael.appleton
Posting Yak Master
160 Posts |
Posted - 2010-10-22 : 04:39:54
|
| You're much better off doing this in the front end using C#. The database should fetch and perhaps process the data, not format it. |
 |
|
|
imgajin
Starting Member
5 Posts |
Posted - 2010-10-22 : 05:38:47
|
| i am really trouble this probs anyone guide me. |
|
|
|
|
|
|
TRANSFORM/PIVOT (Access to SQL) in SQL Server Prog