Viewing 15 posts - 38,776 through 38,790 (of 39,803 total)
This:
WHERE disc_cnum, disc_num IN
IS not valid. You have to do
where disc_cnum in ( select...)
OR disc_num in (select ...)
The OR could be AND depending on your logic.
Steve Jones
January 7, 2002 at 10:00 am
Is this on all clients? Are they sure nothing was changed on the client or server? My guess is something changed, but they do not remember or do not think...
January 7, 2002 at 9:58 am
1. I'd use CHAR for < 20 characters. I think I saw something about > 20 characers not really providing any benefits.
2. Use integers. They join quicker. I'd use...
January 7, 2002 at 9:57 am
from BOL:
data_type
Is the parameter data type. All data types, including text, ntext and image, can be used as a parameter for a stored procedure. However, the cursor data type can...
January 7, 2002 at 9:50 am
I'd agree with Brian. The firewall is the best place. If this is not possible, I am not sure what you can do. Profiler does not get this (the client...
January 7, 2002 at 9:48 am
Have you checked all the data for anomolies? Can you return the individual rows directly with a select?
Steve Jones
January 7, 2002 at 9:45 am
It is resource intensive (relatively), but it works if you are not under a heavy load. It's also simple.
Steve Jones
January 4, 2002 at 5:12 pm
January 4, 2002 at 5:11 pm
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_9yat.asp
Steve Jones
January 4, 2002 at 5:10 pm
If you are querying through ADO, you can use sp_help 'procedurename' and see the 2nd recordset for the parameters.
Steve Jones
January 4, 2002 at 5:02 pm
It be complex, but you can do it.
Here's a start:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_2e5f.asp
This gets you setup in VB. From there, you could have to create each part of the package, connections, tasks,...
January 4, 2002 at 4:12 pm
Those are so crappy error descriptions. Not much better on technet, but you could try there.
Steve Jones
January 4, 2002 at 4:07 pm
January 4, 2002 at 10:57 am
There are some differences in the way the languages compile (they generate different ILS). However, you don't need to learn them. If a C# app runs faster than a VB/NET...
January 4, 2002 at 10:56 am
AFAIK, the only DTS competitors are expensive tools from 3rd party vendors. That was one of the big hits with DTS.
Steve Jones
January 4, 2002 at 10:49 am
Viewing 15 posts - 38,776 through 38,790 (of 39,803 total)