... the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range.
How?
My example is that I have ...
... == "" ? NULL(DT_DATE) : (DT_DATE)This_Date
-- if data source column is of datatype string and european date format: return SQL date
(TRIM(This_Date) == "") ? (DT_DATE)"1900-01-01" : (DT_DATE)(SUBSTRING(This_Date,1,2) ...
... equivalent functions have to be written up all in the name of "seamless integration"...
How?
Previously I had tried to write a smart function which could determine the datatype automatically but ...
... 30 - Wrong datatypes I was told but found this is just how I was calling the parameter. I declared these in the stored procedure but the fix in the end was referring to the Query Parameter Value properly. ...
... user parameters.
Syntax:
CREATE [OR REPLACE] FUNCTION function_name
[ (parameter [,parameter]) ]
RETURN return_datatype
IS | AS
[declaration_section]
BEGIN
executable_section
[EXCEPTION
...
... all work.
Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft ...
... in_array() [function.in-array]: Wrong datatype for second argument in /public_html/modules/mod_quicklistweblinks/helper.php on line 214 This is because you have not selected a thumbnail "service group" ...
... environment, have you?
Commented out lines that you suspect might be the problem?
Able to run the SQL queries directly against the database?
Matched the datatypes received/returned by functions, ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.