Thanks a lot, the results is great.

CGZ (11/7/2013)

---

Good point! I've replaced the variables with another CTE.

I have also changed the code to prevent recursion by adding a Tally table so...

CGZ (11/7/2013)

---

I guess this solution works as you want.

I used a temp table with the data from your first post.

/***********************/

/* TEST DATA ...

show it in graphic

the excel data file on 4 Nov 2013 19:00:00 to 5 Nov 2013 09:00:00

https://drive.google.com/file/d/0B-NM1bwOKut7TFJZWEc4ZGI1VDQ/edit?usp=sharing

durai nagarajan (11/5/2013)

---

Sure can help you, can you post your table structure.

Just a doubt do you have backup every 1 sec? even then the time you mentioned is not matching,...

durai nagarajan (11/5/2013)

---

Sure can help you, can you post your table structure.

Just a doubt do you have backup every 1 sec? even then the time you mentioned is not matching,...

durai nagarajan (11/5/2013)

---

What do you mean by every 10 mins, view is not a job that executes...

I don't know how to use...your're inline and rcte...function

I only know a little of SQL....

Please tell me more.....thanks

cs 29850 (9/23/2013)

---

Thanks for your're help.

I found the solution of today record only

anyone can teach me who to show every day records,

select Period.[Time], count(FileBackup.Hostname)

from dbo.FileBackup, dbo.Period

where (CONVERT(varchar(19), FileBackup.DateKey, 120)...

Thanks for your're help.

I found the solution of today record only

anyone can teach me who to show every day records,

select Period.[Time], count(FileBackup.Hostname)

from dbo.FileBackup, dbo.Period

where (CONVERT(varchar(19), FileBackup.DateKey, 120)

...

Erland Sommarskog (9/22/2013)

---

Again:

1) CREATE TABLE statements for your table(s).

2) INSERT statements with sample data, enough to cover all relevant cases.

3) The desired result given the sample.

I will be travelling tomorrow,...

Erland Sommarskog (9/22/2013)

---

I repeat what I said in my previous post:

Generally, when you ask this question like this, it helps if you post:

1) CREATE TABLE statements for your table(s).

2) INSERT...

Erland Sommarskog (9/22/2013)

---

Not sure why you would create an inline function at all. The reference I gave you is from...

pietlinden (9/21/2013)

---

absolutely reeks of a homework assignment.

If you can group by half hours, then you're golden. Try something like getting the number of half hours since midnight, and then...

Erland Sommarskog (9/21/2013)

---

You need a table of numbers, I have an explanation of this concept on

http://www.sommarskog.se/arrays-in-sql-2005.html#tblnum (only read down to the header "An inline function".)

Once you have this table,...