Hi,

You can use this kind of query:

Select ISNULL(ColumnNameWithNullValues,0), SomeOtherColumn from SomeTable

Hope it helps,

Cheers,

J-F

Thanks Gail, this post helped me understand how the indexes work on inequality columns! I'm very grateful you took some time to show me how it works in details,

Thanks again,

Cheers,

J-F

For the next query, here is what happens. Seems the optimizer does not use the last part of the query 's'

SELECT *

FROM Translation ...

Nice, I did not know the like reacted as a between when there is a wildcard in it.

But, if it works as a between, how do write this expression as...

I'm...

Varchar is the basic string type. nvarchar is for handling unicode characters, such as é, or other language characters.

You can change the table datatype to nvarchar, but be aware that...

Please post some data using the following http://www.sqlservercentral.com/articles/Best+Practices/61537/.

It will help people help you, since they will have some real data. Try to explain what you want to do and give...

Isn't this feature deprecated? I thought I read not to use this somewhere, maybe my memory had gone wacko, but I prefer to do this in a select, then using...

Nice, I have to say I prefer this one a thousand times, since there is no cursor. I did not know you could append in a string from a multirow...

No worries, my script was not even working until I got some test data, 😉

And I also forgot to divide by the count, hehe!

Cheers,

J-F

I believe you must have a linked server to actually do this. This is why it is failing when you are trying this locally on your machine.

What you can...

Here is a working and tested example. Please post your data next time, it is really a lot longer for us to help you when we cannot test what we...

Even though I do not like the cursor, I don't think there could be another way since you are trying to do some dynamic SQL There. Here's a solution, I've...

Agreed, nothing to tweak there, if you can get the query to work perfectly on your workstation, then the query runs fine. Maybe the bandwidth connection between the app and...

Could this be an access issue? Are you connected remotely to the server, and if yes, by what means.

I had that kind of situation when connecting to the sql server...