Viewing 15 posts - 6,346 through 6,360 (of 7,429 total)
Without seeing the DDL of the tables and a sample of data to know for sure. Something like this would do the job. If you want to get into more...
April 19, 2002 at 8:38 am
You need to do a reinstall to get that properly done.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 19, 2002 at 6:04 am
Ok I am confused here. Are you saying you want to get 70% of the records and total them or you want what 70% of the totals are? Or is...
April 19, 2002 at 5:54 am
Both the DDL of the tables and the Execution are dead on and the trace numbers look fine except duration. This now has to be either a server settings issue...
April 19, 2002 at 5:50 am
I am not aware a process that can tell you if the isolation was change. You can look at sp_lock at the type of lock. Or if this is being...
April 19, 2002 at 5:42 am
Hey epol29 I wasn't referring to not use it but he had a specific need to be met that defaulting to NULL would prevent
April 19, 2002 at 5:15 am
You will end up going thru the package to make the changes as I don't know of a search and replace app available. You may want to save the package...
April 19, 2002 at 5:06 am
quote:
Sadly, I didn’t find out the backup had been stopped until we were having a (rather, heated) discussion about getting access to...
April 19, 2002 at 4:58 am
SQL allocates memory as often as it needs it, then normally unless the OS triggers a release it will keep hold as it anticipates for it to be needed again....
April 19, 2002 at 4:47 am
About the easiest but most painfully poor way to do this is Access using linked tables.Other than that, I know of nothing right off.
"Don't roll your eyes at me. I...
April 18, 2002 at 3:49 pm
If you know how to write a SELECT query to get what you want then you just do an
INSERT INTO tblNameHere (columnlist) YOURSELECTSTATEMENT
Just make sure you account for previous...
April 18, 2002 at 3:46 pm
Well there are a lot of factors to your questions, and then how many questions do you need answered is another. I suggest grab a good book on SQL (or...
April 18, 2002 at 3:41 pm
Look in Client Network Utility and see if the SQL7 instance is defined there. If so make sure the SQL2000 instance is as well. I am still looking for anything...
April 18, 2002 at 3:33 pm
The only problem with epol29 exaplme is the fact you stated that NULL may be what is being submitted. Here is the change that you need to make
CREATE PROCEDURE UpdateAddress...
April 18, 2002 at 3:20 pm
First what is the exact error and are you using " identifiers in the SP? (Or better can you post the SP itself)
"Don't roll your eyes at me. I will...
April 18, 2002 at 10:04 am
Viewing 15 posts - 6,346 through 6,360 (of 7,429 total)