Tag Archives: Microsoft

SQl Server 2005 Reporting Services – Charts

Posted by on March 21, 2008 Comments Off on SQl Server 2005 Reporting Services – Charts

Found this link that give a deep-dive into fomat and functionality of charts in SSRS 2005.  Adds a lot to making charts meaniningful and jumps to details.

TechNet Article:
More

SQL Server Data Services (SSDS)

Posted by on March 16, 2008 Comments Off on SQL Server Data Services (SSDS)

SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning.

From : Main SSDS Site

InfoWeek: InformationWeek Site

Detailed Blog with Info From Mix08

http://davidhayden.com

Query Syntax – Etc

http://dunnry.com/blog/

A Bit More

http://dev.live.com/blogs/devlive/archive/2008/03/12/220.aspx

Linked Server Example from Original Site

Posted by on February 28, 2008 Comments Off on Linked Server Example from Original Site

Older article/post on Linked Server functionality in SQL Server 200-2005 and 2K8.

https://jackdonnell.com/articles/linked_Serv.htm

I mostly  use the OpenQuery() select statments to get to MySQL and other platforms. Watch your security Model!

Group By and Case Statements or Other SQL Functions

Posted by on February 28, 2008 Comments Off on Group By and Case Statements or Other SQL Functions

One thing I forget to do often is to include the actual item I’m returning in the Select Statement in the Group By. Meaning , if I use a case statement of some function to change the value that I’m returning, then I should include that and not the base column name in the Group By part of the select statement


/*
If you write something like this and the Col2 has multiple 'Unique' Values
then you will get a row for each value distinct Col2 value that says 'Other'
*/SELECT [Col1]
,Case When [Col2] = 10 then 'Ten'
Else 'Other' End as [LameExample]
,Count(*) as CNT
FROM [dbo].[lameTableExample]
GROUP BY [Col1], [Col2]

-- This Example will return Only two rows

SELECT [Col1]
,Case When [Col2] = 10 then 'Ten'
Else 'Other' End as [LameExample]
,Count(*) as CNT
FROM [dbo].[lameTableExample]
GROUP BY [Col1]
, Case When [Col2] = 10 then 'Ten'
Else 'Other' End

Select Case has a simple overview of using CASE in a SQL Query with the SUM() function.