some sample data from table,i need to extract with select

LOG_NUMBER,EVENT_TIME

002,2011-08-07 20:29:05.787

002,2011-08-07 20:29:05.787

002,2011-08-06 20:29:05.787

002,2011-08-05 20:29:05.787

002,2011-08-05 21:29:05.787

003,2011-08-05 21:29:05.787

003,2011-08-05 20:29:05.787

004,2011-08-08 20:29:05.787

004,2011-08-08 23:29:05.787

005,2011-08-06 20:29:05.787

i need to put the results in here

+N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventtime ]),'<p class="datarowserror">Not Avail') + N'</p></TD>'

+N'<TD>' + ISNULL( + '<p class="datarows">' + CONVERT(NVARCHAR(MAX),[eventid]),'<p class="datarowserror">Not Avail') +...

this syntax give me the right results but can it be change some how to start with a select first and not with "with cte as"?

THX

the table hold a lot of events from the same event per day.

i need to extract only one event per event per day from every event.

THX

i only give you an example of when you call the EXE file that have space in it you must include the "" in the syntax,

and when i need to...

'C:\FOLDER' is not recognized as an internal or external command,

operable program or batch file.

NULL

and if i take the command "C:\FOLDER A\xcopy.exe" "C:\test 1\test.txt" f:\

and run it in cmd it's...

simple script that not working when i have 2 sets of quotation marks

EXEC master..xp_cmdshell '"C:\FOLDER A\xcopy.exe" "C:\test...

yes i have to call the EXE file with the quotation marks in it and the parameters needs to have quotation marks too.

can it be done somehow with the xp_cmshell that can take the table and insert it to html file?

still how can i achieve that through the sql server?

the output from the sql and send it direct to the email body isn't working like it work in a regular html file.

it looks good,but how i can view the "real" datetime as it was insert into the table and not 00:00:00 in the time?

THX

Lowell (5/5/2011)

---

so does this give you the results you were looking for?

SELECT

TheDate,

USERS_COUNT,

CONNECTION_COUNT

FROM

(SELECT

DATEADD(dd, DATEDIFF(dd,0,RUN_TIME), 0) As...

i need the high result from USERS_COUNT every day.

here is the table

CREATE TABLE [dbo].[TBL_REPORT_COLLECT_USERS_CONNECTION](

[RUN_TIME] [datetime] NOT NULL,

[USERS_COUNT] [int] NOT NULL,

[CONNECTION_COUNT] [int] NOT NULL

here is the insert every hour

INSERT INTO TBL_REPORT_COLLECT_USERS_CONNECTION(RUN_TIME,USERS_COUNT,CONNECTION_COUNT)

SELECT GETDATE()AS 'RUN_TIME',COUNT(DISTINCT loginame) AS 'USERS_COUNT',count(spid)AS 'CONNECTIONS_COUNT'

FROM master.sys.sysprocesses

WHERE...