here's the data in consumable format for other posters; I'm still trying to get my head around the requirements:

With MySampleData

(AgentID,State,StartTime,EndTime,Duration)

AS (

SELECT '1234','NotReady','04-05-2011 08:00:00','04-05-2011 08:00:05','5' UNION ALL

SELECT '1234','Ready','04-05-2011...

John I'm not saying this is the right way to do it, this just happens to be how I thought it might work;

how about creating a table CustomerAlias, and it...

yeah it requires, at a minimum, a new query window if you add a new keyboard shortcut; restarting is more than you needed, but it works too!

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 TheDate,

...

oskargunn my apologies; i pasted the wrong script from my collection; I've edited the example above, which should do what you wanted for your example.

ok, it's possible in HTML, but how to inject it into a report is the part i cannot help with.

you can google "CSS highlight TR" for code examples, but essentially,...

Mad-Dog (5/4/2011)

---

Hi,

I've a table with those columns (datetime,int,int) in this table i insert every hour a record of getdate() and two int value.

my question is how i can write the...

yeah, whatever you create, you have the right to destroy..that's what can be scary about granting db_owner...they can drop the database with that right/role.

so with ddl_admin, if you create...

Jason Tontz (5/4/2011)

---

Hello all.

I need to create a role that allows members to create tables in the database. I want to nest db_datareader, db_datawriter as well. This will allow db...

yes, absolutely correct. roles are cumulative, so if i belong to two roles, i get access to whatever was granted to each role.

grants are cumulative, and deny's/revokes top dog: if...

did you find out what it was? was it a job or a script or application that was running?

SKYBVI (5/4/2011)

---

Yesterday, i had to change the sa password on a dev server.

From since then, I am getting errors in sql logs that

Login failed for user 'sa' ; client local...

per login = possible.

per database = not possible.

you can restrict the number of connections for a login, but not which databases they touch AFTER they complete the LOGON process; the...

you have to use the AND for subsequent AND join criteria:

SELECT *

FROM EMPLOYEE

INNER JOIN GEOGRAPHY

ON EMPLOYEE.CITYTBLKEY = GEOGRAPHY.CITYTBLKEY

AND EMPLOYEE.COUNTYTBLKEY= GEOGRAPHY.COUNTYTBLKEY

AND EMPLOYEE.STATETBLKEY= GEOGRAPHY.STATETBLKEY