Dynamic query...problem
anonymous_at_discussions.microsoft.com
Date: 04/07/04
- Next message: Rhonda Fischer: "=> Trigger to copy duplicate rows into a new table where val >26"
- Previous message: Dylan: "Re: Number to Date."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 7 Apr 2004 05:12:18 -0700
"SELECT FirstName, EmployeeID, LastName, BirthDate FROM
Employee " + iff(@p1 = 0," "," WHERE (DepartmentID = " +
@p1 + ")")
this query is not working in sql reporting server2000
and the error reported is "syntax error"
the similar example is mentioned in SQL reporting Services
Books Online under "walkThrough:Using a dynamic query in a
report"
How do we use this query correctly? does the IIF condition
work here? How do we use similar query if I need to
connect to Oracle 8i database with Microsoft OLEDB
provider for Oracle (MSDAORA 1)
- Next message: Rhonda Fischer: "=> Trigger to copy duplicate rows into a new table where val >26"
- Previous message: Dylan: "Re: Number to Date."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
- Re: Views - performance
... when u use stored object views oracle has to read the data dictionary ... this
includes lots of steps for execution ... semantics of the query and fires it ...
you'll possibly have any idea is to use explain plan to provide a base ... (comp.databases.oracle.server) - RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
... can pass strings as varchar's and have them inserted ... In theory I could write
something to query the ... CLOB w/in Oracle is probably what is killing me... ...
(perl.dbi.users) - Re: Equilevant of Oracle for optional records
... and a normalized t2 could be more useful, to build the query, and once this ...
the Iqaluit Trauma: ... Oracle handles this data structure perfectly but
I suspect it might be ... (microsoft.public.access.queries) - Re: Equilevant of Oracle for optional records
... this query is done, then flatten the result? ... example, the Iqaluit Trauma:
... Oracle handles this data structure perfectly but I suspect it might be ...
(microsoft.public.access.queries) - DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
... can pass strings as varchar's and have them inserted ... In theory I could write
something to query the ... CLOB w/in Oracle is probably what is killing me... ...
(perl.dbi.users)
