paul.knibbs (6/26/2013)

---

I would tend to...

I'm not sure is an aversion from Jeff towards the TempSPs, but more of a "let's learn together". I've heard of the TSPs before but had never found any real...

r.mitchell (6/26/2013)

---

I use a recursive CTE for this usually. In this example it will give you all the days in June. Had to use this when I created...

It might not be the best option but it should give you the correct result according to your test data.

WITH cte AS(

SELECT *,

ROW_NUMBER() OVER( PARTITION BY CustID ORDER BY TxnTime)...

Sean Lange (6/26/2013)

---

What would really help is:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results based on the...

Without sample data and expected results, I'm only taking a shot in the dark.

You should really read and understand the articles mentioned by Sean as there's some sample code in...

There's not enough information to answer this. Please give more details, DDL, sample data and expected results based on it. For more information, read the article linked in my signature.

Lowell posted a complete solution before...

Without a master table of regions, the query can perform poorly with large data.

CREATE TABLE #MyTable(

REGION char(1), date_apprvd date, sal int)

INSERT #MyTable VALUES

('a', '20130101', 1000),

('a', '20130201', 2000),

('a', '20130301', 3000),

('b', '20140101',...

All of those asking for cases on when Temp Stored Procedures would be useful ever read the entire article? At the end, it mentions some acceptable scenarios.

Sean Pearce (6/25/2013)

---

michal.lisinski (6/25/2013)

---

Hi Gila

You have the right to disagree with my opinion, but there is no "right" answer here. For data that is not meant to persist beyond the...

Not difficult but we need something more to work with. Please post DDL and sample data to get the help needed. For more information on how to do it, read...

This seems to be part of the problem posted in here

http://www.sqlservercentral.com/Forums/Topic1466855-1291-1.aspx

Welcome to SQLServerCentral.

You posted a lot of code and it will be hard to get help with your post as it is.

I recommend you to read the article How to...

Hi,

What you're asking is not difficult but it sounds a lot like homework. Could you show us what have you tried?