Viewing 15 posts - 121 through 135 (of 747 total)
Or, if you work out the allocation in the SQL (e.g. one with odd IDs & the other w/ even), you could create two side-by-side tablixes (tablices?) tied to the...
July 28, 2023 at 1:23 pm
July 20, 2023 at 1:37 pm
I had to create separate extension definitions in rsreportserver.config to get those to work -- e.g.,
<!-- <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/> -->
<Extension Name="PDF Landscape" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputFormat>
<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="PDF...
July 18, 2023 at 6:50 pm
That's not true. They are used somewhat commonly together for large data warehouses.
https://www.nikoport.com/2017/12/28/columnstore-indexes-part-116-partitioning-specifics/
July 17, 2023 at 6:20 pm
If 1-to-1, I can't think of any reason not to use the identity key of the original/primary table as the primary key and foreign key reference in the secondary table.
July 17, 2023 at 5:29 pm
July 14, 2023 at 2:58 pm
Don't know if this will help: https://www.sqlshack.com/sql-server-transactional-replication-how-to-reinitialize-a-subscription-using-a-sql-server-database-backup/
July 13, 2023 at 1:15 pm
ODBC driver versions up to 18.2 are listed as compatible w/ SQL Server 2016. Can you move to a newer ODBC driver?
I assume you were referring to using ODBC...
July 11, 2023 at 1:52 pm
Did you mean to use OPTION (MAXRECURSION)?
i.e., something like
WITH factorial(F,n) AS (
SELECT 1 F, 3 n
UNION ALL
SELECT F*n F, n-1 n from factorial where n>1
)
SELECT F from...
July 7, 2023 at 7:20 pm
Why do you have both @TVP GetTrackingNO parameter and @trackingTVP AS GetTrackingtNO variable?
It looks like the extra "t" in GetTrackingtNO is a typo, & you are actually using GetTrackingNO, correct?...
July 5, 2023 at 10:51 pm
Can you be more specific about what specifically is not working, and what you mean by "not working"?
Does it return an error? If so, at what point and what error?
You...
June 15, 2023 at 5:07 pm
Viewing 15 posts - 121 through 135 (of 747 total)