skb 44459 (1/7/2014)

---

Do you have an example ? I don't necessarily want different Stored Procedures.

I need multiple SubRoutines within One Stored Procedure, so that they can share the Variables and...

Truncating the table before loading new data would be more efficient - is there some reason why you chose the CTE instead?

Which option?

Yes you can - stored procedures with input and output parameters can be nested within a calling stored procedure. Do you really need the code blocks configured as "subroutines"?

Something like this:

DECLARE @NextSeqId INT

SET @NextSeqId = dbo.FN_GetNextSeqId4CRM_MNP_ORIGINAL_NRN()

;WITH CTEseriesnacionales AS (

SELECT NextSeqId = @NextSeqId + (ROW_NUMBER() OVER(ORDER BY RangoIni)-1),

*

FROM dbo.seriesnacionales

)

MERGE dbo.CRM_MNP_ORIGINAL_NRN AS T

USING CTEseriesnacionales AS S

ON (T.RANGE1 = S.RANGOINI )

...

Working on a completely different principle, this will perform differently to Luiz' fine solution. Test them and assuming they return correct values, choose the fastest - on the assumption that...

A slightly different approach from the previous two, triggered by a gruelling telephone survey I was foolish enough to agree to participate in just a couple of weeks ago. There...

joey6401c (1/6/2014)

---

Thanks for the reply

I modified my query but it returns an error

Delcare @dt date

Set @dt = GETDATE()

select distinct v1.name 'Machine Name', v1. 'Username', t1.displayname 'Unlicensed Application', t1.installdate 'Install Date'...

That's the ticket!

Thanks for the feedback.

Sure.

Change this:

INNER JOIN ST_SUPPLIER su...

waheed71 (1/6/2014)

---

Dear ChrisM / Dear Lowell,

Thanks for the prompt reply. I am really sorry about not able to communicate properly. So far I am unable to get required result.

I just...

If you haven't got a timestamp date/time column in your table, how can you tell if something is more than 7 days old?

Does your table have an assocoation with any...

Slightly different to Lowell's code and I'm not sure which is correct:

SELECT

d.TR_STOCKNO,

d.CT_STOCKSUMMARY,

d.PH_SUPPLIERCODE,

su.SU_SUPPLIERNAME,

d.PH_RAISEDDATE,

d.TR_DATE,

d.LASTPO,

d.LASTVENDOR,

d.LASTGRN,

d.Age

FROM (

SELECT

tr.TR_STOCKNO,

ct.CT_STOCKSUMMARY,

ph.PH_SUPPLIERCODE,

--SU_SUPPLIERNAME,

ph.PH_RAISEDDATE,

tr.TR_DATE,

MAX(ph.PH_RAISEDDATE) OVER (PARTITION BY tr.TR_STOCKNO) AS LASTPO,

MAX(ph.PH_SUPPLIERCODE) OVER (PARTITION BY tr.TR_STOCKNO) AS LASTVENDOR,

MAX(TR_DATE) OVER (PARTITION...

ROW_NUMBER() on an outer SELECT will often return the results in the ROW_NUMBER() order, which could make your query equivalent to this:

SELECT rownumber, linknumber, savabegh

FROM (

SELECT

rownumber = ROW_NUMBER()...

The splitter discussed here [/url]is shown to be far superior in performance terms to either of the two already listed oon this thread. Here's how you would use it to...