Viewing 15 posts - 976 through 990 (of 5,111 total)
Gee, who figured out DBCC TimeWarp? Posts here are posting four hours in the future. My last post above was at 11:33 AM EST, but it's showing 3:33pm
That's...
May 17, 2019 at 3:44 pm
Thom, Thanks for response, Can u have look output once, it is contains both 2018 and 2019 years data- derived based on current month. Thanks!
In the sample data there...
May 17, 2019 at 3:22 pm
This is a just an unpivot. Personally, I prefer using a VALUES clause to unpivot the data, rather than the UNPIVOT operator. This ends up giving you the below:
May 17, 2019 at 2:45 pm
Nope all worked, meant exactly what I wrote. There have been problems with other QoDs with broken links, incorrect explanations and just poor questions. In comparison to some of...
May 17, 2019 at 2:16 pm
I think the thorough explanation, links (that worked) are great!
Did one links not work for you Sue? I tried them and they all seemed to work, but if...
May 17, 2019 at 8:05 am
Hi, how "offline" process?
As in, when the system isn't being used by users. Another phrase would be "out of hours". So, you might do the process between 01:00 and...
May 15, 2019 at 1:30 pm
You'll find it unlikely that many of us are going to download that zip file, but for those that aren't, I did download it to a Pi to extract instead....
May 15, 2019 at 1:13 pm
So, the question is - why didn't the SSIS packages fail long before?
This might seem like a silly thing to say, but they didn't fail before because...
May 14, 2019 at 7:05 pm
The PDF problem isn't something I've experienced yet at the office, but if this is actually true this will have huge ramifications for us at the office; we produce all...
May 14, 2019 at 6:55 pm
What your your reasons for choosing to use a WHILE loop here, and a multi-line scalar function? Inline Table-value functions are extremely powerful, and quick (as in inline scalar functions...
May 14, 2019 at 10:03 am
Those expected results don't appear to be representative of the example data. Where is sales persons 2 - 9? Sales Person 1 has 5 days off in April in your...
May 14, 2019 at 9:54 am
I can't find any documentation on it because the official 2019 deprecated features hasn't been made public yet but does anyone know if sys.sysindexes is still available in 2019?
it's...
May 14, 2019 at 9:09 am
There are number of selections (Duration) available while entering time off territory. PM Off, AM Off, All Day, 2 Days, 3 Days, 4 Days, 5 Days, Long Absence.
Are those...
May 14, 2019 at 8:14 am
Hmm, "30 days" for a month is a bad assumption in my view, Scott. Considering that 7 months have 31 days, and 1 has 28(/29), assuming 1 month is 30...
May 13, 2019 at 9:50 pm
I have to ask, why is Duration a varchar(50), and why is the value '5 days'? Does that mean you might have values like "2 weeks" or even 1 month"?...
May 13, 2019 at 8:11 pm
Viewing 15 posts - 976 through 990 (of 5,111 total)