Viewing 15 posts - 1,741 through 1,755 (of 11,678 total)
Sean Lange (10/7/2014)
GilaMonster (10/7/2014)
Sean Lange (10/7/2014)
The upside is the end of the list should be approaching fast. 😀He's up to 2007. 🙁
Oh no. I assumed he must be working backwards....
October 7, 2014 at 12:46 pm
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...
October 7, 2014 at 7:41 am
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...
October 7, 2014 at 7:29 am
As if regular spam wasn't annoying enough, one particalar user is now "spamming" the recent posts view with QotD threads...
October 7, 2014 at 7:16 am
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...
October 7, 2014 at 7:11 am
Ed Wagner (10/7/2014)
I only got 4 notifications overnight, which is a little light. Then again, I think overall traffic on the site has been down lately.
Unfortunately that is true.
October 7, 2014 at 5:44 am
October 7, 2014 at 4:45 am
SELECT YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + 1;
October 7, 2014 at 4:36 am
BWFC (10/7/2014)
Koen Verbeeck (10/7/2014)
Is it me, or are notifications not coming through?
No, it's not just you. Although you're going to have to keep a eye on the Recent Forum...
October 7, 2014 at 3:45 am
pietlinden (10/6/2014)
... and I'm having a hard time understanding what you want.
+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
-->...
October 7, 2014 at 3:26 am
Interesting article, thanks.
October 7, 2014 at 3:21 am
Is it me, or are notifications not coming through?
October 7, 2014 at 3:00 am
BI_Baracus (10/7/2014)
October 7, 2014 at 2:10 am
One more thing: maybe run sp_refreshview to update view metadata for views using those columns.
October 7, 2014 at 12:46 am
Viewing 15 posts - 1,741 through 1,755 (of 11,678 total)