Viewing 15 posts - 61 through 75 (of 112 total)
So in my DTS task I would select the records that are => 'current max(entrydate)'? I don't want to bring over duplicates. So perhaps it needs to be...
September 5, 2003 at 12:34 pm
Yes, but it will not return 1 row. Here's what I'm trying to do: Write a DTS package that will append only Inserts into a SQL table from an...
September 5, 2003 at 12:02 pm
Okay another caveat, I need the record back with not only the max(id) but also the max(entrydate). How can I get SQL to return just one row, fast?
Aurora
September 5, 2003 at 11:27 am
Thanks guys, that worked like a charm! Oddly enough, I made the mistake no DBA should ever make and that is assume. Naturally I thought the index was already...
September 5, 2003 at 9:27 am
Thanks Phill, you have been a big help pointing me in the right direction. I truly appreciate it.
August 28, 2003 at 7:54 am
The binary file I speak of is simply the Oracle log. Is there anyway to read this so I can determine which records need to be loaded. Does...
August 28, 2003 at 6:50 am
What about when locks are configured with the default values such as this result from sp_configure 'locks':
name ...
August 28, 2003 at 6:46 am
Not sure if this is what your are looking for:
But the ODBC drivers ship with SQL Server.
If you are in SQL Server and wanting to set up the correct connection...
August 27, 2003 at 10:06 am
Hi everyone,
Me too, I would like to view the scripts. I too have a similiar situation where I am connecting to a secure FTP and pulling down a CSV...
August 22, 2003 at 1:36 pm
I could certainly use either of those options, but still unsure how to tackle reading the binary file.
Ideas?
August 22, 2003 at 1:21 pm
Great, but although I have written a few ActiveX task before, its never been to read a Binary file. Any advice or resources I can turn to for assistance?
Thanks...
August 22, 2003 at 9:02 am
Are you appending the data to the existing table? Or are you truncating the table, recreating it and loading it?
August 20, 2003 at 1:42 pm
I agree VSS is now more intergrated with SQL server making it easier than ever to keep version control. There is another product that I believe ships with Rational...
August 20, 2003 at 9:57 am
Also, what version of SQL Server are you running? If you are running SQL 7.0, there is a known issue regarding shrinking the transaction logs in this version. ...
August 7, 2003 at 7:32 am
Viewing 15 posts - 61 through 75 (of 112 total)