Actually, not in this case. You really...

This could, perhaps, be turned into an editorial, but I felt compelled after this weekend to say something.

You may have read my post late last week looking for help, not...

jchesnut (6/1/2009)

---

Hi All,

I am trying to get the two rows on top to aligin (ltrim) and remove the leading spaces but the records but it still comes out as below....

Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post. Possible that I am...

If you notice, GSquared took the time to format your code the way you should when posting questions.

Nope, not helping. Still don't see what you are trying to accomplish. You really need to SHOW ME what you are trying to accomplish, not just tell me....

Jus (6/1/2009)

---

DDL:

CREATE TABLE [dbo].[testcases](

[testcase_id] [int] IDENTITY(1,1) NOT NULL,

[ScenarioName] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[scenario_category] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[expected_bundles] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[expected_promotions] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_order] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[on_profile]...

How about the DDL (CREATE TABLE statement) for the table and some sample date (in a readily consummable format)? With that, we may be able to help you out...

Could you put what you are attempting to accomplish into some context? The SQL you provided will only have 3 rows returneded. The union will eliminate duplicates.

Have you tried changing this, 'TEXT()' , to this 'TEXT'?

meichner (6/1/2009)

---

I put a constraint on the Shipping Details to make sure that the SOID and the Line # exist in the Sales Order Detail.

... It seems redundant to...

Pounded thin, breaded, and fried. 😛

I find that refreshing...

I guess I'd want to see the DDL for the tables and some sample data for them as well. This way I could see what you are asking rather...

Care to provide the error message(s) you are getting when you attempt this?