For the explanations of the code, read the following explanations (Thanks Wayne and Skcadvre for your wonderful explanations)

http://www.sqlservercentral.com/Forums/FindPost962505.aspx and http://www.sqlservercentral.com/Forums/FindPost962922.aspx

Christy, first of all, excellent and fantastic way of posting a question, kudos to you. All things put in the right place.. awesome..

Now for the code that will do what...

:exclamation: ATTENTION Please : Two Year Old Thread

Try this:

SET NOCOUNT ON

DECLARE @Command VARCHAR(100)

SET @Command = 'dir /b /s '

DECLARE @Folder VARCHAR(100)

SET @Folder = 'D:\AS'

DECLARE @FilesInAFolder TABLE (FileNamesWithFolder VARCHAR(500))

INSERT INTO @FilesInAFolder

EXEC MASTER..xp_cmdshell @Command

; WITH CTE AS

(

...

naraayanan_1983 (9/14/2010)

---

HI Friends ,

I am new in SQL.I need a Query about FIFO and LIFO Method.My Table Structure is Hearder and Details.it's link to No .I have a one...

ROFL :hehe:

Paul, i dint quite understand ur requirement.. did u mean, u need to hardcode a column as NULL in the SELECT ?

Welcome , Sheff.. 🙂

As a side note, did u prepare a solution for this? I would love to look at your piece..

Thanks for the feedback,...

vivek.verma (9/14/2010)

---

@ColdCoffee

Hey thanks it worked like a charm and code is also too well explained, and don't know how you got it that somewhere my requirement will be data for...

+1

Why not ? take a look at SQLCMD and OSQL command line commands in Books Online (free help that comes with your SQL Server Installation)

This might help you:

http://jimbojw.com/wiki/index.php?title=SQL_2005_-_Why_You_Can%27t_EXEC%28%29_Inside_a_UDF

I was telling the OP to have a look at that from the start Jeff,...

ROFL.. LOL.. :-D... A coffee-machine break could spell disaster i guess.. FULL OUTER JOIN can accomplish that task with minimal lines of code 😀

; WITH BPM_CTE AS

(

SELECT -- List...