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 TouchToneTommy 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: *
- Users: DavidLemire
- Content: Threads
- Order by date
-
Linked Server Information
Hi Guys, I have 2 SQL servers linked by a VPN. On one server, I need to run a SP every one minute on the other server. To do that, we decided a linked server would be best. We want to know which one is most optimized between: 1. At run-time, create a linked server, open it, run query, close...- DavidLemire
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Division by zero!
Hi people, I need a little guidance here. To make a long story short, I have a string which would be "(123/0)+23". I need to put that string in a dynamic query. However, I want to avoid the division by zero error. if charindex('/0',@DynamicNumber) <> 0 that won't work here, because I can have...- DavidLemire
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
Auditing Stored Procedure Progress
Hi friends, This is my first post on this forum, as I've just registered for TekTips. I hope you are a great community, and if that is the case, I'll do my best to keep this community healthy! Ok, down to the point. I have an Excel report that calls a stored procedure. This SP then returns...- DavidLemire
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
