Use REVERSE, LEFT and LEN to find the position of the final hyphen, then use LEFT to return all the characters up to that point.

John

sqllearner44 (3/18/2016)

---

Also, if i see the long running spid, and have its details like what is running, the i/o details, cpu, is there anything i can do to see if...

So long as the server doesn't hold any of the databases that you'll be doing ETL on, then I'd agree that you're not likely to need a particularly sophisticated disk...

Are you talking about running SSIS on a different server from the database engine? Bear in mind that if you do that, you'll need to buy a separate licence....

Greg

Good, comprehensive article - thanks. Just one thing I thought I ought to pick up on:

When a session creates temporary table that contains a named constraint inside a transaction,...

The error message tells you where to look - it's in the sp_rename stored procedure. My guess is that "OBJECT" needs to go in (single) quotes.

John

So you want to match every job with every status? Just use a CROSS JOIN.

John

Adam

You don't say exactly what you're struggling with. I haven't read through those links that you posted, but what I'd do is have two separate packages. The first...

No, that doesn't do the same thing, and it's not recommended[/url], either.

John

Edit - ignore me. I was talking about something different. I wasn't aware of this option for...

Here's one popular solution[/url].

John

You can do that with dynamic SQL, or you can insert the values individually into a temp table or table variable and join to that.

John

GilaMonster (3/16/2016)

---

SteveD SQL (3/16/2016)

---

Also can I assume that if I had a SP that returned a larger results set I could pre-fetch the values to variables like below and...

Yes, if you must do it in the data layer instead of the presentation layer, an inline table valued function would perform better. Better still, why not create a...

Change the default database for sa to master.

John

SELECT name FROM sys.servers WHERE server_id = 0

SELECT SERVERPROPERTY('ServerName')

John