Viewing 15 posts - 781 through 795 (of 1,251 total)
Ed Wagner (12/30/2014)
TomThomson (12/29/2014)
Ed Wagner (12/29/2014)
eccentricDBA (12/29/2014)
SQLRNNR (12/29/2014)
MandibleIronjaw
Game
Set (and Match)
Tennis
Elbow
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 30, 2014 at 6:11 am
Ed Wagner (12/29/2014)
TomThomson (12/28/2014)
djj (12/26/2014)
SQLRNNR (12/26/2014)
DiveFood
Grub
Worm
Wood
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 29, 2014 at 5:32 am
David Burrows (12/18/2014)
GilaMonster (12/18/2014)
Entertainment for next week = 1600 line long module (front end, not SQL) with no comments, erratic indentation and no naming standard.
Oh! Joy 🙂
Sounds like one of...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 18, 2014 at 6:13 am
Stupid f"£$ing RDP connection has shut itself down and I've lost everything I did previously!!!!!! I'll now have to pretty much start again but that may not be a...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 17, 2014 at 9:41 am
Of course I can :doze:
It makes repeated reference to creating an index on the TimeViolation table but that's read-only. The rest of it is so much hieroglyphics to me...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 17, 2014 at 7:47 am
I've put a clustered index on the Violations table that uses the StartDate and one on the Sanctions table using the dateidentified. I'll be honest though and say what...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 17, 2014 at 7:10 am
Thanks Grant, I've tried the TOP 1 approach and replaced the CTE's I was using with indexed temp tables but it's still not returned anything after half an hour. ...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 17, 2014 at 5:15 am
Eirikur Eiriksson (12/15/2014)
Doesn't this look like one of out favourite "Kitchen" people (look at the query, db name is OrbeData_KithKitchens):-D😎
I thought that as soon as I saw it 😀 Although...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 16, 2014 at 1:15 am
Letter
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 15, 2014 at 2:38 am
djackson 22568 (12/12/2014)
BWFC (12/12/2014)
John Mitchell-245523 (12/12/2014)
BWFC (12/12/2014)
that could be we TUPE straight out through the door.
I'm no lawyer, but as I understand it, TUPE protects you from any changes that...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 10:10 am
You're welcome.
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/ has a lot of useful date things if you need more.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 9:10 am
Try using this
declare @ThisDate datetime;
set @ThisDate = getdate();
select dateadd(wk, datediff(wk, 0, @ThisDate), 0)
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 9:07 am
What's the actual error message?
We had problems importing files using ~ as a separator because one of the records had a ~ in the text itself. This knocked everything...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 8:16 am
I think we're in scope automatically, from what we've gathered it doesn't matter whether there's a job a the other end, the incoming company has to take you on. ...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 7:55 am
John Mitchell-245523 (12/12/2014)
BWFC (12/12/2014)
that could be we TUPE straight out through the door.
I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made as...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
December 12, 2014 at 7:37 am
Viewing 15 posts - 781 through 795 (of 1,251 total)