ta.bu.shi.da.yu (8/3/2009)

---

I'm thinking that I'll just use a cursor or a while loop. I was thinking of running the query as the select statement in the cursor, then find the...

If all else...

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. ...