Viewing 15 posts - 1,981 through 1,995 (of 7,429 total)
Either way to add to the end you would have to close the file then reopen, might as well just keep open and do as you are doing to avoid...
April 24, 2004 at 6:01 am
DO a case in you count and sum like so
(CASE WHEN column = 0 THEN null ELSE value END)
By changing to a null the agregate will eliminate the nulls.
April 23, 2004 at 7:20 pm
What version is the SQL Server and what db type and version is the remote source?
April 23, 2004 at 7:16 pm
Was doing that today myself for a project.
We pass in with a varchar or multiple varchars if it is going to be longer than one can handle.
My example only allows...
April 23, 2004 at 7:14 pm
Take a look here also http://www.dbazine.com/tropashko4.shtml
April 23, 2004 at 7:00 pm
First off I question the need. The reading application will have to open the file and move thru the records to get the count. In that case it could have...
April 23, 2004 at 6:57 pm
It depends on how the softwar itself defines it's user structure. SOme folks use tables, some try SQL logins, some use tables to define SQL logins. You need to discuss...
April 23, 2004 at 6:54 pm
This might also have merrit for you but INSERTS and UPDATES can be a nightmare especially if you have to widen a nest. Many folks including Joe Celko prefer this...
April 23, 2004 at 6:51 pm
Just a bit more detail
From BOL
ANSI_PADDING
When set to ON, trailing blanks in character values inserted into varchar columns and trailing zeros in binary values inserted into varbinary columns are not...
April 23, 2004 at 6:45 pm
Answer should also include the fact you need to stop/restart sql.
April 22, 2004 at 8:13 am
Sorry about that I thought I had included the authors name. I feel weired with Book Reviews and don't feel I cover enough when I do them and apparently in...
April 19, 2004 at 2:45 pm
That is because the system account nor any installed account can see those mapped drives in any situation I could come up with when it comes to Novell. I finally...
April 9, 2004 at 5:00 am
Yes, unfortunately you can say 24/7 all you like but ultimately you have to fix the problem somehow so I suggest you bark for a maintainence window. If they still...
April 5, 2004 at 10:49 am
Well there are a few ways. Maybe you neede to move you delete process to an off time or day using a job to handle the delete. But you can...
April 4, 2004 at 8:51 am
Viewing 15 posts - 1,981 through 1,995 (of 7,429 total)