I think Luke's definitely got a point there. If you leave the two fields separate then you can create a UDF to display as necessary (#, #). That leaves the...

Hi Rick,

You can set the max errors value (on the options tab of the transform data task) to 9999, allowing that many errors before it falls over.

To capture the failed...

If you take a look at the results of these statements:

SELECT SUBSTRING(0x100400, 1, 1) & 16

SELECT SUBSTRING(0x100400, 2, 1) & 4

They return 16 and 4 respectively.

You can think of the...

I would recommend reading the article on this but here's a quick overview. The SUBSTRING of COLUMNS_UPDATE() function operates as follows:

SUBSTRING(

COLUMNS_UPDATED(), -- Bitmask values

...

Have a look at your DTSStep_DTSActiveScriptTask_2 step, line 184

DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Crystal...

Glad I could help. My email is on my profile if you need to bounce any more ideas, either that or posting on here always gets a result from someone...

Well it depends on what you want out of it I suppose. If you're already with a leading supplier then I would have thought that you've got some job security...

[edit]Luke, you got in first! That'll teach me not to refresh the page before replying!!![edit]

I think you might be able to use the SQL Command in the source drop down...

I saw this article today, it looks as though the B group is looking to buy some of the Lehman Brothers' assets. This may be an indicator in to how...

I always start my object creation scripts with the rather long-winded but clearly explainable:

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'myTableName' AND xtype = 'U')

...

This will give you client sub-totals without the need for a temporary table.

SELECT

CASE WHEN client IS NOT NULL AND hourSegment IS NULL THEN 'Client Total'...

If you want the distinct number of orderIDs (if there is more than one row per orderID) I would use:

SELECT cc, COUNT(DISTINCT orderID)

FROM table

GROUP BY cc

The same way I'm learning it. In at the deep end, who needs armbands?!? :crazy:

I think you should be able to concatenate your fields together in your Click method like...

Hi Phil,

How is the summary displayed? Is it in one big textbox or another control?

You may, if the summary is on a different form rather than CSS layer, need to...

I don't think that you can copy directly from the Notepad in to a Forum post, but I suppose you could have the Control Panel with the notepad in another...