DV

Please will you post DDL and a sample of data for the CurrPeriod table.

Thanks

John

WITH NewOrders AS ( -- change prices here as required

SELECT 10 AS orderTotalPrice UNION ALL

SELECT 20 UNION ALL

SELECT 30 UNION ALL

SELECT 40

)

INSERT INTO [Order] (

orderId

,orderCustomerId

,orderTotalPrice

)

SELECT

NEWID()

,c.customerId

,n.orderTotalPrice

FROM

Customer c

CROSS JOIN

NewOrders n

-- Check...

OK, we're getting closer. Now will you please send some DDL that will actually create the tables when I run it on my SQL server.

Thanks

John

Table DDL, please, including foreign key constraint.

John

The same four orders for each customer? If not, what? Also, please provide table DDL in the form of CREATE TABLE statements.

John

DV

Just search for execute sql task parameter mapping - you should find loads of articles. Also, try searching for your original problem - somebody might already have solved it....

It should work with just a SELECT statement. How do you know the variable isn't being updated?

I would recommend that you use a stored procedure in any case, if...

Simon

Since Gail and I have taken the time to help you, and in case anyone else is reading this in the future with a similar problem, please will you post...

Not so fast! Two alternatives here:

(1) Something like (simplified):

WHERE (@datatype = 'B' AND tablenameid IN (30,28))

OR (@datatype = 'C' AND tablenameid IN (11,48,132))

OR etc

(2) My preferred solution...

If you only have changes to your database that often, then you don't...

You will need to do some string manipulation or some arithmetic on your date in order to get it into a format that can be converted. '20110607 11:11:11.111' is a...

Gus is right.

I think sp_delete_backuphistory is date specific, not database specific, so you may end up throwing the baby out with the bathwater if you use it.

John

First off, if your numbers are stored as characters, the first thing you need to do is CAST them as an integer data type, otherwise you may get unexpected results...

Krishna

The only thing I would say on this is that the collation you mention is for backwards compatibility. You should use Latin1_General_CI_AS instead. I'm afraid I haven't worked...

Lee Sloan (6/3/2011)

---

My point may be tangential to the purpose of the article, but it nonetheless is valid: why do we build systems and processes that allow individuals to contribute...