Viewing 15 posts - 856 through 870 (of 4,820 total)
July 20, 2018 at 7:43 am
Why do you need two separate temp tables? With just one table, the process is easier... The question is whether or not all the spans are contiguous to each other...
July 19, 2018 at 3:04 pm
Wondering whether the following solves anything:ALTER TABLE [dbo].[PetDetails]
DROP CONSTRAINT [PK_Petdetails]
WITH (MOVE TO [ps_PetTypes2]([PetType]));
GO
July 19, 2018 at 2:46 pm
SGT_squeequal - Wednesday, July 18, 2018 7:33 AMselect upper (substring(col,0,patindex('%[0-9]%',col))+' '+substring(col,patindex('%[0-9]%',@col,99))
from your table
Almost, but not quite. OP is looking for separate columns,...
July 19, 2018 at 2:15 pm
Sridhar-137443 - Thursday, July 19, 2018 1:06 PMIt seems to be interesting but expensive. Are there any other solutions?
Make the DEV environment...
July 19, 2018 at 1:28 pm
And please understand that you could seriously negatively affect the behavior of other triggers in your database if you do that, because that setting is in effect for the ENTIRE...
July 19, 2018 at 1:17 pm
Thank you for replying. I have actually researched some of your excellent work, but...
July 19, 2018 at 1:13 pm
Did you consider executing the code to be executed as a called stored procedure ? and returning enough properties of that session to be able to identify it later ?
July 19, 2018 at 1:05 pm
July 19, 2018 at 1:01 pm
July 19, 2018 at 12:28 pm
This post duplicates the question asked here: https://www.sqlservercentral.com/Forums/1977309/Need-help-with-the-getting-a-top-1-record-with-in-a-table-with-same-ids
July 19, 2018 at 11:52 am
Viewing 15 posts - 856 through 870 (of 4,820 total)