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

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

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

WayneS (4/9/2010)

---

Nuts, do you see how things work better when you supply code that shows the problem? A lot of people that wouldn't bother with your problem suddenly jump in...

xp_Dirtree , an extended stored procedure looks like a very good option to check for the files and folder in directory. 🙂

I think nguyennd has got the code you wanted...

Cheers!!