Viewing 15 posts - 946 through 960 (of 11,676 total)
patricklambin (3/5/2015)
It seems for me that as soon as there is no more rows in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 4:19 am
Hany Helmy (3/5/2015)
Jostein Saethern (3/4/2015)
The "delete table BBB;" statement in d) will fail.Its just a typo.
That's not a typo, that is a mistake.
DELETE FRAM BBB, that is a typo.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 2:10 am
Nice question, unfortunately poorly implemented.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 2:09 am
P Jones (3/5/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 2:06 am
winston Smith (3/4/2015)
Martin Schoombee (3/4/2015)
winston Smith (3/4/2015)
A...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2015 at 8:17 am
Interesting question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2015 at 3:04 am
Maybe you should add a WHERE clause to your UPDATE statement?
Update TableB
Set Description = ?
WHERE TableB.Key = ?
In the second parameter you map the key that needs to be...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2015 at 2:58 am
Nice question, thanks Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2015 at 2:26 am
erics44 (3/3/2015)
Luis Cazares (3/3/2015)
Koen Verbeeck (3/3/2015)
Luis Cazares (3/3/2015)
The option is in Menu File -> Open -> Analysis Services Database...
Keep in mind that you are connected live to that SSAS database.
If...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 4, 2015 at 1:33 am
My first thought is that you need some sort of matrix, where the first three columns are fixed and everything after Owner Name (thus the Incentive columns) are just one...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2015 at 2:45 pm
Jeff Moden (3/1/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2015 at 2:43 pm
Luis Cazares (3/3/2015)
The option is in Menu File -> Open -> Analysis Services Database...
Keep in mind that you are connected live to that SSAS database.
If you make changes in BIDS,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2015 at 2:38 pm
If you want to develop reports for SQL Server 2012 it is adviced to use the Visual Studio 2010 shell.
You can find this on the SQL Server installation media under...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2015 at 2:37 pm
What kind of jobstep is this?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2015 at 3:34 am
Steve Jones - SSC Editor (3/2/2015)
I'm off to SQL Bits, Red Gate, and Dublin for 10 days. I'll be in and out, so everyone be good.
Mwoehahahahaha, home alone!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 2, 2015 at 1:14 pm
Viewing 15 posts - 946 through 960 (of 11,676 total)