Try this:

DECLARE @TblName NVARCHAR(1000)

SET @TblName = 'YourTableName'

DECLARE @sql NVARCHAR(MAX)

SET @sql = ' SELECT ''Minimal Values'''

SELECT @sql = @sql + ', MIN([' + isc.COLUMN_NAME + ']) AS ' + ' [MinOf'...

It is not very good practice to call a column IsPaused to store start time of the Pause as it is totally missleading (and looks stupid, question: IsPaused? answer: 1...

doobya (7/4/2010)

---

even simpler and more efficient is to use a single record per session:

create table dbo.TimeLog (

[TimeLogID] int identity

,[EmpID] int not null

,[LoginTime] datetime not null

,[LogoutTime] datetime

,[PauseDuration] int not null

,[SessionDuration] int...

doobya (7/4/2010)

---

I don't like complex queries over large datasets when you can easily cache the data:

declare @timeLog table (SNO int, EMPID int, [STATUS] char(10), [DATE] Datetime, [DURATION] int)

the logout logic...

If I will...

Read this:

http://msdn.microsoft.com/en-us/library/bb500440.aspx

And learn how to google 😀

Yes, you need to convert everything into varchar (actually, you would need to do it anyway even using your cursors). Yes you can do it with money, numerics and datetimes....

The very common result of trying to get data by hands without using appropriate tool is:

And, as mentioned by Steve, DBCC utilities comes...

I do really like...

How you get this bar separated data in a first place?

Does it come from GUI or loaded from...

You do allow sql injection in every place where you perform string concatination. To avoid it - use sp_executesql.

What is your table structure and what are you passing in @Demographics...

Back it up and restore it as database with different name

Paul White NZ (7/2/2010)

---

...

Oh, and in case you were wondering, very very few professional DBAs know the precision and scale formulas - or even that they exist, so don't sweat...

Sample of schema you have? Some data for representing a query which you don't like? What you would like instead?

Please click on the link at the bottom of my signature...

You are welcome!