Viewing 15 posts - 286 through 300 (of 984 total)
A thought about the 'LIKE' clause you have...
If you know that your data is going to be hhmm, then you shouldn't be looking for items
[code...
May 12, 2017 at 2:35 am
May 12, 2017 at 2:26 am
What's the actual data type of the EndTime field?
I've done some testing (on SQL2012 & 2014), and have noticed that if it's a VARCHAR(x) then you're fine, but...
May 12, 2017 at 2:11 am
And I can...
May 11, 2017 at 7:21 am
If the "Name" field always contains a 7 digit number with a trailing bracket right before the end of the string, then you could just use a bit of basic...
May 10, 2017 at 5:54 am
I'm still a bit miffed that they haven't got round to allowing us to include scheduled tasks inside contained databases...
May 8, 2017 at 6:29 am
You could even try our hosts (Hi Redgate!) own product SQL Data Compare free for 14 days...
Yes, I'm a Friend of Redgate. No, they don't give...
May 5, 2017 at 2:46 am
May 4, 2017 at 7:23 am
gana20m - Thursday, May 4, 2017 12:49 AMIs this issue resolved?
After 6 years, you would hope so...
...either that, or the OP is...
May 4, 2017 at 7:10 am
barsuk - Friday, April 28, 2017 5:06 AMThe more licenses you are going to purchase, the better deal you can strike.
You'll almost...
April 28, 2017 at 7:35 am
I would have thought that most of those questions would be not really suitable for a short interview, but would keep it to more general questions such as your first...
April 28, 2017 at 7:32 am
Quick pointer... looks like you want something like a cross tab. See Jeff Moden's article "Cross Tabs and Pivots".
Edit.
Code would probably end up looking...
April 27, 2017 at 4:08 am
April 27, 2017 at 4:06 am
April 27, 2017 at 4:02 am
Viewing 15 posts - 286 through 300 (of 984 total)