Great suggestion

This is very possible now that I think of it. I'm converting a database that gets its feeds from another database. In the course of the conversion,...

Both are varchar(15)

William

Hi All:

I seemed to start an interesting thread with all kinds of great information. The problem was solved with the use of several inputs. This is what seemed...

Thanks Sreejith,

I'll give this a try and let you all know how it works

William

Hi Nole

My error, I copied the wrong SQL. The SQL is:

select * into daily_transactions_hist

from from daily_transactions

where transactiondate < dateadd(d, -360, getdate())

-- and daily_transactions.transactionid daily_transactions_hist.transactionid

Thanks

William

Fred, Mike, and Ram

Using "[dbo].[Daily_transactions.hist]" work just fine. Thanks Ram

Mike, I'll take your advise in the future and not use "."'s in table naming.

Thanks soo much, it was driving...

Hi John

Nope, the database name is "Immedia_Billing" and I've made sure that I'm in that database while attempting to drop the "Daily_Transactions.hist" table.

Thanks

William

it is the same server and same database. Maybe your point is well taken and I really don't need to use the Identity on the history table, as the...

Hi All:

Thanks for your help. This is what I came up with that sems to work well

William

drop table #temp

CREATE TABLE #temp (rowid int,textcol ntext)

INSERT INTO #temp values...

Seems that should work, however returning this error when running this:

UPDATE bignotes

SET bignote = REPLACE(REPLACE(bignote, CHAR(10), '|'), CHAR(13), '')

Msg 8116, Level 16, State 1, Line 4

Argument data type text is...

Thank you all for your help and assistance. It worked out GREAT ;-))

Bill

Thank you all. This list is great!

Bill

Thank you all. This list is GREAT!!!

Bill

I forgot to supply the ERROR message

Column 'C.Task_Id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Thanks

Bill

Within the program I'm doing the following when the error happens:

msgbox "Problem reading tablename" & err.number & err.description

full output reads as follows:

"Problem reading Subscritions table" -2147467259[DBNETLIB]

...