NULLIF(FieldName, '')

Yes, I saw that typo when I posted the query but did not bother to update the post.

And it's good that I would fail the test.

Because if you don't...

And to finalize it:

#Work must permanent table populated/updated when a new row is saved in "Header" table.

Then you'll not gonna have any problems with building SELECTs and providing best performance.

Different number of columns depending on a parameter value?

Well, I guess no optimisation could let that project survive till real amounts of data will arrive.

It will always stay on...

I did not dare comment.

You know my French.

If you don't specify the version that means it must work on EVERY version, not only the one you know.

Unfortunately your solution does not run in SQL Server, at least in any of SQL Server installations we use for real product development.

SQL Server 2005 is not still an industry...

Are you sure the code you wrote is written in SQL?

And front end envionmen is single user one.

That's a difference between it and databases.

Try to imitate 10 users run and...

And read "Cast and convert" topic in BOL.

> Wrong! If it takes a bit longer to write scalable code that won't need to be changed, it's worth and extra minute or two for a piece of...

Jeff, a little note:

there was no requirement for proper commenting, there was a requirement for 2 min solution.

Cannot say about anybody else, but my typing would not give me a...

You should not search in ntext field.

It's not a SQL Server job.

You should split Job Descriptions into parts you are interested in when you are saving it. And save...

BTW, the question itself is so "front end"!

The whole nature of a professional database developer protests against mixing different datatypes in one column....

1st of all - my query DOES NOT return an error.

Try before you say.

2nd, if I would include new table into my solution I would separate CREATE TABLE statement from...

It's funny nobody, even author, mentioned an obvious solution:

SELECT

ISNULL(

NULLIF(

CASE WHEN Number % 3 = 0 THEN 'Bizz' ELSE '' END +

CASE WHEN Number % 5 = 0...