A quick search of the registry will tell you that class id is for the DTS server, so another quick look under the DCOM Config section of Component Services and...

Try this for 1st of Jan this year:

=DateSerial(Year(Today),1,1)

and for the end of the year, take the start of next year and subtract one second

=DateAdd(DateInterval.Second,-1, DateSerial(Year(Today)+1,1,1))

You haven't said what is happening when you try those things...???

Here is a freebie....

Try this version of the function to see if it helps / makes a difference

create function [dbo].[CheckDigit](@vol varchar(50))

returns table

with schemabinding

as

return

select

case isnumeric(base.vol)

when 1

then

case sum(c.digit)...

I agree with Kevin that really you could do with refactoring this function, however that does not deal with the problem of why there is such a difference in performance...

How are you outputting the result ?

The XML datatype in SQL Server does not include < ? xml ... descriptors because they are mainly useful for identifying that...

Lynn Pettis (11/11/2013)

---

If I read your code correctly, this may work:

INSERT INTO FarzinIntro

SELECT

r.Role_ID,

r.User_ID,

dt1.n,

GETDATE()

FROM

...

You don't need to trim spaces after a value for an equality condition, so I suspect you have a non-printable character in there.

Try something like this to check that:

select cast(...

You can use COALESCE or ISNULL for this.

COALESCE(Column1,'')+COALESCE(Column2,'')

OR

ISNULL(Column1,'') + ISNULL(Column2,'')

Both functions will replace a NULL value with an empty string and prevent your problem.

niclas-1082356 (11/8/2013)

---

Thank you!

Always nice to know that a problem actually has a name =)

Your example worked great.

What if I only would like to select those personIds which has the...

declare @Table1 table(Column1 xml);

insert @Table1(Column1)

values( '<instance><Title>New product</Title> <Date> 2013.10.24</Date><Author>TV</Author><Meter>LV</Meter><Result>90</Result ></instance>');

select

Column1.value('(instance/Title/text())[1]','varchar(255)') as title

, Column1.value('(instance/Result/text())[1]','varchar(255)') as result

from @Table1

What does the UDF in question do? It may be pertinent.

Any reason why you can't just JOIN the approved revisions table on partnum and revisionnum and then select WHERE approved=1?

Chrissy321 (11/8/2013)

---

I guess this is why you guys say show us what you have tried. This demonstrates the results I am looking for. I'd like to get this in one...

shahgols (11/8/2013)

---

This is a shot in the dark, but I am putting it out there just in case.

I compared the actual execution plans and the XML of the staging execution...