is there any reason that you need to use the pearl script to scheule over a SQL job?

also look up output

http://msdn.microsoft.com/en-us/library/ms177564.aspx

Look up Ranking functions here is an example

create table #t1 (id int,col varchar(5))

insert into #t1 select 102,'#1' union all

select 102,'#2' union all

select 102,'#3' union all

select 105,'#4' union all

select 105,'#5' union...

Depending on what your doing what about using a CTE?

quite possible an error in the processing section causing the script to exit your cursor However the cursor is not closed and not deallocated within the session therefore the...

Tronometer

as today is the 13th its a good day my lucky day 🙂 other day was a dark day lol 😀

try the union that i added

im no XML expert but, i use this command to import xml files in to my database, I created a SP using the dynamic SQL so i can...

Granyola

syntax is correct but does it bring back correct records?

this may be better

select .........

FROM

Evy_RH_Objects.dbo.RETAIL_SALES I

INNER JOIN RH2007_EvyLive.dbo.ITEMMAST J on J.SKU=I.SKU

union

select .........

FROM

Evy_RH_Objects.dbo.RETAIL_SALES I

INNER JOIN RH2007_EvyLive.dbo.ITEMMAST J...

crapiola

:hehe:

Jeff Moden (7/12/2012)

---

SGT_squeequal (7/12/2012)

---

I dont really know how to take your remark, are you being a popmus git, just showing off or trying to help? mmm

will grant, that set...

I dont really know how to take your remark, are you being a popmus git, just showing off or trying to help? mmm

will grant, that set based, over loop...

i used the loop before any of the set based ooptions appeard plenty to ponder for the future :);-)

I used the while loop within while loop worked a treat for what i need :), thanks for all the SET based solutions but id used the loop to complete...