You can

SET @Counter = (SELECT COUNT(ID) FROM SomeTable)

How about

SELECT count(distinct(performed_by_user_id)) as 'No of distinct Users',

CONVERT(varchar(11),event_date) as 'Date'

FROM tablename

WHERE condition

GROUP BY CONVERT(varchar(11),event_date),CONVERT(varchar(10),event_date,120)

ORDER BY CONVERT(varchar(10),event_date,120)

WHERE CHARINDEX(','+fname+',', ','+@Param1+',') > 0

will solve that

Change GROUP BY clause to GROUP BY event_date

Try

Select t.Response , Count(c.prompt) as 'Number', (Count(c.prompt) * 100)/@tot as 'Percentage'

From #Responses t

Left Join custsatisfaction c

On c.prompt = t.Response

and c.datesubmitted Between @startdate And @enddate

Group By t.Response

My 2 penny worth (or cents if u like). In cases like thses I create another table in the same database and copy the contents to it.

e.g. create tableacopy and...

Since my previous reply, today one of my apps got Error -2147467259 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).

This is the first one for two months. The app was 8 minutes...

If the resulting field of the update in the proc is text then I suggest you pass each variable separately and use WRITETEXT and UPDATETEXT as appropriate.

Due to the SQL limit of 8000 characters, I don't think what you are trying to do is possible.

If you reduce the variables to 4000, you can use a third...

I had similar error (not DBNETLIB) connecting to SQL7 in DMZ behind firewall and could not find any reason.

I changed my code to populate the recordset before processing the contents...

Try http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaskdr/html/askgui05292001.asp

Will only display first row

do until dkrResult.EOF

response.write(dkrResult.fields("customerid").value)

dkrResult.movenext

loop

will show all rows

I'm a bit confused, are you saying that when you store your records you do not know if the date is blank or contains a date.

If this is the case...

If it is a SQL7 MDF then try sp_attach_db

I believe is must have same system properties (sort order etc)

I think it is to do with for format of the input file. You're data is in character format and therefore you need to tell bcp that. To use SQLINT...