I'm getting the same issue. I'm looping through a folder of files using #dirTree sql server 2012. Then for each file reading the data into a temp table that...

it can be inserted into by each node. There shouldnt be any modifications.

sorry, i misspoke. the sql server is still availible however it is the sql instance that is not. I'm able to resolve the issue by stopping the sql instance on...

it's using the linked server via openquery by the way

Actually, ur right. On the two servers i spot checked. One was doing a backup restore to our QA environment which explained the extra record. The other, which is the...

I'm not trying to be rude here however none of these work properly and are returning extraneous results. If u run it right after the full backup it returns the...

verified. no indexed view and it's in the right db

EXECUTE sp_MSforeachdb @command1 ='SELECT ''?'',o.name as view_name, i.name as index_name

FROM ?.dbo.sysobjects o

...

exactly. i noticed the same thing. the table has 4 indexes, one of which is unique. the clustered. it's on the below

[ClientID] ASC,

[DateOfdata] ASC,

[Dimension LINE_ITEM_ID] ASC,

[Dimension CREATIVE_ID] ASC,

[Ad_ID_Concatenated_ID] ASC

this is the index

CREATE NONCLUSTERED INDEX [ix_report_history_creative_id] ON [dbo].[DFP_Reports_History]

(

[Dimension CREATIVE_ID] ASC

)

INCLUDE ( [ClientID],

[DateOfdata],

[Dimension LINE_ITEM_ID],

[Impressions],

[Clicks]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF,...

disregard

GRANT VIEW CHANGE TRACKING ON OBJECT::dbo.table to user

But even then it would give an error

The one instance I was unable to truncate a table was when that table was referenced in an indexed view w schema binding. Are u guys using indexed views? U...

sorry i meant schema binding

i got u now.

select cast(cast('1.55E-05' as float)as decimal(25,20))

I'm sure i could multiply it by something to get it to work however that doesnt explain why it will convert 1.35e6, 1.35e5, 1.35e4, 1.35e3, 1.35e2, 1.35e1, 1.35e-1, 1.35e-2, 1.35e-3,...