Cross-Tab reports in SQL Server 2005

Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT.

What is the result of

DECLARE @var AS...

What's wrong with this query?

select
category_nm
, q.category_id
, count(*)
...

What would this match in a regular expression?

^(com|net|edu|org)

In SQL Server 2000, are GUIDs created with...

Deleting Sets of Rows in huge table

There was a problema user was reflecting http://groups.yahoo.com/group/sqlcon/message/1119What I did was following steps1. Divide the count of table into segments for divide2. Then use the even Odd functionality for smooth looping3. Use a simple while loop and SET ROWCOUNT functionality for further deletions across table with checkpoint4. It saved the log swell up and resources […]

Which result is returned?

Select
Case
When Round(convert(float,1.135), 2)...

What results do you get from this?

SELECT...

Scrip to export excel file in a Loop

Script to Get Exl Output in a Do while loop. Example taken is Authors table in PUB database, where excel is generated for each state the file in state name.U can modify the script to include filename in u'r format (eg. state + date)

Global System UDF to return ISO Date string

Updated for Permission assignment change 1/11/1006. Ok, I'll bet that you are asking, What is a Global System UDF, right? By Global I mean that the UDF is available from any database on the server. By System I mean that the two part naming rule does not apply to this scalar function. The UDF conversion […]