Viewing 15 posts - 20,656 through 20,670 (of 26,484 total)
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....
June 1, 2009 at 2:05 pm
Jus (6/1/2009)
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]...
June 1, 2009 at 1:58 pm
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...
June 1, 2009 at 1:45 pm
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.
June 1, 2009 at 1:42 pm
Have you tried changing this, 'TEXT()' , to this 'TEXT'?
June 1, 2009 at 1:07 pm
meichner (6/1/2009)
... It seems redundant to...
June 1, 2009 at 1:03 pm
Jeff Moden (6/1/2009)
Heh... me too. How do you like your pork chops done, Lynn? 😀
Pounded thin, breaded, and fried. 😛
June 1, 2009 at 12:38 pm
Steve Jones - Editor (6/1/2009)
I'd like to whack the Quote button. It gets a little crazy at times.I edit mine down to just the person I'm quoting.
I find that refreshing...
June 1, 2009 at 12:36 pm
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...
June 1, 2009 at 11:00 am
Care to provide the error message(s) you are getting when you attempt this?
June 1, 2009 at 10:55 am
Alvin Ramard (6/1/2009)
Grant Fritchey (6/1/2009)
Lynn Pettis (6/1/2009)
Grant Fritchey (6/1/2009)
Lynn Pettis (6/1/2009)
June 1, 2009 at 10:46 am
Grant Fritchey (6/1/2009)
Lynn Pettis (6/1/2009)
June 1, 2009 at 10:26 am
Steve Jones - Editor (6/1/2009)
I have a few people a year sending me email for refunds for SSWUG. Apparently they get upset when SSWUG links to me.
You've linked to sswug.org...
June 1, 2009 at 10:24 am
I'm verifying when I can republish the articles. Once I have a definative answer, I'll see about sending the articles to Steve to be republished here on SSC (unpaid...
June 1, 2009 at 10:13 am
Great. I guess I can read them because their my articles, becuase I sure as heck didn't pay for a membership. Why pay for something I can get...
June 1, 2009 at 9:49 am
Viewing 15 posts - 20,656 through 20,670 (of 26,484 total)