awesome I will take a look at this. Thank you very much, this is exactly why i come to this site.

Thanks for all your help!

Ya i guess i really don't know the difference between a temp table and a variable table. I like using Variable Tables cause they are like a scratch pad....

Stefan Krzywicki (10/28/2010)

---

mbender (10/28/2010)

---

The reason i'm using a TVF is ya i need it to be in a table format. I'm trying to pull the data live, rather then...

WayneS (10/28/2010)

---

mbender,

I see one thing in the TVF - you're calling another function to get the first day of the month. I don't know how you're doing that, but this...

Stefan Krzywicki (10/28/2010)

---

mbender (10/28/2010)

---

The reason i'm using a TVF is ya i need it to be in a table format. I'm trying to pull the data live, rather then...

Roy Ernest (10/28/2010)

---

Check the execution plan and see if there is any difference when executing as RAW SQL statements and when executing as TVF.

Temp tables can be used depending...

timing tests are on my desktop

Are using Temp Tables a no no?

I've just started using them as work tables, and have really enjoyed it. Normally we would do all the work in the asp...

Currently are tables are not indexed.

The reason i'm using a TVF is ya i need it to be in a table format. I'm trying to pull the data live, rather then storing it in...

Ouch!

thanks for your help, this is the SQL Newbies forum correct?

Little background on myself, i'm all self taught and new to actually writing in T-SQL. So if i'm doing...

I am using a multi line TVF

Basically the user gives me a month and an office. I pull some data from the month that they give me and the...

This is why i love this site, this is exactly what i need.

Thank you this helps

Ya its kind of a pain. I can change a few thing, as far as knowing which one to order its really it doesn't really matter as long as...