Lynn Pettis (4/2/2012)

---

SSIS shouldn't have anything to do with Database Mail.

What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS....

Waia minute...you said for all...

CDONTs was a com object, and that error says it's not registered yet;

you may need to copy the dll to the server, and then register it.

http://www.jppinto.com/2009/03/install-cdonts-mail-component-and-smtp-on-windows-server-2008/

I know from your outer...

Ravi take a look at this thread on the...

we have that in a few tables;

it's usually something like an Entity and need to to identify the "prime" entity,

an example might be a table of bank names,...

looks like licensing:

licensed for cores on the hardware, or optionally with client cal licenses:

http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx

SET QUOTED_IDENTIFIER OFF

USE "SandBox";

select * from sys.tables

--above shows a syntax error

GO

SET QUOTED_IDENTIFIER ON

USE "SandBox";

select * from sys.tables

--above works just fine

Charmer (3/30/2012)

---

Lowell (3/30/2012)

---

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you wanted...

anthony.green (3/30/2012)

---

another way would be to create a custom DDL trigger for the CREATE_PROCEDURE event which reads in the XML details of the procedure creation and checks the schema XML...

i think that syntax was valid for 2000, but not 2005 and above;

as i remermber it the solution is simple...

include the sd.SalesOrderId in the select, and

i believe...

both answers help me visualize this a lot, thanks guys;

The Coupon/Discount table's the way I'm thinking as well...it's like Sean said, the discounts apply to the order, not the individual...

how about a view, so you have the date? is that what you want?

Create view TableToday

AS

select

DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) As TheDate,

GETDATE() as TheDateTime,

edit: misread the question...thought you wanted a table...

the error 'cannot assign a default variable' shows the script is for 2008+, and you are running it on 2005;

it'll need a couple of minor tweaks.

i would prefer to track the cost price and the retail price, and calcuate the percentage of markup myself.

so often the retail price is going to end in "9", to...

if this helps anyone, or generate suggestions for my process, great!

this is exactly how i do it.

in my case, i need an individualized email for each recipient...no emails with mulitple...