Service Order ID | Service Order Created At | Serial | Service Order Categorization code

3000000021 | 2009-03-15 20:34:10.000 | 110214 | A04 B22 C17 D00 E00

3000000049 | 2009-03-15 21:00:49.000 |...

I know... otherwise I would never have dared to say that 😉

Thanks, Gail. Nice to see you back.

Thanks for letting us know you solved it yourself, Virgil. Don't worry about it. We've all had moments when we overlooked a simple and obvious...

It only takes a second when you are doing something like expanding the maximum size of a varchar field, because none of the actual data rows have to change. ...

This I gotta see....

You guys rock, but the vocals are like nails on a blackboard.

Were the rows populated, or did it have nulls in the char(1) column?

Try this: EXEC database.schema.procedureName

If your database is called Reports, and your procedure is dbo.InventorySummary you would use:

EXEC Reports.dbo.InventorySummary.

Hmmmm party encounters a Spamming Troll...

Roll 3xd10 for saving throws against annoying misspellings....

Wizard casts Ancient Programming Languages...

Elf has shot the food!

Anything slower than "instantaneous" is too damn slow, Gus 🙂

Hey Eswin,

(1) Please don't post to the "Problems Getting Worse" thread to call attention to your questions. That's...

I am trying to imagine what the forms for RPG.NET would look like.

The mind boggles :w00t:

The joke is REALLY old school. I cut my teeth on RPG II on an IBM System 32 back in the late 1970s.

So far as...

Old school string manipulation?

declare @xml xml

declare @string varchar(max)

set @xml =

'

'

set @string = cast(@xml as varchar(max))

set @string = replace(@string,'','')

set @string = replace(@string,'','')

set @xml = @string

select @xml

OK... Editing here because this is...

Subqueries don't make queries horrible 😉 How have you approached the problem?

By way of explanation, it appears to be trying to convert the money datatype to the varchar datatype to make the comparison. (Not convert the '0.00' to money.) ...