Viewing 15 posts - 1 through 15 (of 259 total)
Based on ratbak's second query, I think you can simplify it a little more by using a combination of AVG and NULLIF:
WITH subquery AS
(
SELECT
...
March 7, 2024 at 7:53 pm
I'm not really familiar with Oracle, but this seems like something universal, so I will give it a try.
SELECT Id,
SUM(CASE...
February 19, 2024 at 6:12 pm
Just remove the GO - there's no need for it.
SET @view_code = N'CREATE VIEW [' + 'PGCPS_CUSTOM' + '].[' + @table_name + '_VW] ' + @line_break +
'AS ' + @line_break...
February 14, 2024 at 6:59 pm
Long shot: Have you changed the batch separator to something different than the default? That would produce the error you describe.
In SSMS check
Tools-> Options -> Query Execution -> General
and
Query... ->...
February 13, 2024 at 7:11 pm
No, only VB.NET and C#.NET is supported.
Options
ScriptLanguage
Select the scripting language for the task, either Microsoft Visual Basic or Microsoft Visual C#.
February 13, 2024 at 6:34 pm
I don't think there is a pre-baked recipe for you, but FWIW, Brent Ozar has a few recommandations, which you can read about in this blog post:
https://blog.quest.com/demystifying-cxpacket-and-cxconsumer-wait-types-in-sql-server/
September 25, 2023 at 3:05 pm
Sorry, but you've been extremely sloppy with your example code/data.
September 14, 2023 at 6:43 pm
... but if you can't change the date format in the file name...
This would also be a possible solution:
DECLARE @x VARCHAR(100) = '09142023';
SELECT @x as [@x]
...
September 14, 2023 at 4:42 pm
Make the filename use the international ISO format YYYYMMDD instead of that quaint american date format and you'll have no trouble at all. 🙂
September 14, 2023 at 4:07 pm
Grmbl, the /quiet installationswitch workaround for installing Access Ace drivers 32 and 64-bit side-by-side seems to have stopped working.
That's not the intent of the "quiet" switch. The intent...
September 5, 2023 at 4:33 pm
One comment: I hope the example table isn't an exact replica of your production table, because to use that many columns defined as nvarchar(max) just to be on the safe...
July 3, 2023 at 5:45 pm
... and here's my attempt at fulfilling your requirements:
/* Load the test data */
DROP TABLE IF EXISTS #SecurityUsers;
CREATE TABLE #SecurityUsers (
SecCode NVARCHAR(70) NOT...
May 20, 2023 at 8:01 pm
Have you changed the target server of the SSIS package to SQL Server 2019, done a Rebuild and deployment? If the target server of the package is still set for...
May 17, 2023 at 6:59 pm
This is not an aswer to your question, but...
Your criteria AND (ITPRDC != 'AX' OR ITPRDC != ' ') looks wrong to me. And it's not your use of the...
May 17, 2023 at 6:02 pm
i type wrong id
Yes, 'BL.2112.00627' isn't the same as 'BL.2111.00627', so not surprising that you may get different results from the two queries. 🙂
April 19, 2023 at 7:16 pm
Viewing 15 posts - 1 through 15 (of 259 total)