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...

Vaibhav, can you give us some sample output rows inline with your sample data u have provided.. some visual representation of how your desired result set must be...

Hey padmaja,

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...

Hey buddy, here is one piece of code.

I think Lowell and steveb. let out one tiny thing in your request , that is, to add the part of the string...