Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Search functionality

Author  Topic 

PatDeV
Posting Yak Master

197 Posts

Posted - 2007-05-01 : 16:58:26
Hi I am trying to create report that can search in database for sertain informaion.

I have Database souce in Access which has linked table to Oracle dababase. that's only thing i can have access to so have no other choice to go direct Oracle database!

I have following similiar query to have report

select dt.test_Name, dt1.address,dt.zip, dt1.contactinfo
from deadtable dt
join deadtable1 dt1 on dt.test_nbr = dt1.test_nbr

where
dt.test_name like ? --> this is the parameter i am trying to use to pass information in.

is there a better way that i can use please advise.

Thanks

Thanks!!
   

- Advertisement -