Just be careful now, there is a mistake in that code that means you get every...

I agree with Erland, just change the test to equality with zero, unless you actually want to extract the non-matching nodes from the xml?

I would add that this may be...

use temporary tables with good indexes

Step 1 : Don't use table variables.

You simply need a function in your report code.

Something like this should do it:

Function getImage(path as string) as string

If System.IO.File.Exists(path) Then

...

What can't you figure out? You have the insert there, commented out...is it erroring?

Sorry, just spotted the insert is wrong...

insert into UsersLoggedIn(<column name for count>, <column name for time stamp)

you...

Something like this should give you the most recent LastModifiedDate for each Table1Key.

select Table1Key, MAX(LastModifiedDate)

from Table1

outer apply (

select Table1.LastModifiedDate

union all

select LastModifiedDate

from RTable01

...

you said you tried using the ".nodes" method - did you do that to get down to the ns:formdata/ns:legacydata level, then just take values from e.g. ns:firstname/@value ? and it...

Do you really need nvarchar(MAX)?

Does it save any time to reduce those to nvarchar(4000)?

Does it speed things up if you comment out all but one of the ".value" columns?

It's not sort of zipped internally. It is a zip. Change the extension to zip and open it to see. But this is kind of off topic:-D

Could be an xlsx. They are zips also.

Do you have any mapped drives on the sql server under that domain account?

If so, can you copy the file to one of those and see if you can read...

Or you could just set the step to go to next step on failure....

Thanks for taking the time to explain.

I did 😀

mister.magoo (7/9/2013)

---

You just need to make it into a singleton query by plopping some brackets round the selector...

select a.b.value('[highlight="#ffff11"]([/highlight]PID[sql:variable("@LoopCount")]/PID.3[highlight="#ffff11"])[/highlight][1]', 'varchar(200)')...