Viewing 15 posts - 3,481 through 3,495 (of 59,067 total)
You were attacking a straw man. I never made anything close to the claim you said I did.
Actually, you did...
Actually, the development team should have nothing...
May 14, 2022 at 8:01 pm
You were attacking a straw man. I never made anything close to the claim you said I did./quote]
Actually, you did...
Actually, the development team should have nothing to do...
May 14, 2022 at 8:00 pm
Those would work although those particular dates are a wee bit into the future assuming those are the little-endian count of days since the first of January 1900. One of...
May 14, 2022 at 7:37 pm
an aside: Azure Synapse cannot do recursive CTEs (or heirarchyid...), if you happen to be working in that realm.
I settled for a few layers of nested CTEs down to...
May 14, 2022 at 3:55 am
The "base date" for SQL Server for temporal datatypes is 01 Jan 1900 and it has a "Date Serial#" of "0". All other dates are based on the number of...
May 12, 2022 at 11:28 pm
A calendar table is great for that. But if you want to derive it dynamically, and you're always executing on the day following the end of the date range:
May 12, 2022 at 10:39 pm
What would be interesting is to see if the stored procedure actually uses the end date correctly or if you going to miss all but the firs 3.3 milliseconds of...
May 12, 2022 at 10:31 pm
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had...
May 12, 2022 at 10:06 pm
I am trying to get the lowest cost for a part and the highest cost for a part. along with the dates that they occurred. I almost have what...
May 12, 2022 at 7:49 pm
..
Lordy... It would have been RIEALLY nice if you left the original question here so that others no what the final recommendation was about.
May 12, 2022 at 7:47 pm
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had...
May 12, 2022 at 7:45 pm
No. The CU will update all of the features you have installed. You can un-select features to update in the install of the CU, but you probably would not...
May 12, 2022 at 5:50 pm
I fully agree with the comments made by others, but if the OP would like to try anyway, this will work with the test data provided:
...
May 12, 2022 at 3:47 pm
Even if you have a prior agreement - and the provider is sending the data in YYYY-MM-DD format you could still have problems depending on the data type and...
May 12, 2022 at 3:39 pm
Actually, the development team should have nothing to do with how the data in the db is physically stored. That's the DBA's job. (Sorry, just had to say...
May 12, 2022 at 3:36 pm
Viewing 15 posts - 3,481 through 3,495 (of 59,067 total)