Viewing 14 posts - 16 through 29 (of 29 total)
Have you considered using SELECT INTO?
This would work with any result set, but would create a new table every time. You could either put some logic to create a table...
June 10, 2013 at 9:44 am
immaduddinahmed (6/10/2013)
select
CalDate,
Timein,
Timeout ,
CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108) AS SpendTime_runtime,
CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) / 60 as varchar ) + ':' +-- Hours ( + ':'...
June 10, 2013 at 5:31 am
Minimum doesn't mean it will start off at the min.
All it means is once it reaches the minimum threshold, it will never release it back to the OS when it...
June 10, 2013 at 3:45 am
Thanks guys.
I created a test service broker and 2 stored procedures. The 1st sp was linked to the response queue and basically read the message and then ended the conversation....
June 7, 2013 at 9:58 am
Thanks. Out of interest, do the sp's exec when a message is received into the queue, or when it's read from the queue? My testing seems to indicate it's when...
June 7, 2013 at 9:18 am
jnuqui (6/7/2013)but answer A is a little confusing because of this keyword in the question "without requiring backup data center in a different location."
You're right it's a bit confusing, but...
June 7, 2013 at 7:16 am
jnuqui (6/7/2013)
which three tasks should you include?(each...
June 7, 2013 at 5:22 am
Deleting the Full-Text Index and then defining it again using the wizard seemed to fix it.
January 30, 2013 at 9:29 am
That's the one. I thought it was a good book. It has about 200 questions in the training kit exam software too. Not saying it covers everything 100%, as you...
August 19, 2012 at 10:49 am
I thought it was ok. As long as you have fully read and revised the official 433 microsoft book. I also had to personally do extra revision on XML, CLR,...
August 19, 2012 at 10:00 am
Viewing 14 posts - 16 through 29 (of 29 total)