Hi

Can you provide with some data of each table so that i can get some idea...

for the time being if any side of the column have null value result will...

Hi sqlserver12345

Your query seems have more records of same IDs in the left outer joins means if there is ID=1 in base table and 3records in left table then it...

Hi Bro

I really not getting what you want. if you want to know the names of the columns that are present in each of the tables then you can...

Try out this....

DELETE FROM TABLE1 WHERE ID IN(

SELECT COUNT(ID) AS ID

FROM TABLE1

GROUP BY ID

HAVING (COUNT(ID)>1))

I have one dount that you want to delete all the records that are duplicat or...

There is no way that records are not getting inserted into other table

Reasons would be

1. May be your appllying some where caluse that may reduse some records

2.May be Table A...

Hi Ninja's_RGR'us

Yes your correct but its just an example i know we need have filter i just want to ask how to create index over the query which have joins...

Hi Lexa

Have you ever tryied

exec sp_help

or

exec sp_helpdb

hope either of this sp will solve out your problem.

Hi kramaswamy

I am not so sure what this would help you but my simple suggestion and straight forward suggestion

steps

1.is to create 2 temp tables

3.select the query such as

...

Hi Bro

Its never in a chance or requirement where u may need 1m records even if so then those many records are never been viewd.Just make sure what you actually...

if exists(select 1 from table where primarykeycolumns = ???)

begin

Update table set columns = values

end

else

...

Hi

Need clear picture what u exactly want from the query.

Dear damirmi

My simple question is how do you identify which are the number that have already used of. If i am not wrong all the usernumber that are in table...

Thanks a lot lot and lot and sorry for my foolishness as i am not in right mood to do work so getting completed worng but u both made me...

Thanks again dev but still i am facing a big problem when i am trying to update a single record tigger is updating getdate() for all the records in that...

Dear Friends

I have tried dev code with some change to effect my code so here the trigger is

CREATE TRIGGER Trgr_Update_LastModifiedOn

ON SERVERINFO

AFTER UPDATE

AS

BEGIN

IF EXISTS(SELECT *

FROM SERVERINFO S

INNER JOIN...