Strictly speaking, it isn't. A unique index can allow NULL...

That's only going to show the permissions he or she has on [dbo].[StoredProcedureName]. Try removing the first line of your WHERE clause and see what you get then.

Is this...

Yes. In Example 1, you've got the extra expense of compiling the query because it's more complex (it involves a join), and also of actually retrieving the values from...

select * from RS_Patient_6

where MyDatabase.MySchema.PatientID_6_660 = ‘<patient id>’

John

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