Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BenClark

    Global Function in MS SQL 7.0

    You can still use a stored procedure.<br> Just compile it in the Master database.<br> This will give you access from any database on the <br> server.<br>
  2. BenClark

    Why does this sp work on one server but not another?

    All the message is telling you is that the temp<br> table #searchtemp has not been created on the second<br> server.<br> You need to find the DDL for it on the first sever<br> and run it on the second server.<br> Your procedure should compile fine after that.<br> Also you might want to change...
  3. BenClark

    Search using LIKE doesn't work

    Just place the % sign in from of the partial drug name and use LIKE in the where clause.<br> <br> WHERE drugname LIKE &quot;partial%&quot;<br> OR<br> WHERE drugname LIKE &quot;%partial%&quot;<br> OR<br> WHERE drugname LIKE &quot;%partial&quot;<br> <br>
  4. BenClark

    project build complaint.....

    If you want to email me a copy of your pbr file I think I can help.<br> <A HREF="mailto:ebcl@pdq.net">ebcl@pdq.net</A>
  5. BenClark

    Installation

    I ran into this one myself.<br> My problem was that the drive I was installing to was NOT an<br> NTFS file system. <br> As soon as I converted to NTFS, everything worked fine.<br> Search NT help for CONVERT.

Part and Inventory Search

Back
Top