Viewing 15 posts - 1 through 15 (of 159 total)
This is just a feeling, but I have had the same problem a time or two. Turned out that different default settings of ARITHABORT between SSMS and the application resulted...
June 22, 2022 at 2:35 pm
Or maybe a combination of the proposed queries? Something like
WITH LowestHighest AS (
SELECT MAX (vacationhours) as 'Max_VacationHours', MIN (vacationhours) as 'Min_VacationHours'
From [HumanResources].[Employee]
)
SELECT 'Lowest' AS VacationHoursLeft, e.*, lh.Min_VacationHours AS VacationHours
FROM [HumanResources].[Employee]...
June 21, 2022 at 12:28 pm
Was the WHERE clause allowed when the COLUMNSTORE index was first introduced with SQL Server 2012? I think not, but I haven't been able to find the official MS documentation...
June 21, 2022 at 11:37 am
Alternatively you'll need to use a window function instead of a conventional group by.
June 20, 2022 at 11:00 pm
It would have been nice if you had provided test data in a format that is readily usable. That's generally a prerequisite for having any success in getting a response...
June 20, 2022 at 9:47 pm
I'd say you have far too many single-quotes. Each single-quote in your original query only needs to be converted into two, in order to be represented in a variable. You...
June 8, 2022 at 5:28 pm
A different approach that may be possible is to feed you table source into a Destination Script Component. In this you can define more than one downstream named output destinations....
May 25, 2022 at 3:20 pm
I also think you'll have to do the limiting of the output data size at the source, i.e. use a SELECT TOP(calculatedNumberOfRows) * FROM yourTable. The number of rows that...
May 25, 2022 at 3:07 pm
Looks like it's referencing SQL Agent tokens.
May 24, 2022 at 8:36 pm
Alternatively you can define five (or the number of packages you have) separate Data Flows, where your input will then be slightly modified queries:
"Select tablenumber from a table where tablenumber=1",...
May 24, 2022 at 8:23 pm
As an alternative this could possibly/probably be better handled by SSIS than what you describe as your current solution.
Instead of writing to a temp table, just pass the data to...
May 24, 2022 at 7:21 pm
What are the use cases for this product vs the regular SSRS reporting product?
It is the same as the Report Builder. SSRS is a Server Service. The Power...
May 18, 2022 at 3:52 pm
What are the use cases for this product vs the regular SSRS reporting product?
May 18, 2022 at 9:04 am
At a guess you have one too many single quotes (apostrophes) at the end of this line, i.e. four where it should have been only three:
SET @SQLZ =...
May 15, 2022 at 11:18 pm
This query will only work if there is exactly one part. I added one more record for a different part, and now I am getting no records at all.
May 12, 2022 at 5:54 pm
Viewing 15 posts - 1 through 15 (of 159 total)