My system generates every day 3 reports 150+ columns each.

It's not for printing, it's for feeding some freaky software. It needs 4 columns just for date: MM, DD, CC(century), YY.

And...

Peter, why are you trying to create a problem where it's already solved?

Another portion of flame.

Can you offer anything else?

BTW, if could read and understand written text you'd see I did not force anybody's boss to solve their problem.

I said it's boss's...

Really helpful post.

Really.

Is spamming is the only purpose of your presence here?

> if you have defined a column as VARCHAR(1000) "just in case it happens"

In case when it happens - insert fails.

So, there is no point to hold exceeding length of...

I don't think anybody here is using programming language which does not support date/time datatypes.

Use proper datatype, don't create problems for yourself.

It's your boss's job.

> I have this output (abc,xyz,kty).

Can you tell from where?

You know, it's too late to apply quotation when the string is built.

If any value has a comma in it you...

Unfortunately, that's the only option.

What's the data model/application you can't modify?

Does it drop XML into table directly?

Does it use any SP for it?

Did you want to say "They are both wrong?"

Because BR concept is definitely wrong from math point of view.

I don't see where TR is wrong, but probably you know something...

How come XML appeared in a table column?

You suppose to catch XML on its way in and process it immediately.

Look at SP which saves XML into the table and use...

Lowell, don't you think it's you who is wrong-minded for considering I ever discussed any business concept here?

I objected mathematical concept of BR. No more.

> we all know there...

Another flamer is going the same way.

"Who are you, Bruno, to tell that the Church is wrong?

Do you mean all Fathers are stupid?"

Can you bring any more intelligent support for...

By definition.

By assumtion of of absolute precision of supplied numbers.

By implication of all trailing zeros.

By limiting list of processed values to the set of precise decimal representations.

By dragging trends of...

I believe table does not disappear just because you call SP.

Why you cannot pass just reference as a parameter and read the text from the same table inside SP?

Read BOL topic "CREATE FUNCTION".

The only EXECUTE statement allowed inside of UDF is "EXECUTE statements calling an extended stored procedures".

"Statements not in this list are not allowed in the...