Bob (and every one else), I appreciate it. You may want to include me, her mom, and sisters as well. I have a feeling we may not hear...

Looks like you are wanting to calculate the volume discount for each customer in real-time as orders are processed, is this correct?

Could you provide us with DDL for your tables,...

Does the COGS calculation need to be run in realtime or as part of the end of day processing? Depending on the volume of data that needs to be...

is another way to it without the cross join (on 1=1 in the ON clause of the inner join):

SELECT

ii.item_name,

ii.date_issued,

...

This was possible in SQL Server 2000 using SQLMail, but I have not found any way at this time to do so with DatabaseMail.

I think it may have been considered...

Could you post some sample data in a readily consummable format for loading your tables and the expected results of the query based on the sample data?

For assistance in this,...

Using the code from earlier in the thread, here is how it could be written using two CTE's.

with myTableCTE as ( -- This CTE creates the column field_C that is...

Chris Kitchen (8/3/2009)

---

Hi,

I'm wanting to make use of the new [Date] data type in SQL Server 2008 but I'm having a problem. I have a .txt file that contains...

It could take several minutes for a the cluster to failover if the active node should crash. All sessions would be disconnected during that time.

Not sure what you could...

Allister Reid (8/3/2009)

---

I would also recommend that you go with Lynn's solution - this kind of un-normalised view should only really be used for display. In the interests of...

I have tried rewriting your code such that I could read it easier.

Please review both the SELECT and UPDATE statements. Let us know if the SELECT statement returns what...

In addition, the code you are posting may not work as written.

So, the addition of two columns in the stored procedure definition also resulted in the stored procedure returning two addtional columns as well, correct? Are these additional columns also...

rboggess (8/3/2009)

---

I didn't say "lack of experience" -- I...

Here is my delimited split dunction for nvarchar values.