j.a.c (5/28/2013)

---

I like that term: Private mentoring session. Kind of like Chuck Norris' motivational seminar?

Ah well not quite. But it is still frustrating to have to point out shortcomings...

Your script is definitely valid. But how are you planning to use it?

Whether this is really useful depends on what you do next .

I agree. But sometimes(when some specific information is not needed, like in this case)...

You can use CROSS TABS to achieve the results

SELECTRIGHT(CONVERT(VARCHAR, CCD.startDateTime , 106), 8) AS startmonth,

SUM( CASE WHEN CCD.contactDisposition = 1 THEN 1 ELSE 0 END ) AS 1

SUM( CASE...

You can use system tables like INFORMATION_SCHEMA.TABLES or sys.tables to create a DROP TABLE script.

Transaction log backups are scheduled based on how much data loss you can tolerate

If the transactions log backup is scheduled every night, it implies that they can tolerate data loss...

Good try creating the DDL and sample data, but there were a few mistakes when I tried to execute it in my SSMS.

I have rectified those and have copied it...

Please don't create more than one thread for the same topic. It just fragments replies and will delay resolution of your issue.

Direct all your future posts to the original thread

http://www.sqlservercentral.com/Forums/Topic1456981-392-1.aspx

There is a book on Backup and Restore by Shawn McGehee

http://www.sqlservercentral.com/articles/books/89519/

Duplicate post. Please post your replies here.

http://www.sqlservercentral.com/Forums/Topic1457156-2799-1.aspx

Duplicate post. Please post your replies here which has more information about the problem.

http://www.sqlservercentral.com/Forums/Topic1457192-391-1.aspx

What is the expected result based on your sample data?

Also it would be easier for people to help you if you put all this in a ready to use format...

You can try this, but I am not sure if this will give the same result all the time

You will need some column which...

Do you have any other column in the table?

Something like this..

SELECTt.ApplicationName AS ActivityName, t.ActivityDate AS LoginTime, L.ActivityDate AS LogOutTime

FROM#temp AS t

CROSS APPLY(

SELECTTOP 1 *

FROM#temp AS t1

WHEREt1.ID > t.ID

ANDt1.ApplicationName = 'Logout'

ORDER BY t1.ID

) AS L

WHEREt.ApplicationName NOT IN ( 'Login',...