Chrissy321 (3/29/2011)

---

Actually the late, middle and early sample data was not from the original poster. I was just trying to use my intuitive powers to provide some code that might...

jhors_g (3/29/2011)

---

Ok, thank you very much for your answer, you're right.

well, I have 3 tables in sql, a bill called, detallefactura and abonofactura, what I do is this to show...

This isn't the *prettiest* code, but it functions. I modified the source data to include two clientID's to prepare the code for that. Interesting challenge. I'm hoping...

It helps. Can I ask a question? Why a table valued function? How specifically are you planning on using this data?

The query you want (as a proc)...

jhors_g (3/29/2011)

---

Good afternoon

please necito query a guide, I am developing an application portfolio, my intension is that the bills that are being paid by a client such invoice is not...

First: Welcome.

steven.hulse (3/29/2011)

---

I’ve played a little with the free versions of SQL Server but nothing of any depth. I’m somewhat familiar with the lingo used and know a little SQL....

KevinGurney (3/29/2011)

---

Also, there may be a little bit of back-end tweaking that can be done, whilst using views to present the same logical output to the application. Not knowing the...

jcrawf02 (3/29/2011)

---

If you don't know what your boss needs to know, that implies that you don't know what is important in your own job, and would be First Fail candidate....

<EDIT SNIP TRIM WHACK HACK... I'm not sure it was 2k'able anyway...>

EDIT: Annnnddd, this thing's over a month old. Sorry for helping with the Necro here.

Neither, it's a starting point....

Raghavender (3/28/2011)

---

In between, this is other question on TempDB only:

If we add multiple datafiles to tempdb database we need to keep all datafiles of same size.

Can any body tell me...

Brandie Tarvin (3/28/2011)

---

[Jim].[dba].[Murphy] (3/27/2011)

---

Also, even though tempdb is recreated each time SQL Server starts, unlike a brand new user database, the new tempdb file settings, including it's size is...

GSquared (3/28/2011)

---

Stefan Krzywicki (3/26/2011)

---

Jeff Moden (3/26/2011)

---

Gianluca Sartori (3/25/2011)

---

GilaMonster (3/25/2011)

---

I like...

Daaammmiiittt... you're right, Jeff... and I pointed that out in the first place! D'oh.

OUTPUT...

hmbtx (3/27/2011)

---

Craig:

Thanks. The script worked just fine.

Am I correct that your original script that listed the counts in error cannot also correct the count?

Put another way, is there a way...