thanks Grant

Johann

ok solved it

someone suggested this on another forum:-

AND @ulang <> 'al' AND lang.langCode = @ulang

and ((@uid=0 AND lc.string LIKE '%' + @STR + '%') or (@uid=1 AND lc.string...

Thanks Grant

I tried this

WHERE (p.fk_projectId = @pid)

AND lang.langcode =

CASE

WHEN @ulang <> 'al' THEN @ulang

END

AND lc.locstring =

CASE

WHEN @uid = 0 THEN LIKE...

Hi

Basically I already thougth of that solution, ie 2 inserts, however I thought there was something more elegant, since I am quite new to SQL

However thanks for the help

Johann

Hi Matt,

I tried your code, however the resourceID is NULL

Also, if I am inserting for example 1200 rows, the @resourceId will always be the same number no? Ie MAX(resourceID)...

this is my attempt at this problem

DECLARE @resourceId int

SET @resourceId = (SELECT MAX(resourceId) AS resourceID from Resources)

INSERT INTO #tempResources (resourceId, FileName, projectid)

@resourceId+1, SELECT FileName, projectid from #tempOld

WHERE projectid =...

Hi Gail

Sorry for not getting back to you. I was assigned on another urgent task, and today I am supposed to be back on these script, and will try...

Hi matt

sample:-

ID string ...

Gail

on the same bases, how do I do an insert if a filename changes.

For example I have a list of records, lets say 100000, and every 1000 rows, the filename...

thanks a lot

much appreciated;)

Hi Lynn

your code is cool too but is taking 20 seconds, while gail's is taking just 12 seconds 🙂

Hi Gail

Yeah the order is starting from 1, its something in my ordering that is not working

Thanks

Regards

Johann

Hi gail

Sorry was in a meeting

Let me check ok, will let you know soon

Gail

Another quick question, how do I reset TheOrder to 1 again. Because when I run the script more than once, its starting from for exampl 953

Thanks

Johann

Hi gail

Thanks a lot for the explanation, and Sandy for trying 🙂

I will read more on this ROW_NUMBER function, since it seems pretty cool!

Thanks all for helping!

Johann