Hi - you've got some missing brackets here. You can either use:-

exec (@SQL)

or

exec sp_executesql @sql

If you use the second method you will have to declare @sql as ntext, nchar or...

crookj (4/30/2013)

---

Still talking very cool cars. Super hero...

+1 - thanks for the question

Hi,

Firstly, you need to link the servers, after that it is fairly straight forwards:-

select * from database.schema.table1

inner join server.database.schema.table2

on . . . . . .

You only need to specify...

Thanks for the question Hugo - nice and easy to end the week on

Id

Got my confirmation last week.

@WWDMark if it is as good as last years (my first) you'll enjoy it.

Know what you mean about the early start though!

Thanks for the question - easy point today

What is your criteria for the expected results?

The Name?

Id?

True - but they might deserve it

You may need to check the servers this runs on for what @@datefirst is otherwise a quick stab at this is:-

IF DATEPART(dw, GETDATE()) = 1-- any time on Sunday

...

Slight change of topic (if there ever was one here). Over the past few weeks I have been trying to help out more with the questions posted here.

All I can...

beat

carlosaamaral (3/21/2013)

---

Sean Lange (3/21/2013)

---

carlosaamaral (3/21/2013)

---

Logic ?

MID=(CASE WHEN ID-100=0 THEN NULL

...

Eugene, quite right about the coalesce - it could end up being very messy and involved more that one query.