Viewing 15 posts - 706 through 720 (of 4,820 total)
August 15, 2018 at 7:52 am
But I don't think he wants a...
August 15, 2018 at 7:04 am
The fields I need to omit from the group by clause are the...
August 15, 2018 at 6:57 am
Divide 40 GB by 722,000,000 and you'll find the result is roughly just shy of 60. So your table can't fit in RAM unless those 22 columns average less than...
August 15, 2018 at 6:47 am
My gut says it's something in the SQL syntax... I'd also check the values for the Options on the Linked Server, and be sure to set RPC and RPC Out to...
August 15, 2018 at 6:25 am
August 15, 2018 at 6:23 am
Okay, let's try another shot at the syntax on the OpenEdge side:SELECT CONVERT(int, scheduled_qty) AS scheduled_qty
FROM OPENQUERY(PROD_AXS, '
SELECT { fn CONVERT ( scheduled_qty, SQL_INT ) } AS...
August 15, 2018 at 6:14 am
Looks like there's a need for CAST instead of CONVERT:SELECT CONVERT(int, scheduled_qty) AS scheduled_qty
FROM OPENQUERY(PROD_AXS, '
SELECT CAST(scheduled_qty AS varchar(18)) AS scheduled_qty
FROM AXS.PUB.sols...
August 14, 2018 at 3:10 pm
Progress OpenEdge documentation link for 11.3.3:
August 14, 2018 at 3:05 pm
Then you need some syntax for converting data types in the native SQL language of the source database. See the attached,
August 14, 2018 at 1:12 pm
Take a look here: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/create-a-document-map-report-builder-and-ssrs?view=sql-server-2017
and here: https://www.mssqltips.com/sqlservertip/3504/sql-server-reporting-services-bookmarks-and-document-maps/
August 14, 2018 at 12:13 pm
Also, if your procedure was not actually receiving that NULL parameter value, it could ONLY be because you didn't set up the dataset to use the parameter, hidden or otherwise.
August 14, 2018 at 11:55 am
If your report were not running when you failed to supply a value for a given parameter, then you would need to be sure that the parameter properties ALLOW a...
August 14, 2018 at 11:53 am
August 14, 2018 at 11:45 am
Viewing 15 posts - 706 through 720 (of 4,820 total)