Viewing 15 posts - 196 through 210 (of 430 total)
I think both methods below get the right result. I think the second one is better, but it relies on SET DATEFIRST 1 to make the weeks end on Sunday,...
August 25, 2022 at 5:05 pm
What if the first of the month is a Sunday? Is the first week just one day and the second week the 2nd to 8th? like May 2022.
Is this right?
May...
August 25, 2022 at 3:24 pm
The only way I have managed it is to start with an excel file that already contains a row of dummy data with columns longer than 255. This is far...
August 22, 2022 at 6:09 pm
Do you know if you have permission to access all databases on that server?
What is the last process date of the cube? is it recent? Has it changed since you...
August 19, 2022 at 11:15 pm
This appears to work, but there may be a more efficient method. Is 60 minutes and 1 second considered > 60 minutes? I assumed so, so I used datediff 3600...
August 18, 2022 at 8:30 pm
I need single row per invoicenumber and line
August 18, 2022 at 5:46 pm
I don't know about setting them directly in the catalog, but you can set the project or package parameters in a sql agent job step. Once a parameter has been...
August 16, 2022 at 6:21 pm
To summarize, do you believe that column store would be worthwhile not only for compression but for lookup performance?
If your tables are there for occasional "what happened?" queries, I...
August 16, 2022 at 2:32 pm
Do you query the history tables directly? or does the application do that exclusively? Depending on the way the tables are used, the history tables may be candidates for a...
August 15, 2022 at 8:07 pm
It initial glance it appears you assume all users have different names. Does @UserOperator need to be unique? If so I would check whether it already exists before starting the...
August 15, 2022 at 3:07 pm
"find out how the table is populated, fn_GetSummaryReport only reads from the table. If you can't find the proc that populates it then you'll have to compare it to...
August 10, 2022 at 7:42 pm
I think you are on the right track here.
Instead of an average for each day , he wants just 1 average per date range (weekdays) for 6 cases, 7...
August 9, 2022 at 6:13 pm
If you really only need the Patient ID and Procedure Code ID then you can just use the claims view and group by patient id. or you can use the...
August 9, 2022 at 2:27 pm
@Ed B - in order to truncate a partitioned table , the table and indexes must be aligned (partitioned on the same partition function).- see https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15
I tested it before...
August 9, 2022 at 1:28 am
Edit. Someone already did the inserts and my code didn't work.
I can't see how average number of days means anything.
Your sample data has two days in it. On 6/1 there...
August 8, 2022 at 8:51 pm
Viewing 15 posts - 196 through 210 (of 430 total)