Yes, we had just moved our environment to SQL2K8 (4 weeks ago), the source operational database is not within our area to control so CDC would have to be agreed...

...and it looks as though the situation doesn't get any better no matter how many columns you add you still get 256 distinct values - ah well, leave the OR's...

Yes, once I'd forced the left hand side to a float...

(col103 * POWER(2e1,102))

... this worked.

I guess at this point I'd be happy enough with the binary_checksum method - I'd accept...

OK, for what its worth I've coded it like this...

-- updates

select

a.pk_id

from

mytarget a

join

mysource b

on a.pk_id = b.pk_id

where

(

-- 45 columns with non-significant data in

a.[col1]<>b.[col1]

orcast(b.[col2] as varchar(MAX))<> a.[col2]

...

or binary_checksum(a.[col56],a.[col57]...)

<>

binary_checksum(b.[col56],b.[col57]...)

)

It works and...

Yes, nice try however in this particular case its the except I'm trying to avoid. In addition to the 100+ bit type columns it also has 100+ 'text' datatype columns...

Yes, thats exactly what I do 🙂

I just used the example given, I have yet to use a like clause in any of my code, the focus of the comment is on the performance issues around...

I ran into performance issues caused by parameter sniffing so many times using this type of construct

at work that I had to stop using it.

Now I use this:

declare @local_firstname nvarchar(50)

declare...

I have seen similar examples of ROW_NUMBER() usage and the following has always puzzled me:

Why do we include columns in the ORDER BY when they are already in the PARTITION...

Thanks for that, good reference, much appreciated, learned some new useful stuff...

Hi, off the top of my head there are a couple of ways you can do this if you are using a table component:

1) add another column to the table,...

Just got back to looking into this issue.

More detail:

The report in question is accessed via Site Actions|Site Settings|

under Site Collection Administration|Audit log reports|Security And Site Settings Reports|Security settings with a...

I use a function like this:

Public Shared Function RemoveSharePointListTags(ByVal ListItem As String) As String

Dim result As String = ListItem

Dim itemtagindex As Integer

itemtagindex = result.indexof(";#")

If itemtagindex>0 then

result = result.substring(itemtagindex+2,result.length-itemtagindex-2)

end if

result =...

Are you calling the report via a URL ? If so, perhaps ClearSession=true will have the desired effect.

"what i can't do is to link the reports datasource (defined in the .rdl) to the defined datasource (rs.createdatasource)"

I know that this is a silly question but I'm going to...