I agree with Gail, and be sure to indicate a bit more detail on the "maximum quantity sold per day". There are clearly other qualifications that need to...

hoseam (7/14/2015)

---

I have a problem that requires me to write Daily sum aggregation script, I wrote the script; But what I'm not sure of is the "Daily" part, my script...

Brandon Forest (7/13/2015)

---

Steve, The PL/SQL I need to use to open the recordset is stored in varchar(max). That is the object text I'm having trouble recovering. Whatever method...

That, and using ODBCAD32.exe to get to the 32-bit ODBC configuration.

John Mitchell-245523 (7/13/2015)

---

In your WHERE clause, you're comparing the values in the date column to the value returned by the subquery. If that subquery returns more than one value,...

Wayne,

No one was "slamming" the original poster for the question marks, but perhaps for the lack of clarity on what was being done. When you don't provide much...

SQLDCH (5/31/2012)

---

I'm exporting a table from SQL Server 2008R2 to Oracle 11g. One of the datatypes in the SQL Server database is MONEY. The receiving column in the...

As the parameters now allow the selection of data going back more than 1 day (SQL Server side), is it possible that there might not be any matching data on...

I'm not sure about this, but I'm wondering if this sets up an infinite loop of the trigger firing the trigger. If you changed the trigger to INSTEAD...

tcronin 95651 (7/10/2015)

---

made some SAN settings change looks better today. DO have a question I was going to post anyhow. I have generally set my windows (on win...

vecerda (7/10/2015)

---

Hello everybody,

I have a task where I need to process roughly 60000 excel spreadsheets and bring them into a SQL Server 2014 database. All excel files have the same...

Brandon Forest (7/12/2015)

---

I am developing a table driven ETL system, where I store large PL/SQL queries in a varchar(max) field. I read the field into an object variable at...

Brandon Forest (7/12/2015)

---

I am developing a table driven ETL system, where I store large PL/SQL queries in a varchar(max) field. I read the field into an object variable at...

99zardoz (7/13/2015)

---

Thanks for the replies. I had a feeling it would not be possible. Having done a fair bit of Crystal, I know it wouldn't be possible there and...

Sean Lange (7/13/2015)

---

Plain and simple, you can't. The datatype is decimal, it stores decimal values. There is no decimal value that is the same as an empty string. This is...