Viewing 15 posts - 181 through 195 (of 402 total)
Hi
Have you considered putting an option in your drop down for "Show None" and toggle your visibility based on that?
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 6, 2012 at 5:20 am
Deleted as misunderstood requirements
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 6, 2012 at 3:43 am
-- 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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 5, 2012 at 9:31 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 29, 2012 at 3:28 am
No worries, got there in the end 😉
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 10:36 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 9:42 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 9:17 am
(unless you add a vertical TOTAL column)
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 8:44 am
No probs 🙂
The OR operator is a dangerous beast, and you also had your <= >=evaluations the wrong way round 😉
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 8:39 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 8:11 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 7:52 am
Rob to help alleviate some of that headache in the future, grab the SSIS addin here:
+1
That has saved me more than once!
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 7:38 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 4:40 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 28, 2012 at 4:01 am
anthony.green (6/25/2012)
Just been given the go ahead to rebook 70-450 for Thursday, think I will book an earlier one around 8...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
June 25, 2012 at 8:26 am
Viewing 15 posts - 181 through 195 (of 402 total)