Lynn Pettis (9/4/2012)

---

SQL_NuB (9/4/2012)

---

Lynn Pettis (9/4/2012)

---

SQL_NuB (9/4/2012)

---

that date is in the table, so when I do select max(timestamp)...

Lynn Pettis (9/4/2012)

---

SQL_NuB (9/4/2012)

---

that date is in the table, so when I do select max(timestamp) from workqueue, that's...

that date is in the table, so when I do select max(timestamp) from workqueue, that's the most current...

that works if I hardcode the date, however, the data will change monthly and if...

my query looks something like this (I can't show the actual ddl or query)

select top 5 states, customers from tbl1

where type = 'Rented' and (rentalperiod between 200101 and 200012)...

Its returning me 0 for my counts

@CELKO,

[Okay, here is your problem; you have no idea what you are doing]

you need to take a pill there buddy, your no genuis

[You did not define how to compute...

I got the file to upload from SSIS, for whatever reason I had to seperate the file from blank fields to populated field and it worked. Not 100% sure why...

thanks, i was able to get that field working last night, the processs is now failing on another text field. I'm not sure how the excel file was created when...

I'll be looking at it again today.

I get the 16 and 330 when i run the queries in the access app and the against the new sql table I created...

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on...

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so...

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right now, just...

SQLKnowItAll (6/14/2012)

---

SQL_NuB (6/14/2012)

---

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering...

Lynn Pettis (6/14/2012)

---

SQL_NuB (6/14/2012)

---

[OR] clause didn't work, that's the first thing I tried prior to asking.

The data returned is going to be used on reports so no filtering right now,...