Still very very unclear buddy.. can u post some sample query or visual samples of your requirement in accordance with the sample data i posted??

Ok,as i had some free time, i understood only something from your post and here is the code u are looking for (presumably).

My assumptions from your post :

1. U have...

Mate, if u update the salary > 5000, it will constantly update everywhere. I dont think u need to search for values > 5000 in every department and update.. just...

Yes there will be... but before that,...

Yes!!

Buddy,please go through this following article and helping us help you?? 🙂

FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do...

Kavali, will your customer be providing the table name for which they will be giving the column value ???

Try this if it works for you?

The below will copy the table structure as well as the data from

DATABASE_A.SCHEMA_NAME.TABLE_NAME to DATABASE_B.SCHEMA_NAME.TABLE_NAME

SELECT COLUMN_1,COLUMN_2, ETC ETC ETC

INTO DATABASE_B.SCHEMA_NAME.TABLE_NAME

FROM DATABASE_A.SCHEMA_NAME.TABLE_NAME

The below...

You have given create table statements, alrgiht, but what of the sample data and a more clearer requirement mate?

how about you going through this following article and helping us help...

Will you be passing the column name or the value for a column? it will be terribly to find every relationship with just a single interger value...

please throw more light...

1. Use ROW_NUMBER() function to dynamically allocate "ranks" to the result set (ORDER BY your column of course)

2. Handle the top 20 in your WHERE clause, like, WHERE ROW_NUMBER BETWEEN...

Something like this will help you

WITH CTE(ROW_NUM , ID) AS

(

SELECT ROW_NUMBER() OVER(ORDER BY USERID) ROW_NUM, USERID FROM YOUR_TABLE

)

SELECT ROW_NUM, ID FROM CTE WHERE ROW_NUM IN (1,2,3)...

Any poster who posts al the necessary scripts that will make the people here ready to find a solution , are awesome too..

So whenever u post, post the full requirement...

Hey vaibhav...

Tel me if this is the code u wnated

;WITH I_AND_U (ID)

AS

(

SELECT

DISTINCT s.ID

FROM #Schedule_Audit s

INNER JOIN

(

...

Vaibhav, pls correct me if my understanding is wrong

1. You need "I" rows that have atleast one "U" and present them.

2. For any "I' row that dont have a corresponding...

Hi Buddy,how about you going through this following article and helping us help you?? 🙂

FORUM POSTING ETIQUETTES - JEFF MODEN[/url]

When u do so, i am sure a lot of us...