Hi

Create a temporary table and insert records in to this table...

compare both the table and remove duplicates from the temporary table.

do insert from temporary table to your destination table.

thanks

jaypee.s

Hi

select * from #test where val like '%/%%' ESCAPE '/'

Refer this link, if you want more clarification

http://msdn.microsoft.com/en-us/library/ms187489.aspx

Thanks

jaypee.s

hi

This link may be useful to you

http://www.singingeels.com/Articles/Pagination_In_SQL_Server_2005.aspx

Thanks

jaypee.s

Hi

Create a script with all constraints from SERVER A, where you have set of table.. and

create a linked server between these two servers (ie SERVER A and SERVER B).....

Hi

It is better to maintain holiday table,with date and description.

Thanks

jaypee.s

Hi

You can try like this. i guess it will solve your problem

select distinct a.* from INFORMATION_SCHEMA.COLUMNS a

where a.column_name not in (select column_name from INFORMATION_SCHEMA.COLUMNS b

where b.table_name in ('stp_rule_dtl') )...

Hi

Check this link

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56713

Thanks

Jaypee.s

Hi

This may helpful to you...

CREATE TABLE #a

(month int,

year int,

teamnum int,

ext int,

avgholdtime int,

totsci int,

totalavgholdtime int )

INSERT INTO #a VALUES (2,2008,1,200,1000,20,0)

INSERT INTO #a VALUES (2,2008,1,300,2000,40,0)

INSERT INTO #a VALUES...

Hi

USe this as example... Create a trigger.

CREATE TABLE Customers

(FirstName varchar(30),

MiddleName varchar(10),

LastName varchar(25),

City varchar(10),

Country varchar(2),

CONSTRAINT PK_CustomerName PRIMARY KEY (FirstName,LastName))

CREATE trigger country_upper

ON customers

FOR INSERT, UPDATE

AS

update c

set c.country = UPPER(c.country)

FROM customers c

INNER...

Hi

Here the concept is to

SET IDENTITY INSERT ON and SET IDENTITY INSERT OFF

Please check the link, i guss it will solve you problem,

http://www.sqlteam.com/article/how-to-insert-values-into-an-identity-column-in-sql-server

Thanks

jaypee.s

Hi

declare @i as varchar(25)

declare @sql as varchar(8000)

set @i =4

set @sql ='select top '+@i+' * from dbo.type_master'

exec(@sql)

Hi

Create a full database backup and restore in the new database.

Thanks

Jaypee.s

Hi

This link may be usefull.

http://www.sqlservercentral.com/Forums/Topic490100-359-1.aspx

Thanks

jaypee

Hi

i guess this will help you.

Use this as example

SELECT server as 'Server', [name] as 'Job Name', CONVERT(datetime, SUBSTRING(CAST(run_date as varchar(8)),1,4) + '-' + SUBSTRING(CAST(run_date as varchar(8)),5,2) + '-' +...

Hi.

Check this link.. u may get the solution

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21443432.html

Thanks

jaypee