Does this help ?

--===== This shreds the XML by extracting each "DueDate" node (SomeXml.nodes)

--===== Then pullng the data from the Payee Node which is found by navigating

--===== to the...

Extract the data, send it to a web developer, get them to change it, import it back in ?

Your parameter is called @TVP but you are using the local variable instead in the code....

@TVP testType READONLY

AS

DECLARE @ParametersTVP AS testType

...

SET @Parameter = (SELECT Parameter FROM @ParametersTVP WHERE ParameterType =...

Your literals are causing it, cast them to varchar(MAX)

It's not entirely clear what you want, but I think you are after selecting the "best" version of each delivery address, where "best" means it has a postcode.

So, use a...

And more questions....

Have you checked the port the instance is listening on ?

- even though it is the default instance, it could be on a port other than 1433.

Have you...

is your client machine a member the same domain as the server?

can you connect using the name if you specifiy tcp/ip in the advanced connection settings?

are you logged in to...

Sorry: didn't spot how old this was....

;with data as

(

select 'klsjadlkj ads891 3y1kjnd al k 22/31/2012 lk;adk asl;k das#' as things

union all

select 'k 11/1/2012 dk asl;k das#' as things

union all

select...

L' Eomot Inversé (10/15/2012)

---

mister.magoo (10/15/2012)

---

The trouble with the additional BETWEEN is that it changes the semantics: ' 1' is no longer accepted, and neither is '01'. Of course the...

Yes it does...

Type conversion in expression (TRY_CAST([test].[field1] AS smallint)) may affect "SeekPlan"...

Here is my sample data creation: 10,000,000 + rows in tempdb - you may want to put it somewhere else...it's about 1GB of data.

Oh, and it relies on a TALLY...

Hi, I am going to post a test script so we can be sure we are comparing apples with apples...

haiao2000 (10/11/2012)

---

Maybe this will give another angle to look at. There are 2 ways I can benefit from this query if I can get it runs fast enough.

1) get all...

Put this expression in the "Hidden" attribute of the table you do not want to export:

=iif(TRIM(Globals!RenderFormat.Name)="EXCEL",True,False)