You can try this to see if you filter the correct data:

SELECT

Department,

Tax_Year,

Tax_Period,

Total_Bill,

Total_Hours,

Purchase_Order_Number

FROM Timesheets

WHERE

(Department = '971')

AND (

( (Tax_Year = '2009') AND...

Good luck! and don't forget to share the experience 🙂

Iulian

Hi Ashok,

What I would do from here is:

1. add an identity_column to the initial table, so that we know what consecutive means.

2. create a...

I think I have got it,

so if they are consecutive records with the same attrib it should combine them and result one single record with begda the begining of...

Here is the full script:

CREATE TABLE #X( id INT, attrib INT ,begda DATETIME ,endda DATETIME)

INSERT INTO #X ( id,attrib,begda,endda )

SELECT 1, 100, '3/10/2010', '3/31/2010'

UNION ALL SELECT 1, 100,...

It looks very much like this:

SELECT * FROM X

ORDER BY

LEN(attrib) ASC ,

begda,

DATEDIFF(DAY, begda, endda) desc

but why are 3 rows left outside from the result set

(

...

First I would create the initial table with the following script:

CREATE TABLE X( id INT, attrib INT ,begda DATETIME ,endda DATETIME)

INSERT INTO X ( id,attrib,begda,endda )

SELECT 1, 100,...

Thanks for the question,

Does the correct answer change if we replace UPDATE with INSERT in the question?

Regards,

Iulian

Nice question.

Thanks,

Iulian

easy one, thanks

Iulian

Nice article, thanks

Iulian

Thanks Craig,

Um, why would you do that?

REINDEX, sure. Shrinkfile? That's not going to help here.

Shrinkfile, if anything, will make it...

Thanks a lot,

Now I understand, though the documentation is confusing.

Does anyone has at hand a small sample in order to try it. Even if it sounds well documented I...

Not sure about this. Please explain.

The /Conf[igFile] parameter of dtexec

Specifies a configuration file to extract values from. Using this option, you can set a run-time configuration that differs from...

I would evaluate the database with DBCC CHECKDB and also shrink it with DBCC SHRINKFILE.

Regards,

Iulian