Hi

Have you considered putting an option in your drop down for "Show None" and toggle your visibility based on that?

Andy

Deleted as misunderstood requirements

-- Script out indexes completely, including both PK's and regular indexes, each clustered or nonclustered.

-- DOES NOT HANDLE COMPRESSION; that's ok, since 2008 R2 RTM benchmarking shows it's faster and...

Here is a script that will perform a complete health check.

This is not my work - all credits are in the comments

Andy

[Admin Editor: The copyright owner of the code...

No worries, got there in the end 😉

Sorry I've done the best I can on my phone and working blind!

If you could post some sample data and table defs I'm sure we can sort it but it...

Does this work?

SELECT

E.eecCoID AS 'Rec ID',

E.EecEEID AS 'Emp ID',

eepNameFirst AS 'First Name',

eepNameLast AS 'Last Name',

EecDateOfOriginalHire AS 'Service Date',

EecDateOfTermination

FROM

EmpPers

JOIN EmpComp E

ON E.eecEEID = eepEEID...

I've not got a copy of visual studio anywhere near me at the moment to have a dig around, I'm sure I've done this...

No probs 🙂

The OR operator is a dangerous beast, and you also had your <= >=evaluations the wrong way round 😉

Andy

I'm not at my laptop at the moment however does this work for you?

--With Terminations

SELECT

----DATEPART(YEAR, e.eecDateOfLastHire) as 'Year of Hire',

--EEPDATEOFBIRTH,

CmpCompanyCode AS 'Company Code',

E.EecOrgLvl2 AS 'Org Level',

cmpCompanyName AS 'Company Name',

E.eecCoID AS...

You could add these into your WHERE clause for the date range:

SELECT DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 0) First Day of Last Week

SELECT DATEADD(ww, DATEDIFF(ww,0,GETDATE()), 0) + 6 -- Beginning of 6th day...

+1

That has saved me more than once!

Hi

SQL does not store data as an ordered set, there is no way to guarantee the order of an INSERT even using an ORDER BY

Sorry to hear that Anthony.

I think that's a good idea mate, have a break for a while, clear your head then give it another crack in a couple of months...

anthony.green (6/25/2012)

---

Congrats - somewhere good and with good prospects I hope.

Just been given the go ahead to rebook 70-450 for Thursday, think I will book an earlier one around 8...