I figured it out

here is the sql u have to do just if some 1 has this kind of a question

select name,disposition,sum(TCDatabase1), sum(TCDatabase2),

sum(TCDatabase3) , sum(TCDatabase......

from

(

SELECT LocalUserId as [name],disposition,

COUNT(*) AS...

This is what i have right now but it is not working fully

example data is Date is 11/19/2007

id=1

starting_time= 11/19/2007 3:00:00 AM

ending_time = 11/19/2007 4:00:00 AM

DECLARE @STARTing_time DATETIME

DECLARE...

do u have an example code for that. I am k with sql no that good.

Thanks

Thanks it worked

i think i figured it out. thanks for ur help.

it is not giving the right results. IN my frist proc i pass the username to get what the user have access to what servers. He can have access to...

Thanks for your help. I had made the lookup table how to use it was the problem.

One more question if i want to show only the the abbrev for the...

Thanks for your help. used it in the where clause.

Thanks for ur help

Actually there are 11 whens in the statement. i get an error Case expressions may only be nested to level 10.

Here is the Query. I have hardcodded some stuff....

I had to change my query. i used a subquery. But still i am baffeled why it was not working.  i am using a link server to update probably thats why. It woked...

When i run this query i get only 1 row. The user table has three rows for for eachid. The first rowid is always 1 the second rowid is always...

Thanks i got till here.  When i run select @userid, @username in my stored proc i get 3 records example

userd=1 username - king@yahoo.com

userid=2  username -= king2@yahoo.com

Userid=3 username =

This is the SQl i am geting the domian from an email address. This sql is only used to get the domain from an email address

Declare @usersemail varchar(50)

SELECT @usersemail=(SUBSTRING(loc_bus_email,NULLIF(CHARINDEX('@',...

Thanks

Have a nic e day.