This is by design and can be quickly fixed in Management Studio by unchecking a property. To fix this in Management Studio, go to Tools -> Options then go to...

You really dont need to do that. You can format the date anyway you like but still keep the order by on the actual column invoice date and you...

You may Microsoft SQL Server Native Client

Microsoft SQL Server Native Client (SQL Native Client) is a single dynamic-link library (DLL) containing both the SQL...

Why in the world would we be referencing a standard from 89?

I was of course referring to current ansi compliance

As of ansi-92 the *= in sql server and the (+)...

SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/', '') AS [MMDDYY]]

you would need to replace GETDATE() function with your date field. This will display as

010710.

Are the leading zeros a problem?

You could union the selects together and then sort by choice and your existing criteria

select 1 as choice,workstation, date_entered from inventory

where part_number='ABC' and workstation>=5

UNION

select...

left outer join, right outer join would have the asterisk on the right side of the =, this is not ansi standard SQL

I am not sure if this affects just columns in a table that use max or also affects variables, you might one to give the sp_tableoption a try

When the...

I will also check on the limits of character strings, however, if this is an internal string do you really need an nvarchar? if you used the varchar you...

SSC, the reason you have the error is you are trying to reference the main table in your inline view query in the inner join and you can not do...

what is it that you are trying to count. The query above does not have your where clause which is easy to add but is missing the count. ...

you need to provide more information. If the dates are stored in datetime format the sorting will working properly, it appears that you are trying to sort on an...

just to reiterate, you can only use the cte in the following line after the definition so if you define three cte's you must use them all in the following...

I am not sure why you are doing a join on the software table if you already know the four values you want to insert, however, the query I gave...

If I understand your problem correctly, You have all computers in computers table, all software in software table and the compsoft table will have the combination of the two....