Are you able to write a select statement...

dob111283 (6/17/2013)

---

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...

SQLTestUser (6/17/2013)

---

Yes but what for existing users, they are already in different locations and i think this is the best way to do it.

any ideas??

i need an if else in...

dob111283 (6/17/2013)

---

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...

SQLTestUser (6/17/2013)

---

the logic is to trace where the user is in the application at a certain period, and display the information on the application accordingly. So i added a column...

dob111283 (6/17/2013)

---

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...

sqlsdev (6/17/2013)

---

I have 2 lookup tables. I need to get and replace the values from the lookup tables for the below data.

Lookup Table 1

LT_ID Desc

Cat_Code Category

Prod_Code...

SQLTestUser (6/17/2013)

---

I have a column that has to be set with a certain value as A,B,C or D when a certain column has a value i.e. is not null. The...

dob111283 (6/17/2013)

---

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...

dob111283 (6/17/2013)

---

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...

Also there appears some differences in the ddl. At the very least some of the indexes are different between the two plans.

dob111283 (6/17/2013)

---

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...

dob111283 (6/17/2013)

---

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...

Based on your posted requirements:

Here is what I am supposed to do:

See if you can create a stored procedure based on requirements below:

Title: PEX_MetricsTopFiveStrongest

Summary: This stored procedure will take the...

realvilla (6/17/2013)

---

Sorry, I totally missed the best practices the first time around. I will work on that this afternoon. It's exciting to think of accomplishing my goal without...