Viewing 15 posts - 886 through 900 (of 1,246 total)
Something along these lines should do the trick...
IF OBJECT_ID('tempdb..#TblClientPOCV2', 'U') IS NOT NULL
DROP TABLE #TblClientPOCV2;
CREATE TABLE #TblClientPOCV2 (
ID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY CLUSTERED,
ClientID NCHAR(10) NULL,
StartDate DATE NULL,
ApptTime...
January 6, 2016 at 7:37 pm
Sergiy (1/6/2016)
Jason A. Long (1/6/2016)
But you were 11 mins too slow... 😛
Sorry, was having lunch, and did not refresh the page before hitting "Add Reply".
Did not even bother checking email...
January 6, 2016 at 6:46 pm
Luis Cazares (1/6/2016)
I believe that over use of CTEs is as bad as the lack of CTEs. I'd rather...
January 6, 2016 at 6:17 pm
Thank you both. 🙂
January 6, 2016 at 12:15 pm
below86 (1/6/2016)
erics44 (1/6/2016)
everyone writes code that they go back to later and think, what was I thinking when I wrote that pile of poo
That is so true, I don't know...
January 6, 2016 at 12:11 pm
Kevin, sorry for the delay in getting back in touch with you. I did talk to the boss yesterday. He's definitely game for doing the webex but he's giving me...
January 5, 2016 at 12:38 pm
MadAdmin (1/5/2016)
Login trigger on live server A.No login trigger on liver server B
Do rollback if Login name = 'ThisHardenedDeveloper'
Thanks MadAdmin,
Correct me if wrong (a very real possibility), but that would...
January 5, 2016 at 10:41 am
It's just a matter of personal preference...
For simple queries, with a single, simple derived table, I tend not to care one way or another. They're both easy to read.
When...
January 4, 2016 at 5:07 pm
Siten0308 (1/4/2016)
except i think you have this part as well, IF the part such as an example: for the scooter, if you dont have enough scooters to meet...
January 4, 2016 at 4:52 pm
I get the impression that you're trying to build out an order processing system that may be a bit more complex than your test data is able to represent...
Tell us...
January 4, 2016 at 10:53 am
Jeff Moden (12/30/2015)
(there is a "halo" exception... if the column has been defined as NOT NULL, the ISNULL is ignored). The other two WHERE clauses are not.
Interesting... I didn't...
December 30, 2015 at 6:56 pm
Grant Fritchey (12/28/2015)
December 28, 2015 at 8:07 am
I'm sure it's on the radar of the SOC officers and security compliance personnel... I don't claim to be overly knowledgeable regarding the specific laws, rules & regs, so I...
December 26, 2015 at 12:55 pm
Jeff Moden (12/25/2015)
Jason A. Long (12/25/2015)
The one I came across a couple days ago...
WHERE LEN(t.SSN) = 9
as opposed to
WHERE t.SSN LIKE [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]
The LEN check doesn't do it alone. It...
December 25, 2015 at 7:17 pm
Viewing 15 posts - 886 through 900 (of 1,246 total)