Viewing 15 posts - 706 through 720 (of 4,820 total)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 15, 2018 at 7:52 am
But I don't think he wants a...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 15, 2018 at 7:04 am
The fields I need to omit from the group by clause are the...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 15, 2018 at 6:25 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 14, 2018 at 3:10 pm
Progress OpenEdge documentation link for 11.3.3:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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,
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 14, 2018 at 1:12 pm
You are very welcome!
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 14, 2018 at 12:14 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/
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 14, 2018 at 11:53 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 14, 2018 at 11:45 am
Viewing 15 posts - 706 through 720 (of 4,820 total)