Viewing 15 posts - 1,501 through 1,515 (of 26,488 total)
Just another version:
SET NOCOUNT ON;
DECLARE @SQLCmd NVARCHAR(MAX)
, @SQLCmdTemplate NVARCHAR(MAX)
, @DBName NVARCHAR(128);
IF OBJECT_ID('tempdb..#Info') IS NOT NULL
DROP TABLE #Info;
CREATE TABLE #Info (
May 24, 2018 at 10:36 am
May 24, 2018 at 9:49 am
Below86, thank you so much! I like how clean and brief your formulas are, and...
May 24, 2018 at 8:48 am
SPAM is out of control tonight. All looks oriental to my eyes.
May 23, 2018 at 10:12 pm
Why are you minus id from row number?
[p].[id] - ROW_NUMBER()...
May 23, 2018 at 9:53 pm
But then you have these type of issues: RESVITAL BEAUTY 3 90CNT, RESVITAL RESVERATROL 500MG 60CNT; when trying another way to isolate a numeric value causes another anomaly when trying...
May 23, 2018 at 5:36 pm
So, should this also not return a value: ,('TWI-51','5 - LOXIN (BOSWELLIA EXT)')?
May 23, 2018 at 5:19 pm
May 23, 2018 at 4:54 pm
Really weird part is that I run the code with no problems multiple times.
May 23, 2018 at 4:49 pm
SET NOCOUNT ON;
INSERT INTO dbo.audit_table ( TableName, NumberOfRecords, Date )
SELECT...
May 23, 2018 at 4:34 pm
Here is a rewrite of the code taking into account "CNT" may not be in the description. Give it a try.
--===== Create the test table with...
May 23, 2018 at 4:28 pm
May 23, 2018 at 3:42 pm
Mark_S_DLI - Wednesday, May 23, 2018 3:32 PMSQL 2012 R2It is an ERP product that has come up through the years.
Here is...
May 23, 2018 at 3:41 pm
Looking at the forum you posted in I have to ask, are you actually using SQL Server 2000 or older?
May 23, 2018 at 3:27 pm
May 23, 2018 at 3:24 pm
Viewing 15 posts - 1,501 through 1,515 (of 26,488 total)