THIS IS AN EXAMPLE WHICH I HAVE USED...

I HOPE THIS SCRIPT WILL HELP YOU OUT....

-- Delete duplicate records with out temporary tables.

CREATE TABLE #phonebook (

[phonenumber] [varchar] (30),

[firstname] [varchar] (30),

[lastname] [varchar]...

It means that you are not getting an SQL Server connection. If you are using a linked server into an stored procedure then you have to add that server in...

--This will ceate a folder .. this might just help you by doing some changes....--

DECLARE@wk_no VARCHAR(2)

DECLARE@Path VARCHAR(100)

DECLARE @md VARCHAR(100)

SET @wk_no = DATEPART(wk, GETDATE())

SET @Path...

USE Northwind

GO

CREATE TABLE [Employee]

(

[ID] [int] NOT NULL ,

[Name] [nvarchar] (10) NOT NULL ,

[Salary] [money] NULL ,

)

GO

INSERT INTO Employee VALUES

(1, 'Dinesh', 1500)

(1, 'Dinesh', 25000)

(1, 'Dinesh', 15000)

SELECT * FROM Employee ORDER...