Some information for you:

I'am a Delphi developper, making a asp.net web application.

I have a two columns page: left 450 pixels and right 150 pixels width.

The colums have icons at the...

Kenneth,

Thanks for your explanation, it made clear that it is not an easy problem.

I think that the solution I once saw, was separating the first row from the other rows....

@tab Alleman:

Nice trick, but I am sorry to tell you that it doesn't work.

It gives a "Incorrect syntax error" in the Enterprise Manager.

@gregory Grager

I think that...

Frank,

Thank you for your clear explanation.

See, if I can use your way of handling this problem.

But, I will look futher on, trying to find the solution again.

Maybe it was just...

Frank,

Thank you for your answer.

I tried it, but it is not what I wanted. I'm impressed by your sql but it is to difficult for me to understand the way...

Kenneth and David thanks for your answers.

I see that I didn't explain my question well enough.

The point is, that I want two Queries:

1. one giving the top 3 rows (the...

Try this:

UPDATE MyTable SET DateField = CAST(NULL AS DATETIME) WHERE ID = 1

or

UPDATE MyTable SET DateField = NULL WHERE ID = 1

Jeff,

Thank you for your answer.

You described exactly my pain. My SQL is one page long, and my first solution was exactly the same, so I got two pages of SQL....

That is a good idee.

But ...

I did show you the essentials of my problem in a simple test-program.

The real program uses a rather huge amount of sql, with lots of...

But will it work in the ASP.NET application, written in Delphi?

I'll try 😉

As, eating is the proof of the pudding

David, thank you for your solution.

I tried in the Enterprise Manager:

WHERE CategoryId = ISNULL(NULLIF(@parameter,0),CategoryId)

(it is a nice idee to do it this way)

But it gives an error, saying something like:

(translated...

You could also cast the Text as Varchar, andreplace CR/LF by a space.

I use:

LTRIM(REPLACE(CAST([TextField] AS VARCHAR(100), CHAR(13) + CHAR(10), ' ')))

Sometimes it ends on a #13, in my solution this...

Due to XML or HTML parsing the "Long Text" part of the message and the header has gone, I think.

The message was:

When I have a decimal field (e.g. decimal precision.scal...

Now, is there anyway to query the same information from the DB itself?

Answer

In EM or QA with @@version

E.G.

Open a table (Select all rows) open the Sql window (click on the...

Thanks I'll use DATEADD in the future.

(I corrected the 2nd line in a DateAdd SELECT)

Henk