Yes, but only to the first server. Find out why the connection to the second server is failing, and your package will then run...

I would strongly advise using the database layer to return the data, and the presentation layer to make it look pretty to the user. If you insist on formatting...

Looks like it's the concatenation part you're struggling with. Work your way through this[/url]. It looks quite daunting, but you should find something there that works for you.

John

Your query mentions at least one column that you didn't tell us about in your original post. Please will you post DDL in the form of a CREATE TABLE...

Please post what you've already tried so that we can see what you're struggling with. If it's getting the time difference, use DATEDIFF. If it's getting a corresponding...

Sysprocesses is a view of the processes that are running on SQL Server. You can't update it. If you want to stop any of those processes running, use KILL....

So you see that error message when you attempt to do the restore? Please will you post the RESTORE statement that you're running?

John

Well, you could fiddle about with an SSIS package or linked servers or similar wizardry, but I think the way I'd do it is to build the INSERT script on...

We can't see your screen, and we can't read your mind, so this is all guesswork, but how about this?

WITH Numbers AS (

SELECT n

FROM (VALUES (1), (2), (3), (4), (5))...

Something like this?

WITH Numbers AS (

SELECT n

FROM (VALUES (1), (2), (3), (4), (5)) x(n)

)

SELECT n

FROM Numbers n

JOIN T1 s

ON n >= Serial_Number

AND n <= End_Serial_Number

WHERE Serial_Number = 1

John

If you run a trace to capture failed logins, you'll get all sorts of extra information, such as the name of the application that's trying to connect (if the application...

drew.allen (5/26/2016)

---

You want...

You don't need table1 at all, do you, since everything is contained in table2? You didn't specify expected results, but here's a guess:

WITH Lengths AS (

SELECT

code

,code_name

,ROW_NUMBER() OVER (PARTITION BY...

DesNorton (5/25/2016)

---

If you need an editable "computed column" ...

Create a standard column [NICKNAME]

Create an INSERT trigger that sets [NICKNAME] = [LASTNAME] + ' ' + [FIRSTNAME]

Then the column is available...

Yes, that's true. You only want the actual key columns.

John