If the datepart you're using is Days, then the order does not matter, but if you are using any...

itzfake (7/31/2009)

---

I have 3 tasks with success constraint link executed in the following order :

Script Task 1 -> Script Task 2 -> Email Script Task

If Task 1 and...

A pivot table in what software? Excel?

You need to code the margin as a calculated member in your pivot table software, not in SQL.

Drew

I realized what I was missing when I first approached this problem. You have to get a result for every single combination of account ID and required header. ...

First, why does your #header table have a duplicate ID? The purpose of an ID field is to uniquely identify a particular record. Your headerID with a value...

This approach should work, but it is UNTESTED. It divides the clients evenly, but, and this is a big but, it does not retain the order.

1) Create a...

I'm not sure how your margin is calculated, but it sounds like you have an issue with a semi-additive or non-additive aggregation. For instance, if you have a formula...

It's not necessarily pretty, but this will work. Convert the datetime to a string in Canonical ODBC format (20 or 120), but truncate the string at the first digit...

First off, I would recommend to anyone posting sample data that includes dates to put the dates in 'yyyy-mm-dd' format. That format is unambiguous whereas the formats 'dd/mm/yyyy' and...

You haven't provided enough information. Please read the following link about asking questions.

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx

Grant has already guessed at the problem you are facing, but he shouldn't need to guess what...

I prefer using DELETE

FROM [TableName]

WHERE RowID IN (

<Subquery here>

)

I like this, because it's very clear which table you are deleting rows from.

Drew

glugingboulder (7/29/2009)

---

ok sorry about the poor formatting.

Basically i need to combine data from 2 tables into 1 that have no relationship to each other. It will transfered to a monitor...

You should not be joining on columns that contain Nulls, because, except for certain functions like IsNull(), any expression containing a null value evaluates to null under ANSI Standards. ...

I would use a CTE with a Row_Number().

WITH Rooms AS (

SELECT

Row_Number() OVER (PARTITION BY HotelRoom.RoomID ORDER BY HotelRoom.RoomID,...

In the properties for your Data Flow Task, there is a property called MaximumErrorCount. Set this to the number of errors you want to allow before failing the Data...