Viewing 15 posts - 466 through 480 (of 1,246 total)
This looks a lot like the thread you started here... https://www.sqlservercentral.com/Forums/1911062/Help-to-reduce-stored-procedure-execution
I'm not sure why anyone would want to continue answering questions for you when you bail out on the...
December 21, 2017 at 3:25 pm
Do you have any advice on how to identify...
December 20, 2017 at 10:06 am
Itzik Ben-Gan has a function...
http://www.itprotoday.com/microsoft-sql-server/how-compute-date-and-time-difference-parts
December 19, 2017 at 11:10 pm
Whoever wrote this needs to give back whatever money they were paid... This contains some truly unforgivable sins.
Looking at the top 1/2 of the code, my first thought was...
December 17, 2017 at 11:13 pm
Here's another options that differs from Jeff's good suggestion...
It's a bit more convoluted than Jeff's suggestion but I offer it up because, in a situation like this, you...
December 16, 2017 at 10:31 pm
This version should be better for @cnt values over 44 (I also missed the space between the replication values the 1st time).
SET NOCOUNT ON;
DECLARE...
December 14, 2017 at 11:43 am
December 14, 2017 at 7:43 am
Try this...SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO
CREATE PROCEDURE dbo.usp_Align
/* =================================================================================================================================
12/13/2017 JL, Created for forum post: https://www.sqlservercentral.com/Forums/1912528/ALIGNMENT
================================================================================================================================= */
/*
dbo.usp_Align
December 13, 2017 at 1:57 pm
December 7, 2017 at 11:23 am
December 4, 2017 at 2:51 pm
December 1, 2017 at 2:46 pm
December 1, 2017 at 2:27 pm
December 1, 2017 at 1:14 pm
Viewing 15 posts - 466 through 480 (of 1,246 total)