Well, the two authentication modes supported by SQL Server are Windows and Mixed (both Windows and SQL). So these are your choices :). You can of course play with the...

In the "between" part use valid datatime values. e.g.:

cast ('2008/3/14 00:00:00' as datetime)

AND Tidspunkt BETWEEN CAST('2008/3/14 00:00:00' AS DATETIME)

...

New Commer (7/18/2008)

---

Hi

how to achieve the calculation between two alphanumeric charactered field's value?

we enter only decimal numbers to tht alphanumeric field. but while trying to subtract both the error,...

harriet.louis (7/16/2008)

---

Hello All,

I am hoping you can help. I need to find out if it is possible to read the location of the sql logs from the database. I am...

David (7/16/2008)

---

Hi all,

I have an application that stores time as a numeric value, for example the value 47965 is stored in the database and the application displays the time as...

winston Smith (7/16/2008)

---

ive ran a query to see all indexes associated with an object

select * from sys.indexes(nolock)

where object_id in

(

Object_id

)

for one table in particular, there are 5 indexes returned by the...

The BLOB datatypes that are specified with "max" are available only on SQL Server 2005 and later. You are trying to use nvarchar(max) and the "max" part confuses the 2000...

What you can do is to encapsulate your query into another select statement, and do a max like:

SELECT SUM(COALESCE(x2.Monday, 0))

, SUM(COALESCE(x2.Tuesday, 0))

FROM (

--...

The above is quite a common solution on 2000. For the null values you can use ISNULL with a 0 parameter.

- Andras

Please post only once, we will read all your posts anyway 🙂 The corsspost is on http://www.sqlservercentral.com/Forums/Topic529811-392-1.aspx

Regards,

...

This is a crosspost, one is answered on http://www.sqlservercentral.com/Forums/Topic529811-392-1.aspx

- Andras

Well, you could do something contrived and daft?? 🙂 like:

SELECT MAX(x.nr)

FROM...

lakshya.rahul (7/8/2008)

---

Hi !!!

i have sql server 2000 developer edition installed on my system.

i have created a new database named my_DB

then i have created a new user for the database(my_DB)...

Could you escape the < characters in your xml with & lt; (no space in between) please. In that case we will be able to see your xml document, and...

Just as an explanation: you are most likely working with integers :), and when you do the division, you loose everything after the decimal point. So even in the "solution"...