thanks boss

yes when ever bkp restoring records are inserting

plz help on dis...

thank u so much...........

here i am doing like dis

declare @tbl1 table (TBLID int identity(1,1),ID int,patientName varchar(10),age int,city varchar(100),Mobile int)

insert @tbl1(ID,patientName,age,city,Mobile) select 1,'Ramesh',20,'HYD',12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,12345678 union all

select 1,'Ramesh new',20,'HYDERABAD '...

declare @tbl table (TBLID int identity(1,1),ID int,patientName varchar(10),age int,city varchar(100),Mobile int)

insert @tbl(ID,patientName,age,city,Mobile)

select 1,'Ramesh',20,'HYD',12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,87654321

select * from @tbl

TBLID, ID,...

declare @tbl table (TBLID int identity(1,1),ID int,patientName varchar(10),age int,city varchar(100),Mobile int)

insert @tbl(ID,patientName,age,city,Mobile)

select 1,'Ramesh',20,'HYD',12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,12345678 union all

select 1,'Ramesh new',20,'HYDERABAD ' ,87654321

select * from @tbl

TBLID, ID,...

can u write a query plz plz

plz help out dis

please take below example

declare @tbl table (Col1 int,Col2 int,Col3 int,Col4 int,Col5 int,Col6 int,Col7 int,

Col8 int,Col9 int,Col10 int,Col11 int,Col12 int,Col13 int,Col14 int,Col15 int,Col16 int,

Col17 int,Col18 int,Col19 int,Col20 int,Col21 int,Col22 int,Col23 int,Col24...

how to create source control

using sp_helpdb <dbname> u wil get the size of db

then u proceed further

select dtStartDate,dtRunDate from #TestDates

cross apply (select top 1 * from #EnrollmentDates

where dtRunDate<=#TestDates.dtStartDate order by dtRunDate desc ) b

CREATE TABLE #SAMPLETABLE

(

DATECOL DATETIME,

WEIGHTS float

)

INSERT INTO #SAMPLETABLE

SELECT '08/09/2012',8.2 UNION ALL

SELECT '08/10/2012',9.4 UNION ALL

SELECT '08/14/2012',10 UNION ALL

SELECT '08/15/2012',9.6 UNION ALL

SELECT '08/16/2012',9.3 UNION ALL

SELECT '08/19/2012',9.7

declare

try this also

CREATE TABLE #SAMPLETABLE

(

DATECOL DATETIME,

WEIGHTS float

)

INSERT INTO #SAMPLETABLE

SELECT '08/09/2012',8.2 UNION ALL

SELECT '08/10/2012',9.4 UNION ALL

SELECT '08/14/2012',10 UNION ALL

SELECT '08/15/2012',9.6 UNION ALL

SELECT '08/16/2012',9.3 UNION ALL

SELECT '08/19/2012',9.7

declare...