Viewing 15 posts - 766 through 780 (of 1,464 total)
This will work for the data that you supplied.
However, it makes the assumption that there will only ever be 1 match.UPDATE t2
SET Mfg = t1.CompanyName
August 17, 2018 at 11:59 pm
August 17, 2018 at 11:56 pm
August 17, 2018 at 11:17 pm
I seek a way to show daily data with a 30 days average before...
August 16, 2018 at 11:56 am
August 15, 2018 at 2:40 pm
August 12, 2018 at 1:18 pm
Ed Wagner - Friday, August 10, 2018 9:30 AMPort
Starboard
August 10, 2018 at 10:15 am
August 10, 2018 at 12:15 am
You could always extend tSQLt by writing your own case-sensitive assertion. It's just a stored proc.
Then you could callEXEC tSQLt.AssertEqualsStringCS @expected, @actual;
August 9, 2018 at 1:26 am
Just for fun, lets add some calculations to the groupsDECLARE @TableDate TABLE (TrxDate date PRIMARY KEY CLUSTERED, Value int NOT NULL);
INSERT INTO @TableDate ( TrxDate, Value...
August 2, 2018 at 12:09 pm
August 2, 2018 at 12:01 pm
first few...
July 30, 2018 at 10:33 pm
Viewing 15 posts - 766 through 780 (of 1,464 total)