Those somewhat contrived requirements make this sound like a homework assignment. Why can't you create any temp tables or new procedures?

John

I agree with what Phil says. And, while what you posted is syntactically correct, you don't need the BEGINs and ENDs except in the circumstances I mentioned earlier.

John

Yes. No. You can put as many commands as you like in a job step. If you want to be able to run each command individually, you...

What is the exact error message, please? Could the mystery columns be in the view definition... I assume that vwItemQtysOnHandAllItems_SQLViews is a view?

John

Joe

The easiest way is to use a FOR XML clause in your SELECT statement. There are lots of examples out there - search for concatentate aggregate function. You'll...

Well, you did post in the SQL Server 2012 - T-SQL forum! If you're on 2008 then you'll need to resort to self-joins in order to get values from...

You could write something that will loop through active connections and kill any that haven't done anything for longer than a particular period of time. Make sure you test...

Nader

I'm sure it's all in the documentation, but here's a summary as I understand it. DBCC CHECKDB doesn't take any locks that will cause blocking of use activity. ...

Data in a table doesn't have any inherent order. You need a column, or combination of columns, on which you can sort. The LAG and LEAD functions will...

Connect to lots of other servers so that the old ones disappear, I suppose. Or hack the registry to get rid of them. You'll probably be able to...

Then this is a good learning opportunity for you. You've already shown you can use LEFT and CHARINDEX. Read about LEN and REVERSE and what they do, and...

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....