Viewing 15 posts - 1,156 through 1,170 (of 11,676 total)
Brandie Tarvin (1/15/2015)
Koen Verbeeck (1/14/2015)
And you know, for some reason MS still likes to ask...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 5:09 am
ChrisM@Work (1/15/2015)
+ '
FROM employee m
LEFT JOIN shiftdetails b ON m.empno = b.empno
where b.shifttype = ''' + @shifttype +
''' GROUP...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 4:56 am
Raymond van Laake (1/15/2015)
Since SQL2012 MS changed something with the identity column; after a restart the value jumps with 1000 (for INT identity column). This is an undesired "feature" for...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 4:54 am
Since you are using dynamic SQL in your sp, you cannot simply use the parameter @shifttype, because it is not known in the execution context of the EXEC command. In...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 4:52 am
Right-click database, go to "tasks" and then "generate scripts".
There you can script everything out.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 3:46 am
jacksonandrew321 (1/15/2015)
thanks I just followed ur direction, googled for the process to kill, executed on the query window and successfully altered the database mode.🙂
OK, glad you got it solved.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 2:15 am
It goes through C.
It loads data from A through the network into the memory of C, and then sends it through the network to B.
If you use a data flow...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 1:36 am
anthony.rooney (1/14/2015)
HiI had a similar query and was dismayed that you got no assistance!
Try filtering in the data set itself. What is your source?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 1:34 am
Make sure all users are disconnected from that database.
Even yourself 🙂
Close all open query windows, and then use sp_who2 to check if there are still connections to that database.
If there...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 1:34 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
January 15, 2015 at 1:31 am
Grant Fritchey (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Maybe I'm in a weird head-space at the moment, but it seems like the questions have...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 15, 2015 at 1:23 am
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 1:47 pm
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Sean Lange (1/14/2015)
Charles Kincaid (1/14/2015)
Seems that COUNT() does some fun things....
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 1:45 pm
Make sure you have a good grip on the new window functions introduced in SQL 2012.
And you know, for some reason MS still likes to ask XML related questions...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 1:37 pm
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't bad at all. A...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 14, 2015 at 1:35 pm
Viewing 15 posts - 1,156 through 1,170 (of 11,676 total)