Viewing 15 posts - 1,216 through 1,230 (of 4,820 total)
Well, here's something that works, but I'm not sure it's performance is going to be good as row count scales upward:CREATE TABLE #RawData (
rowNo int IDENTITY(1,1) NOT NULL...
May 29, 2018 at 8:06 am
May 25, 2018 at 10:54 am
May 25, 2018 at 9:01 am
May 25, 2018 at 8:42 am
Try this on for size... although with temp tables it won't enforce the foreign keys, it at least deomstrates the concept, and I could actually run it... CREATE TABLE #contacts...
May 25, 2018 at 8:26 am
May 25, 2018 at 6:58 am
May 25, 2018 at 6:46 am
The files are re-added to an email and sent, so there must be a decrypt...
May 25, 2018 at 6:41 am
May 24, 2018 at 10:23 am
We are upgrading form 2008 to 2017 and I am running into an issue on...
May 24, 2018 at 10:11 am
From your picture, I can count 42 potential values as opposed to 250, so what might I be missing? Your post indicates you get a timestamp plus the values, with...
May 24, 2018 at 9:20 am
May 24, 2018 at 8:54 am
I'm most interested in WHY product1 has a count of 3. Is it simply the maximum number of consecutive days that said product appears in the data? If I merely...
May 23, 2018 at 1:14 pm
Viewing 15 posts - 1,216 through 1,230 (of 4,820 total)