It helps if you tell people the error you get...

Which bit is not working - the select or the insert (try it without the insert)

Maybe if you show us the function, it will be possible to replace it with something that will work in 2000?

Jack Corbett (11/23/2010)

---

mister.magoo (11/23/2010)

---

It's really not that difficult..here is an example of getting a maximum ArticleNumber for each groupName in my articles entity...

var groups = from a in Articles

...

And here is how to just get the max from an entity

var mm = Articles.Max(w => w.ArticleNumber );

It's really not that difficult..here is an example of getting a maximum ArticleNumber for each groupName in my articles entity...

var groups = from a in Articles

...

This sounds like it could be solved by the "Quirky Update" method to me - as you need to compare each row to the previous row.

See Jeff's article about it...

Bearing in mind the requirement for the Interval to vary I would avoid a table of time periods unless you have one for each valid time period.

Assuming time periods start...

I just cricked my neck watching that one fly overhead 😀

Simply this...?

SELECT SUBSTRING(REPLACE(st.imagem,'\','/'),

PATINDEX('%\IMAGES\%',st.imagem),

...

shairalt (11/19/2010)

---

Absolutely sweeeet!! 🙂 Thank you!!

I needed to make just a couple changes –

1. I had to convert my Effective Date to a datetime as I was...

shump66 (11/19/2010)

---

petervdkerk (11/19/2010)

---

Ah, I didnt see all the code, my bad.

Anyway, your code seems to do [almost] what I need.

Currently your code shows: #duplicate records - 1, meaning that if...

No, the whole thing, to find duplicates in the prospects table (I used a table variable for this table as a test) and show whether the duplicates are also in...

Try something like this - without data to try it with there may be errors

;with cte as (

SELECT

Part,

Price/UnitofMeasure IndvPric,

...

This is a sample of how to do this

--= first set up some test data

DECLARE @prospects TABLE (

id int identity

,companyname nvarchar(50)

)

insert @prospects( companyname)

select 'test1' union all

select 'test1' union all

select...

Can you elaborate on the acceptable formats of the string?

N'ABD',N'DYX',N'ALL' is OK

Is that the only format i.e hard coded letter N followed immediately by a quote, three letters, another quote...