Who did tell you datetime is the same as varchar?

Why are you trying to use varchar functions for datetime values?

There is a UDF to solve the problem:

IF EXISTS (SELECT...

Try this:

SELECT TOP 255

Identity (int, 1,1) as i

INTO #Numbers

from syscolumns C1, syscolumns C2

declare @Chars table (ToRemove int)

INSERT INTO @Chars (ToRemove)

select i from #NUMBERS

where CHAR(i) not like...

It's not hard.

Just right-click on QA on table DR, select "Script Object into Clipboard as -> Insert" and paste it here.

Third time:

Can you provide complete INSERT statement?

INSERT

INTO DR ( <columns list> )

Once again:

INSERT INTO DR ( <columns list> )

Can you provide complete INSERT statement?

Everytime you run objRs.Open strSQL, objCn you open new connection.

#table exists only within connection scope. As soon as you close connection (objRs.Open strSQL, objCn finished) #Table is dropped...

What you suppose to put in WHERE clause if you don't know which table you are querying?

INSERT INTO DR

Can you continue with columns list for the table?

It must be table like this:

dbo.PriceList (

LimitId int,

CurrencyId int,

Price money)

And 2 tables for descriptions:

dbo.PriceLimit (

Id int

LowLimit int,

HighLimit)

dbo.Currency (

Id int,

CurrencyName nvarchar(50),

CurencyCode char(3),

... whatever you need to describe currencies, e.g. currency symbol

)

And...

It definitely must be not one table.

No doubt you will have repeating values for [Thread] , [Logger], [Principal] , [Application] , [SourceIP] , [DestinationIP] , [IntermediateIP] , [UserAgent] , [Event] , [MethodName], [UserName].

And it's times...

... + ISNULL(FieldName+ ','+FieldValue, '')

What do you mean "does not work"?

What's an error?

Do you have in this statement

SELECT col1, col2, col3,....... col100 ?

Do you have a SQL statement for this?

Can you add WHERE .. IS NOT NULL to this?

Do you insert that staging dataset into any actual database after all?