Viewing 15 posts - 76 through 90 (of 127 total)
I have read about that in the past, but didn't think about it. Another good point. I'm just going to split up the SPs based on function. Thanks guys.
August 27, 2018 at 7:27 am
Sergiy - Monday, August 27, 2018 7:07 AMIt's easy to find out:
lol. Yes, that was a lazy question. Thanks.
August 27, 2018 at 7:12 am
I think i understand. The SP is for Inventory lot allocation. So, I should just create separate procedures. i.e. IM_Lot_Select, IM_Lot_Update, IM_Lot_Delete?
August 27, 2018 at 7:07 am
Can you provide a rough example or a link? Also, why is it not good practice?
August 27, 2018 at 7:01 am
I made the change to db compat level and created the XML computed column. Now the query takes 12 sec. to return 119 rows for a single CDA. I'm at...
July 10, 2018 at 6:28 am
I changed the db compat level on our test server db to SQL 2012. The try_convert function works on it now. What things should i be concerned with when changing...
July 9, 2018 at 9:36 am
I get this error:
Msg 195, Level 15, State 10, Line 1
'try_convert' is not a recognized built-in function name.
July 9, 2018 at 9:26 am
You can use features...
July 9, 2018 at 5:04 am
July 8, 2018 at 4:23 pm
July 7, 2018 at 12:09 pm
July 7, 2018 at 8:57 am
July 6, 2018 at 1:40 pm
Sorry for the late response on this. Project got put on the backburner for a couple weeks. So, to catch up, Erikur Erikssons solution in previous post gives me a...
July 6, 2018 at 7:42 am
Here is my final full code and exec plan if you have a bit of time to look for any further issues. Thanks again for the help.
[code...
July 5, 2018 at 4:24 pm
Viewing 15 posts - 76 through 90 (of 127 total)