Example of recursive common table expression (CTE) to display multiple levels of recursion is given below.

USE AdventureWorks;

GO

WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS

(

SELECT ManagerID, EmployeeID, 0...

Hi Ramesh,

Read BOL for the exact info.

A common table expression (CTE) provides the significant advantage of being able to reference itself, thereby creating a recursive CTE. A recursive CTE is...

Hey Vinoth,

Try this:-

DECLARE @Date datetime

SET @Date = '07/11/2008'

SET @Date = DateAdd(mm,6,@Date)

SELECT @Date Date

Hi,

Why are you creating stored procedure for this?

Instead you can create script like:

IF DB_ID('Database1') IS NOT NULL

DROP DATABASE Database1

GO

CREATE DATABASE Database1

GO

CREATE TABLE Database1.dbo.Table1(id int)

CREATE TABLE Database1.dbo.Table2(id int)

GO

IF DB_ID('Database2') IS NOT...

Since the format of new_table is determined by evaluating the expressions in the select list, I am not sure Indexes will be maintained in new_table.

You need to create the indexes...

Hi

The SELECT INTO statement creates a new table and populates it with the result set of the SELECT statement. SELECT INTO can be used to combine data from several tables...

DECLARE @T TABLE (ID INT)

INSERT INTO @T

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT -1 UNION ALL

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT -1

SELECT MIN(ID) MinVal...

Hi Madam Curie,

No problem at all. In a Stored Procedre, scope of Temp. Table is only inside the procedure. Outside of procedure, Temp Table will not exist.

One more thing, every...

Hi Pzmrcd ,

I think you are talking about subscription of reports.

First of all you need to deploy the report at reportserver.

After Deployment, you can schedule the report at reportserver using...

Hi Venm,

First of all you need to create a Temporary Table and insert the result of Stored Procedure in that table. Now you can use this table in WHERE...

Hi Sanuj,

First of all check for the tables which has field EmployeeID:

SELECT O.Name TableName,C.Name ColumnName From sys.Objects O

INNER JOIN sys.Columns C ON C.OBJECT_ID=O.OBJECT_ID

WHERE C.NAME LIKE 'EmployeeID' AND type_desc='USER_TABLE'

Now you can...

You can show the reports using .NET also.

See this article for some examples:

http://odetocode.com/Articles/95.aspx

Hi Aysegul,

You can Deploy the Reports and access the reports using IE browser

After deploying reports just type "http://ServerName/reports" in IE 6.0 or later version and view the reports.

Its simple to achieve.

You need to create one more parameter for your second reports.

Pass the field value of orderID to navigated report.

Also you need to change Query/Procedure of your second...

I think you are talking about Drill through reports.

First you need to create that report where you want to navigate from current report.

After completion of that report, just click on...