Yes Recursive queries add a lot easiness to the t-sql development.

I had built a recursive split function, a numbers table, etc.

Or you can query on hierarchical data on a singe...

Hello,

Actually the definition of a stored procedure includes that it is formed of a number of sql statements forming a batch of t-sql statements.

You can even call numbers of other...

Hello,

I think we can also handle this taks by using the sp_MSForEachTable and sp_MSForEachDB un-documented stored procedures .

Hi jac,

What you see as data type by calling the sys proc sp_columns in the type_name column is the backward compatible ODBC type of the related sql type.

Eralper

T-SQL Development

Hello,

I could not actually understand what you are expecting but you can review to the new Grouping Sets improvement in SQL2008 or for using Rollup and Cube in your groupings.

You...

Hello,

I have created two select statements listing accessed databases and non-accessed databases according to the processes running on the SQL Server for SQL2005 or SQL2008

Here is the two select statements

with...

Hello all,

I agree with Matt since a select count(*) is not quickly handled operation if you do not have indexes on a huge table. So if the source table we...

Hi,

In the readme file I saw the below note. I'm not sure but may be helpfull.

If you decide to take the described action, please take your backups. I did not do the...

Hi David,

As far as I know you can only use a CTE just after you define it.

Eralper

http://www.kodyaz.com

Hi,

I don't know the term "forward-referenced", sorry.

Today a new article of Srinivas is published under the link,

http://qa.sqlservercentral.com/columnists/sSampath/recursivequeriesinsqlserver2005.asp

This article summarizes the recursive usage of common table expressions very well with...

Hi Jamie,

I copied straight out of the BOL.

I tried, it is working.

About the semi-colon, we need it before the WITH, if there is an other sql statement then the...

Hi all,

In the BOL for SQL Server 2005 Beta 2 (Yukon) the given example is

USE AdventureWorks

GO

WITH OrderedOrders AS

(SELECT SalesOrderID, OrderDate,

ROW_NUMBER() OVER (order by OrderDate)as RowNumber

FROM Sales.SalesOrderHeader )

SELECT *

FROM...

Thanks Srinivas,

Very good description of recursive common table expressions and great sample for getting hierarchical data with a defined value of drill down levels (sample 1).

I liked the sample 1....

Temporary tables are kept until you drop them or the session is closed. And you can use them repeatedly within the session.

But CTE is only used by the Select, Insert,...

You can use variables in CTEs.

Below there is a sample you can widely meet in Yukon T-SQL enhancements in SQL Server 2005 books.

Note that you should use ";" after any sql...