no I am just thanking for the help lol

Hello,

This works thank you very much... A ++ SUPPORT !!

Hello,

below are the tables with sample data which you can use it!!

CREATE TABLE [dbo].[googlewords](

[ID] [int] IDENTITY(1,1) NOT NULL,

[WordsName] [varchar](100) NULL

)

INSERT INTO [dbo].[googlewords]

...

Hi,

I have attached an attachment, which would be easy to explain me how i want the data.

Thank You

yes I can link more than one server but what if like in my case I have linked the server having database AA with its login details now when I...

ok, here is the explanation

the server to be linked has two databases namely database AA and database BB and both has two different logins, so when I link server using...

yes, I have linked the server by going into server objects but here is the problem database AA and database BB has different login but if you go through server...

try in this format

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'servername',@useself=N'False',@locallogin=NULL,@rmtuser=N'user',@rmtpassword='password'

GO

sorry my data was bad in the rows so didnt get correct results, but this queires helped me a lot..

thanks you guys !!

for eg.

[productname] = U3300/I

[categoryname] = GUCCI

[brandname] = Sunglasses

[colorcode] = CO3

[colorname] = black

if this exact matches with another row having same values then it should give result in resultset for SELECT...

I tried it but I am not getting correct result my problem is if values in [productname] and [colorcode] and [colorname] and [categoryname] and [brandname] matches with another row having...

Eugene Elutin (6/2/2010)

---

biren (6/2/2010)

---

Eugene Elutin (6/2/2010)

---

Basically, my sample does exactly the same:

It copies some records from Table_B to Table_A (condition is in WHERE clause) and at the same time it...

Eugene Elutin (6/2/2010)

---

Basically, my sample does exactly the same:

It copies some records from Table_B to Table_A (condition is in WHERE clause) and at the same time it deletes these copied...

basically what I am doing in here is Order_B is my live table which consists of the Order Details Data as shown in query, what I am doing is I...

elutin (6/2/2010)

---

Try this method:

create table #Table_A

( id int not null identity (1,1)

,val varchar(30)

)

create table #Table_B

( id int not null identity (1,1)

,val varchar(30)

)

...