Viewing 15 posts - 1,741 through 1,755 (of 11,676 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....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 5:44 am
Here are all the options:
Concatenating Row Values in Transact-SQL[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 4:45 am
Why do you think it is not efficient?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 4:37 am
SELECT YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + 1;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
-->...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 3:26 am
Interesting article, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 3:21 am
Is it me, or are notifications not coming through?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 3:00 am
BI_Baracus (10/7/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 2:10 am
One more thing: maybe run sp_refreshview to update view metadata for views using those columns.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 7, 2014 at 12:46 am
Viewing 15 posts - 1,741 through 1,755 (of 11,676 total)