Sean Lange (10/7/2014)

---

Oh no. I assumed he must be working backwards....

The WITH keyword can also be used in other parts of the TSQL language.

So the parser has to know if WITH is the first word in the batch. If it...

Where do you get the numbers for Qty?

Why is it 0 on the first line? Why is it -10 on the third line?

And so on...

As if regular spam wasn't annoying enough, one particalar user is now "spamming" the recent posts view with QotD threads...

The script will be slow because of the WHILE loop.

You already have a decent script to set-up the sample data:

DECLARE @Table TABLE

(

RowID int identity Primary Key,

DOCTYPE varchar(40),

DateCol datetime,

QTY int,

PRD varchar(10),

LOT...

Unfortunately that is true.

Here are all the options:

Concatenating Row Values in Transact-SQL[/url]

Why do you think it is not efficient?

SELECT YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + 1;

BWFC (10/7/2014)

---

No, it's not just you. Although you're going to have to keep a eye on the Recent Forum...

+1

I also don't really understand what you are trying to accomplish.

Select name from sys.tables where

DB1.CustomerID.dbo is not in DB1.CustomerContact.dbo

-->...

Interesting article, thanks.

Is it me, or are notifications not coming through?

BI_Baracus (10/7/2014)

---

I have managed to answer my own question. There were accounts that were local admins that had implied admin access. These were not being blocked out by the...

One more thing: maybe run sp_refreshview to update view metadata for views using those columns.