I have a stored procedure that runs in less than a second in SQL Server Query Analyzer, but sometimes it takes up to 3-5 minutes to run that same stored procedure in a data window retrieve.
This doesn't constantly happen, it's been about a month since it last happened, and there were no changes...
Having no experience with scripting for procomm+ or File Link, how difficult is it to convert? Anyone attempt this or have any pointers?
(Is there a file link forum)? :)
Your help is appreciated.
I have a report that on occassion will have multiple pages and need to print it w/o Collate. Several copies of each report are printed and the paper is color coded for who it goes to so on the multi-page reports it needs to print all the copies of page 1, then all the copies of page 2 then all...
Is there a way to build an update statement piece by piece?
For example, depending on which variables have values I would like to add them to the WHERE clause and then execute the update statement.
so when variable var1 is greater than 100 it would add
AND var1 > 100
to the where...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.