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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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>- BenClark
- Post #2
- Forum: Microsoft SQL Server: Programming
-
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...- BenClark
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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 "partial%"<br> OR<br> WHERE drugname LIKE "%partial%"<br> OR<br> WHERE drugname LIKE "%partial"<br> <br>- BenClark
- Post #3
- Forum: Sybase: PowerBuilder
-
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>- BenClark
- Post #3
- Forum: Sybase: PowerBuilder
-
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.- BenClark
- Post #2
- Forum: Microsoft SQL Server: Programming
