i can get the scope of it; but if u could provide some sample data along with a snapshot of the expected output, we will be all set to launch...

If u dont need data that are between start and end and also < @Start, why not put, < @End only in your query ??

Pleasure's mine.. Thanks for the feedback, vinayak.

I am a dud in SSRS; Probably if you post in SSRS forums of this same site, you may get a good code. Sorry, i couldn't be of any help...

How about this?

Table Structure:

CREATE TABLE [thoughts]

(

id INT IDENTITY(1, 1)

...

Because that is how Joins work with NOT EQUALS operator

When u use a JOIN, SQL expands the the entries in the following manner:

Now as u have used NOT EQUALS for...

or this?

SELECT ID ,

First_Login = MIN (LogInTime) ,

Last_LogPut = MAX (LogOutTime) ,

Time_In_Office_InSeconds = DATEDIFF ( ss , MIN (LogInTime)...

Thanks Jeff, i hadn't had time to search for it 🙂

Please have a look at this article[/url] to learn about how to do that..

Try this:

;WITH A AS (

SELECT C1,C2,C3 FROM TABLE)

SELECT * FROM A --gives us result

SELECT @@ROWCOUNT CountOfRows

Try this:

DECLARE @table TABLE

(

ID VARCHAR(30),

LogInTime DATETIME ,

...

timotech (2/19/2011)

---

Perfect. Cold Coffee, you're the man, thanks so much for your help. Thanks Jeff also for your help, please how can i get an article or something that explains...

Ok, how about this?

declare @BeginDate datetime, @EndDate datetime, @Station nvarchar(4), @BeginTime nvarchar(8), @EndTime nvarchar(8),

@Scheduled int, @Duration int

set @BeginDate = '2 jun 2010'

set @EndDate = '3 jun 2010'

set @Station = 'b83'

set...

Timotech, just change the >= to > in the CapturedExtra column and check if it is performing the way it should...

This?

DECLARE @Scheduled VARCHAR(2) = '3'

,@BeginTime VARCHAR(8) = '05:55:00'

,@EndTime ...