Search results for query: *

What do you want to do if a logoff time is missing or if a login time is missing?" The system has a process that runs at EOD and automatically writes a logoff event if a user foregets to logoff. I don't think it is possible and have yet to come across a situation where the user is logged on to...

I'm running SQL Server 2005 and have the following question. I have a table which tracks the events created by a group of users. ID code tstamp username 574015 1 4/8/08 08:14:26 user1 575349 2 4/8/08 09:47:40 user1 575352 1 4/8/08 09:53:14 user1 579345 2 4/8/08 14:19:24 user1 579406 1 4/8/08...

I have one large master report, Total, which contains 4 subreports A, B, C, and D. The subreports all pull different data with the same parameter time range, a rolling 13 months. Everything was working smoothly until, to speed up displaying the report, I created a snapshot of reports A, B, C...

Hi, In Reporting Services is there a way to "save" a report with certain parameters automatically. More specifically, a report has been created with date range parameters. I would like to set it so that a copy is "saved" with the dates 1/1/07 to 1/31/07 and called January 2007 so that we do not...

Thanks for the quick replies! Could you post the SELECT ISNUMERIC(column) example that you mentioned? I am still trying to learn my way around BOL. Thanks again!

I have a previously created table that is populated using a BULK insert from a user selected file. This table has only one field, a list of document numbers. I need to go through this list/table where the number of records would vary between 200-500 items and check that the field is a valid...

Thanks for the reply. That seems like the best way to resolve this. ninners

Trying to write a report here and I hit a bit of a snag. I'm trying to create a report that shows incoming calls grouped by half hour for each day. Right now its only showing half hours where calls came in. I'm looking for a way to display every half hour. Even the ones where there is no calls...

Thanks for the input. Never thought to use CSS but will try it out. Thanks again! ninners.

Hi, I am trying to create a line or a scatter chart using data provided by a database. So far I have been able to create bar charts in ASP but I haven't found anything for line/scatter. I am guessing that Javascript is the best way to do this. Does anyone have any good places to look or some...