Pravin Vetal (6/10/2008)

---

Hi Shrikant,

Thanks for your reply.

I have already used that logic for the merging of the recordss. The problem is it is utilising 100% cpu.

But I think we can...

Hi Pravin,

I hope following steps would help you.

1. Write BULK insert script to load data in 2nd table. (Assuming this table is heap)

2. Create Non unique clustered/non-clustered...

Hi sudhakara,

Can you elobrate why do need to move Index? What is problem with Create Index later on table on newdb? I am hoping that you are running query...

create table TABLE1 (IdTemp int, TempDate datetime)

create table TABLE2 (IdTemp int, TempDate datetime)

insert TABLE1 select 1, '2008-01-01'

insert TABLE2 select 1, '2008-01-01'

insert TABLE2 select 2, '2008-01-02'

DECLARE @TempTable...

Hey chris,

Checkout BOL for set ANSI_WARNINGS, Microsoft have made these points very clear.

 

1. ANSI_WARNINGS is not honored when passing parameters in a stored procedure,...

thx David!! guys correction: please read Accent instead of Accent 

I wish a happy Independence Day to all on behalf of all Indians!!! Our datacenter group is undergoing US Ascent training,...

Its cool lowell!! gr8!!  

sp_helpindex will give index keys with comma separated, instead use sp_MShelpindex. 

 

create table #table1(name varchar(1000),status int,

indid int,OrigFillFactor int,IndCol1 varchar(128),IndCol2 varchar(128),IndCol3 varchar(128),

IndCol4 varchar(128),IndCol5 varchar(128),IndCol6 varchar(128),IndCol7...

..110% agreed sir!!! No one would think of writing such an useless code.I just wanted to know if a piece of code works on...

I thought that SP2 would make this scenario workable but I am getting same exception after upgrading SQL Server 2005 to build 2153. Have a look at following script, please note...

merge command is still not available in SQL 2005. You have to

1.Update destination table based on matching key vaules of first

Update destination

set col1=s.clo1, col2=s.col2

SQL Server does not have Create table xxx as select ... instead use select into or create table and then Insert into select statements. I always perfer to use select...

If I am not wrong with logic, you can have below t-sql script executed by sqlcmd rather than having a vb program to write the logic and execute. sqlcmd(OLEDB connetion) is much...

you should use OPENXML, which provides rowset over XML-document which is similar to view or table. checkout following example

DECLARE @idoc int

DECLARE @doc varchar(1000)

SET @doc ='

<ROOT>