The sample codes used by Gogula Aryalingam for the session titled T-SQL Q&As II at the 15th SS SLUG meeting.

Slideshow used by Gogula Aryalingam (MVP) for the session T-SQL Q&As II at the 15th SS SLUG meeting. Contents included are in Office PowerPoint 97-2003 (ppt) and Office PowerPoint 2007 (pptx) formats.

Sample code used by Dinesh Asanka for the discussion titled T-SQL Enhancements in SQL Server 2008 at the Heroes {Community} Launch. Requires SQL Server 2008.

Slideshow used by Dinesh Asanka for the discussion titled T-SQL Enhancements in SQL Server 2008 at the Heroes {Community} Launch for SQL Server 2008. Includes PowerPoint files in Office 97 - 2003 (.ppt) and Office 2007 (.pptx) formats.

DECLARE @TABLE TABLE(    EmpID CHAR(3)    ,Category CHAR(1))INSERT INTO @TABLE VALUES('101','A')INSERT INTO @TABLE VALUES('102','B')INSERT INTO @TABLE VALUES('103','C')INSERT INTO @TABLE VALUES('104','A')INSERT INTO @TABLE VALUES('105','B')INSERT INTO @TABLE VALUES('106','C')INSERT INTO @TABLE VALUES('107','D')INSERT ...

This post is to discuss and rate the article T-SQL Enhancements in SQL Server 2008 - Part 2 by Dinesh Asanka.[Poll]

Interestingly today we found that on certain situations the following query worked better than the query I submitted.  (SQL 2000).  It is not always, but there is a difference at times.  I have not explored the reasons yet.  but a heads up so that you all can start a research on the best method SELECT * FROM (    ...

This thread is for the article T-SQL Enhancements in SQL Server 2008 Part I by Dinesh Asanka. Rate it and give your feedback.[Poll]

Hi, I have to agree with Preethi about dynamic SQL.Manjuke, you could try something like this if you need to avoid the dynamic SQL bit in your example: Use a user-defined table-valued function that would break the string at the commas and return a table containing a single column of the values specified in @spParam This user defined ...

In our last user group meeting, we discussed lot about DATE and TIME issues  And here I am posting one link which talks about “Getting the Date portion of a DateTime type in SQL (T-SQL) - Use Floats and Floor!”. It is worth to read guys…