Is this a query analyzer problem only? In query analyzer, check tools, options, results tab. What does it say under "maximum characters per column"?

That's definitely a possibility. With this query, however, you cannot control what fiscal_monthname will be if there is more than one (distinct) possible value. If that's a problem, you might consider...

As I tried to say in my previous post, I think I understand your point.... I only wanted to say that on SQL Server 2000 you don't lose anything (except...

How can we solve this if there is more than one route from origin to destination? Do you have a way of specifying the route?

I.e. do you want the route...

I assume you mean an initial value of 100 Try this:

declare @a table(ID varchar(10))

declare @b-2 table(PID varchar(10), ID varchar(10))

insert...

There is a well-known trick for this, which uses a function. Please see code below.

-- Table definitions

create table productoptions

(optionid int, productid int, optionname varchar(10))

insert productoptions select 200, 1027, 'Size'

insert productoptions...

The point I wanted to make was that "select count(x) from table" gives you the number of non-null values returned by the statement "select x from table". This applies when x is...

If Jeff's and Vladan's posts don't help you, please see if you can write a script that reconstructs the error. I.e give us table definitions, a few sample data on...

Mike, you consider count(*) a special case and write that "count(column) eliminates null values". jwainz has a point in mentioning that count(*) and count(1) are equivalent, since count(1) is not...

A side remark: Perfromance while setting up test data is probably not something one worries much about... But it is faster (and easier, I think) to use a Numbers table:

SELECT TOP...

Kevin, very interesting... I couldn't get your loop started, so I pre-added some code... Also, I think "AND t1.datetimestamp > t2.maxFlag" is redundant...

First of all, thanks for a nice article, Michael. I liked it.

I have two comments. In the "ANSI Versus Microsoft" section, you give the example

SET ANSI_NULLS OFF
SELECT * FROM [Northwind].[dbo].[Employees]
WHERE...

I guess so Try something like this:

declare @tbl table(Name varchar(100), Surname varchar(100), Ref int, Amount int, Date datetime)

insert @tbl select 'Joe',         'Blogs',            2333,    ...

You could also try

select dateadd(d, datediff(d, '1900', pi_dtbirth), '1900') as [Date] from pi

(or a number of other possibilities). Then you don't have to worry about language settings

This seems not to work. I get one row with the example below:

create table #test(a int null, b varchar(10) null)

go

insert #test select 1, ''

SELECT *

FROM #Test

WHERE BINARY_CHECKSUM(*) = CHECKSUM(*)

drop...