thanks, yeah i think the 3rd party people messed up with they made all comment fields ntext!

there is not much to show you for the data the comments field is...

yeah you missed them

count ([Contact PositionSMC]) as positioncount,

CASE WHEN [CONTACT ReplaceCon1SMC] IS NOT NULL AND

...

ok i added the cast as suggested i was not putting that in both the query and the group by

If there are suggestions on how to improve i have...

here is my query the field is a comment field commentsmc

SELECT [CONTACT TaskOrdersmc] AS TaskOrdersmc, [CONTACT PlaceofPerformaceSMC] AS PlaceofPerformaceSMC,

...

my description title was not a good choice i tried to change it but it would not let me.

No my folder is not created that is what this bat file...

you know i think I was over thinking this I probably will just go with a web front end and a table and allow the user to manage...

thanks guys I will check it out I won't be able to do that till monday thanks!!!

so how would I do this via query??

i am not sure how to have it only append to the columns where there is only one char?

I don't really want to...

Nope Now get Error converting data type nvarchar to bigint

I am not sure I know what you mean

Basically right now I have something like this

create stored procedure [mySproc]

As

--change varbinary column to Nvarchar using stored proc

Exec [SPtoConverttoNVarchar]

--Insert data into new...

I tried this, but I keep getting invalid argument

Select s1.[Name]FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0','Text;Datasource=d:\db\pcorfiles\stcvis.txt;HDR=YES,FMT=Delimited',

'SELECT distinct [Name] FROM [Sheet1$] as s1 where [Name] is not null order by [Name] desc'

) as s1

Jeff Thanks that worked great, Except How can i get that to work within an existing stored procedure

here is my Sproc that i am trying to implement this with.

Thanks again

Alter...

this almost does it, it returns the same myareacode list for every caller, and it is not the top 5 by count for each name.

i tried this and a few other things, but just can't get the correct syntax

DECLARE@Stage TABLE (RowID INT IDENTITY(1, 1), CallerName VARCHAR(256), AreaCode VARCHAR(3), Calls INT, theDate DATETIME,myareacode int)

declare @MyAreaCode...

Thanks for all the replies. I know all about storing dates, but the DB is a 3rd party db used to captured data from a switch they set it up...