I have worked for a sofware company focused on cross-platform ERP solutions and I think I can throw in my 2 cents.

Writing ANSI SQL is "per se" a pain, but...

Sorry for echoing, Gail.

What do you get when you request the filelist (filelistonly)?

I suppose the suffix "_new" is not part of the logical filename.

Try this:

;WITH messages AS (

SELECT mobile_number,

mobile_opt_in,

Row_Num = ROW_NUMBER() OVER(PARTITION BY mobile_number ORDER BY CAST(mobile_opt_in AS datetime) DESC)

FROM tbl_Messages AS A

INNER JOIN tbl_Mobile AS B

ON A.SWID = B.SWID

)

SELECT...

Write it by hand. There's a good example in the article I suggested.

Another option is downloading and installing SSMS Tools Pack[/url] and use the "generate insert statements" feature.

Great. Now post some sample data and you're done.

Be sure to post it as INSERT statement upon the tables you just scripted.

See the article in my signature if you're in...

I'll be glad to help if you at least try to post some table script and sample data.

This is the best place to start from if syntax is your issue:

http://msdn.microsoft.com/en-us/library/ms186858.aspx

I would suggest using ROW_NUMBER:

CREATE TABLE #tbl_Messages (

phone_number varchar(50),

time_stamp datetime

)

;WITH messages AS (

SELECT phone_number,

time_stamp,

Row_Num = ROW_NUMBER() OVER(PARTITION BY phone_number ORDER BY time_stamp DESC)

FROM #tbl_Messages

)

SELECT phone_number

FROM messages

WHERE Row_Num...

That page contains quite questionable statements. It's...

Andy in Pembs (5/21/2010)

---

Funny that Ben, just what I was thinking.

A very insightful piece, Phil, struck a chord with me.

Now this may be a little off-topic but understanding what...

tigriswoods (5/20/2010)

---

It's true I'm just past novice with SQL SERVER, and this article interests me a great deal, because we have many queries that are used to filter results...

jmerrill 28016 (5/20/2010)

---

If you rearrange each clause so that the test is

(@parameter is null or column = @parameter)

it won't ever look at the column...

Brett Robson (5/20/2010)

---

I don't see why you guys are promotiing the use of dynamic SQL. I'm often asked in job interviews when it's appropriate to use dynamic SQL - the...

Nils Gustav Stråbø (5/20/2010)

---

Dymamic SQL is the only efficient way (in my knowledge) to solve the problem with multiple optional parameters....