Answer Posted / vishal
with the help of pivoting....
it will solve the problem of grouping also
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get the definition of a view out of the sql server?
What is the difference between commit and rollback?
How to drop an existing user defined function in ms sql server?
What is the use of sign function?
Explain about Views?
why would you call update statistics? : Sql server database administration
What is report snapshot in ssrs?
How to filter out duplications in the returning rows in ms sql server?
What is rtm version in sql server?
Can group functions be used in the order by clause in ms sql server?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How do you test your database? : sql server database administration
Can You Use Data Mining Models In Ssrs?