Ok, I haven't written stored procs in a while. Bear with me please.

I'm running this, and it's telling me I need to declare @cnt1 and @cnt2.

Is there some scope...

Thanks. However, Table is created with the upload. Not populating existing tables. In this case, I did not know the previous table was there, likely because of...

for my purposes, it's part of the imported table name.

It is only in one year blocks. Jan-Dec. Whatever year that particular report is for.

thank you.

I'll try to remember to include the scripts. Sorry, didn't think of it.

Grant Fritchey (12/10/2014)

---

DSNOSPAM (12/9/2014)

---

I guess it also goes against all my reflexes for other programming languages, which is to break a problem down into logical components.

SS seems to throw other...

thanks, everyone, for your continued responses, and broadening input.

aaron.reese (12/10/2014)

---

If you are just coming back to SQL from a long break (i.e. pre 2005) then you might want to look at Common Table Expressions as an alternative.

From my...

Matt Miller (#4) (12/10/2014)

---

sqldriver (12/9/2014)

---

Grant Fritchey (12/9/2014)

---

Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than...

I would suggest that if your procedure is so complicated you need to step through it you can probably gain a lot by simplifying your code. Often times what I...

Not complicated. Just tedious to debug when changes need to be made.

I guess it also goes against all my reflexes for other programming languages, which is to break a...

Sean Lange (12/9/2014)

---

Here is where I am going to disagree with Gail and Grant. I have worked on a system that had many procs nested like this and it was...

I could have table results with hundreds of thousands of records. I THINK I read that that is not a good use for table variables. If I...

Hmmm.....by this post I found on StackOverflow, everyone can see global temp tables.

There are two types of temporary tables: local and global. Local temporary tables are visible only to...

what if two people run the proc at the same time? Is the ## still within my login space, and can't be used by others?

Thanks for the response.