This all depends on how you want it set up, but is fairly easy.

I'm going with an assumption, right now, that you want your users to be able to navigate...

Robin35 (11/1/2016)

---

John Mitchell-245523 (11/1/2016)

---

Thom's right. Go to the Security tab on your Linked Server properties and change the connection to Be made using this security context, and enter your...

Glad to see my brain is still working, even after waiting 2 hours for my flight, with another 4 to go! I was pretty sure it had given up when...

Linked Server Properties.

"Frame" possibly wasn't the beat choice of word sorry (what I get for poking in Web Dev recently). I mean that you use an object which has a grouping on...

If you wish to use a SQL Login, and haven't set these up, you need to define these settings. You can find them in your Server Objects, Linked Servers, then...

Is Server1 the Server that is running the job? You should really be using a real account, rather than default if you need to authenticate to other areas of your...

Seems like you don't have the login credentials set up correctly for the user running the agent task, as it's trying to authenicate to the other server as Anonymous.

Does the...

If I'm reading your SQL right, you're declaring a Parameter/Variable as a Table name "FROM ?". This won't work. A parameter needs to be a parameter.

If you need to use...

I therefore assume your SSIS package SQL task is expecting a Single Row Result set then?

COALESCE (T-SQL) would work for you then.

Edit: Added link.

Why not use COALESCE around the SELECT statement? Why is it in a sub query, instead of in the FROM clause?

Just...

Although format is easy, if you're applying this to a dataset, I heavily recommend against it. You'll find it to be incredibly slow.

What you're looking for here is a Calendar/Tally table[/url].

Yes., There's a few different ways, for example:

SELECT GETDATE() AS CurrentDateTime,

(DATEPART(HOUR, GETDATE()) * 10000) + (DATEPART(MINUTE, GETDATE()) * 100) + DATEPART(SECOND, GETDATE()) AS...