SELECT newColumn

FROM...

like this one:

But as Pedro intimated....it depends...look at the plan...

That's nice,...

And do you actually have a component on the page called GridView1?

You are welcome. Thanks for the feedback 😀

I think it quite likely that it doesn't like you using BEGIN without an END...:-P

I haven't tried this, but I would look at using an expression that did the following:

Check if the value is inscope of your grouping

if it is use whatever expression you...

1. You have BEGIN without an END - drop the BEGIN or add an END

2. Use the INSERTED virtual table to limit your updates on TableB to only those...

Is this what you mean?

WITH pass1

AS (

-- First number the ActionTypes giving priority to HELLO lines

SELECT *

, ROW_NUMBER() OVER (PARTITION BY AccountNum,...

piortasd (1/14/2013)

---

Its working with this way, takes 42 seconds to import 27.000 entities

DECLARE @X XML

SELECT @X = CAST(x AS XML)

FROM OPENROWSET(

BULK 'C:\temp\teste.xml',

...

Just a couple of questions/suggestions

1. How long does this take ?

SELECT CAST(x AS XML)

FROM OPENROWSET(

BULK 'C:\temp\teste.xml',

SINGLE_BLOB) AS T(x)

2. Have you considered changing all the .value('.','varchar(whatever)') to .value('(./text())[1]','varchar(whatever)') ?

...

And another Tally type version, but seems faster to me...

CREATE FUNCTION dbo.fn_extract_chars_in_range(

@input varchar(8000) -- the string to be cleansed

,@start char(1) -- the first valid character

,@end char(1) -- the...

WolfgangE (1/13/2013)

---

You should do it another way. When normalizing the database there should be a table containg all available statusids. Your data table should then have a foreignn key to...

Another way...

ORDER BY CHARINDEX(statusId,'32451')

😀 Like your motivation 😀