I have found no entry level jobs in south florida, nor on the job training or internships. I've been studying meanwhile, doing all the chapters like 4-5 times. I should...

Whoops

CREATE PROC dbo.PEXDEV_MetricsTopFiveWeakest

@LPPProgramID UNIQUEIDENTIFIER,

@DateFrom DATETIME,

@DateTo DATETIME

AS

SELECT BoughtLoyaltyProgramId, SoldLoyaltyProgramId, DateTransactionCleared, ExchangeRate

FROM dbo.PEX_ClearedTransactions

WHERE DateTransactionCleared>=@DateFrom AND DateTransactionCleared<@DateTo

AND (BoughtLoyaltyProgramId=@LPPProgramID

OR SoldLoyaltyProgramId=@LPPProgramID)

ORDER BY ExchangeRate

OFFSET 0 ROWS FETCH FIRST 5 ROWS ONLY;

It just said "Error near Offset" and "error near fetch", when I completed the aforementioned query. Only top worked.

Sean, maybe because I'm having trouble understanding between TOP and OFFSET-FETCH. I know OFFSET FETCH was added to sql 2012 and I forget what the benefits are, I just remember...

Me being unable to fully explain what I'm doing with a foreign programming language somehow indicates that English isn't my native language? Where did you get your powers of logical...

Hey Sean, I went back and redid the whole thing. I changed the ExchangeRate function and and added an "exchangerate" column in the clearedtransacions table to calculate the exchange rate,...

Ok Sean thanks. I'll post back as soon as I do that. You've been a big help. I really enjoy doing this SQL stuff. It's almost like a chess match.

It does make some sense, it's just a lot of information for a newcomer to absorb. Do you have some time later tonight to maybe help me with this realtime?...

I'm sorry Sean, all this time I kept saying ClearedTransactions, I meant the ExchangeRate stored procedure I posted the code in my very first thread. THAT is what I would...

Ok Sean, I will do the TVF. But it leads me back to square one sort of, because I can't query the ClearedTransaction stored procedure, the one you gave an...

Crap, seriously? So everytime I wanted to get realtime results from the transactions, I'd have to manually query the ClearedTransactions table, insert results into a temp table, and then do...

Ok Sean I appreciate the help but bear with me as I take this one step at a time. So per your instructions, would the first Stored Procedure be the...

I'm sorry Shawn, as a relative newbie to SQL, I'm not properly clarifying things. When you wrote sometable, I realize that's whatever table I'm trying to pry the information from...

Wow Sean thank you so much for that quick response. I understand what you wrote except, "return Sometable". Since I'm querying a stored procedure dbo.PEX_ClearedTransactions, how would I call that?...

Thank you. Next time I'll try and search the topics before creating one that's already been done.