Viewing 15 posts - 1 through 15 (of 52 total)
Good to know! Thanks Paul
February 15, 2021 at 1:08 pm
You can write a single query by doing LEFT JOIN of jobs table with status, and drops table.
February 15, 2021 at 11:45 am
Below query needs change as per my interpretation:
SET @sqlquery =
N'SELECT [PROJECTID],[MODELID],[PROJECTLINEPROPERTYID],' + @PivotColumns + '
INTO TBL_TEMP
FROM [dbo].[ProjForecastSalesStaging]
PIVOT ( SUM(AMOUNT)
FOR PROJECTFORECASTINVOICEDATE IN (' + @PivotColumns + ') )...
February 15, 2021 at 11:01 am
Hi,
From Integration Service Catalog, you can see the execution report of all SSIS packages. You might get error details from there if any.
October 29, 2020 at 7:38 am
So you can follow the below steps to tune the query if you have access to the database to run the same sp by passing the parameters coming through application...
August 20, 2020 at 4:19 pm
August 20, 2020 at 4:10 pm
<Order_Notification Level="x">
<Order_Company Level="y2">
<Order Level="z3" />
...
February 11, 2019 at 4:54 am
February 2, 2018 at 2:06 am
February 1, 2018 at 5:45 am
January 25, 2018 at 6:49 pm
January 25, 2018 at 6:45 pm
And In SQL Developers I am considering guys who also work in SSRS on daily basis. But still should have had done some R&D to know what R can give...
January 25, 2018 at 11:04 am
January 20, 2018 at 1:15 am
You can try below lines of code. I hope that it will work.;WITH CTE_Main AS (
SELECT
Customer,
TranID,
TranDate,
Reason,
TranStatus,
LEAD(Reason) OVER (partition...
January 19, 2018 at 6:28 am
Viewing 15 posts - 1 through 15 (of 52 total)