Viewing 15 posts - 1,396 through 1,410 (of 11,676 total)
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2014 at 12:39 am
Beeeuuuuuuhhh...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 17, 2014 at 12:36 am
Jason-299789 (11/14/2014)
Koen Verbeeck (11/13/2014)
ps: the semicolon is a statement terminator, it has no...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2014 at 12:04 pm
The CTE should be followed by a SELECT, INSERT, UPDATE or DELETE statement, not by an IF statement.
ps: the semicolon is a statement terminator, it has no business being there...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2014 at 3:25 am
This article explains the most of it:
Understanding SQL Server Backups
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2014 at 3:22 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2014 at 12:34 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2014 at 12:30 am
Jeff Moden (11/12/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 1:33 pm
Linked servers typically perform worse than queries in the same instance.
Personally I try to avoid them at all costs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 7:46 am
Eirikur Eiriksson (11/12/2014)
Koen Verbeeck (11/12/2014)
Eirikur Eiriksson (11/12/2014)
Koen Verbeeck (11/12/2014)
David Burrows (11/12/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 6:56 am
Eirikur Eiriksson (11/12/2014)
Koen Verbeeck (11/12/2014)
David Burrows (11/12/2014)
However max(rate) over( partition by product) will not work if the rate varies +/- and the latest value by date is needed
In that case...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 6:42 am
arunnrj87 (11/12/2014)
Hi Phil ,Please reply
Please be aware that this is a forum of volunteers, where most of them have day time jobs as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 6:26 am
David Burrows (11/12/2014)
However max(rate) over( partition by product) will not work if the rate varies +/- and the latest value by date is needed
In that case an ORDER BY on...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 6:25 am
Ed Wagner (11/12/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 6:09 am
SELECT Email = 'a@abc.com'
INTO #emails
UNION ALL
SELECT 'a@abc.com'
UNION ALL
SELECT 'a@aasdf.com'
UNION ALL
SELECT 'sfawsed@dfsdf.com'
UNION ALL
SELECT 'asdfasdfasdf@asfdsbc.com'
UNION ALL
SELECT 'dffa@abc.com';
SELECT REVERSE(SUBSTRING(REVERSE(Email),1,CHARINDEX('@',REVERSE(Email))-1))
FROM #emails;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 12, 2014 at 5:48 am
Viewing 15 posts - 1,396 through 1,410 (of 11,676 total)