Viewing 15 posts - 196 through 210 (of 5,590 total)
For the given data in MockTable, what are the expected results?
October 1, 2015 at 4:08 pm
The quickest, most sure-fire way to reduce the code would be to use CTRL+A followed by CTRL+X. :w00t::w00t:
How about this for the first query?
DECLARE @NewCreditScores TABLE (insuredID INTEGER, creditScore INTEGER);
INSERT...
October 1, 2015 at 3:41 pm
The STATS_DATE() function may be able to help you narrow it down... unless you rebuilt all your indexes since you added the index, or if stats have been automatically updated.
October 1, 2015 at 3:23 pm
Grant Fritchey (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use it...
October 1, 2015 at 8:25 am
Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
September 30, 2015 at 12:02 pm
Kristen,
Yes, an inline table-valued function would be your desired usage for code reuse. However, as you pointed out, not having the function at all is even better - but that...
September 26, 2015 at 7:42 am
Kristen-173977 (9/25/2015)
WayneS (9/24/2015)
this won't work... you need the "." between the different parts of the fully qualified name.
O/P has
Set @Dbo= '.dbo.'
but I agree it would be better to have the...
September 25, 2015 at 9:28 pm
SQL_Kills (9/25/2015)
So with my current script that I have found what actually needs to be changed for it to work as not sure now?Thanks
Did you see the part of my...
September 25, 2015 at 9:27 pm
Sean Lange (9/25/2015)
Steve Jones - SSC Editor (9/25/2015)
jasona.work (9/25/2015)
Hmm. Maybe we need to Godwin that topic, and bring...
September 25, 2015 at 8:34 am
Eirikur Eiriksson (9/25/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
WayneS (9/23/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only...
September 25, 2015 at 8:31 am
SQL_Kills (9/24/2015)
Hi,Thanks for the reply, I'm not sure what to change now on my script?
Thanks
Edit... whoops, this is wrong.
New attempt:
SELECT @CntNow = COUNT(*) FROM Adventures.dbo.tblLibrary
If the table that you...
September 24, 2015 at 2:19 pm
ChrisM@Work (9/24/2015)
WayneS (9/24/2015)
FROM #Activities
CROSS APPLY (SELECT PATINDEX('[A-Z,a-z][0-9]%', activityName),
...
September 24, 2015 at 7:44 am
robinwilson (9/23/2015)
This option does look like a possible option and would seem better than the suggestion of using NO LOCK on everything. I have read up on this and can't...
September 24, 2015 at 7:35 am
SELECT activityName
FROM #Activities
CROSS APPLY (SELECT PATINDEX('[A-Z,a-z][0-9]%', activityName),
...
September 24, 2015 at 7:28 am
Viewing 15 posts - 196 through 210 (of 5,590 total)