Oh, now you're just showing off

another issue you may have with this is whether the space is there after the comma for the state.  It would be better to take everything after the comma and...

I'll bet that BRid is also unique to each record and needs to be excluded from the query.  Your result set that you posted did not include it so we...

Nobody but you can see the image you included in your post because it points to a file on your hard drive. 

most likely one of your rows does not have a comma in it.  Try adding the where clause "where origcounty like '%,%'" and see if it works

This is the same question as your other one.  You should include this info in your other post as well as the table structure and sample data from the table.

My current guess is that you want a pivot table but without knowing the table stucture I have no clue what Questions is or what Results is.  the query output...

It is not the time stamp that is changing.  The file was created at 8pm EST and then the server received instructions to display all times in DST so it...

select * from sysindexes where name = 'indexname'

or

select o.name,i.name from sysobjects o

join sysindexes i on i.id=o.id

 where o.name = 'tablename'

you are multiplying the first column by 1.0 to ensure that a decimal is returned if col1 is an int and you are multiplying the results of (col1 * 1.0...

your result set is a broken image, paste the text so we can see it.

Here is a stored proc that creates pivot data:

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

ALTER     PROCEDURE [createpivot] 

@dbname varchar(8000),

@pivotrows varchar(8000),

@pivottable varchar(8000),

@pivotdata varchar(8000),

@pivotcols varchar(8000),

@pivotfunc varchar(8000)

as declare

@sqltxt varchar(8000),

@sqlstmt varchar(8000),

@pivotcolumn varchar(8000)

/*set pivotrow...

It looks like youare comparing date parts to actual date fields.  When I ran your statement and printed your variables I got

begdate = Jan  4 1900 12:00AM

enddate = Jan  3...

if you are trying to append the data from excel to 2 existing colums in your table you can do that with DTS, use the build query function of the...

You were comparing 2 varchar values instead of datetime values.

In this case the varchar value 01/02/2007 is less than the varchar value 01/09/2006 because it is looking character by character...