Also be mindful of the overhead

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/10/15/udf-overhead-a-simple-example.aspx

Dont think that im being awkward for the sake of it , just helping you to help yourself.

Have you looked up Patindex in BOL (Books On Line) to see what...

It will be a simple case of joining the table to itself on username and patindex('%'+table1.rep+'%',table2.rep) > 0

should be simple maths

ie

ceil(1670/1000)*1000 = 2000

ceil(101.4 /100)*100 = 200

s ss (10/14/2009)

---

My saying "within 5mins" meant the OP asked a question without table definitions, insert scripts and saying it's urgent still got an answer without anyone asking him to...

try this

with cteWithRow( Rep, CId ,StartDate, Type ,Purchased, Cost, Used, Balance, BannerRevenue,Rown)

as

(

Select Rep ,CId ,StartDate, Type, Purchased, Cost, Used ,Balance, BannerRevenue,

...

Please see the links in my signature below

You have to left outer join from your list of known values...

Try this (Untested but should be fine),

if not please post ddl and sample data.

SELECT values.number as 'Hour', COUNT(report_date) as...

At a complete guess, is this what you meant ?

Select SchoolCode,Count(*)

from students

group by SchoolCode

If not please provide DDL (data definition language) sample data and expect output

This did get covered a while back , and the general opinion is that there is no such thing as a bad question. Just a badly formed one...

Specifically posts...

SELECT count(EventLogID) as EventsGenerate, DatePart(wk,CreateDate) as CreateDate,

row_number() over (order by DatePart(wk,CreateDate))

FROM ...

ummmm,

Create Table #tablename(

......

)

Im afraid no one here will be able to tell you if

1000 = 01:00:00 or 00:10:00.

For you sake , i hope it should be 00:10:00.

declare @t integer

Select @t = 10000

Select @t = 151157

Select floor(@T/10000),floor(@T%10000/100.000),@T%100

Have you made a typo ?

1000 = 01:00:00 should that be 10000 ?