remove all the (nolock) hints.

Good thing, because I was just starting to think about it and try to figure out a solution (Good learning exercise, but if you have actual work to do, not...

Probably the easiest way would be to use a query of one of the system tables and see if you can match that way...

use MyDb;

go

DECLARE @TableName VARCHAR(25);

SET @TableName = 'Hospital';

Select...

Is this close? Note, as Craig mentioned, you need a Tally table to do this.

Here's his code for creating one:

http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/

use TEMPDB;

go

DROP TABLE #Parts;

GO

CREATE TABLE #Parts (

RecKey INT,

Part CHAR(2),

LT INT,

StartDate...

Yes, But SQL Saturday was last month...

Yep, makes it MUCH easier to see what you were doing wrong. Way to go, young Jedi.

You could do it inside a stored procedure, and then grant the right to execute said stored procedure to whoever you wanted. You could add EXECUTE AS <user> inside...

The problem is that you left out the other INNER JOIN statements:

...

FROM

vt_animals as A

INNER JOIN

vt_exam_headers as EH...

You might want to see if you can find the last version of Access Developer's Handbook, Enterprise Edition The first volume is Desktop, and you don't want that, I...

Something like....

DECLARE @TextString VARCHAR(100) = 'ACCOUNTANTS:- Signal Chartered Accountants @@ Individual:Mark John-Wilkinson';

DECLARE @StartPos INT,

@EndPos INT;

SELECT @EndPos = CHARINDEX('@@',@TextString);

SELECT @StartPos = CHARINDEX(':-',@TextString)+2;

PRINT @StartPos;

PRINT @EndPos;

SELECT RTRIM(LTRIM(SUBSTRING(@TextString,@StartPos,@EndPos-@StartPos)));

Returns:Signal Chartered Accountants

You should be able...

This is a double-post... here's the original

Wouldn't OR'ing the two filters together do it?

SELECT i.Configurtation_Item, COUNT(i.ID) AS CountID, I.Sub_Category

FROM ConfigIssues AS i

WHERE Configuration_Item LIKE '%outlook%' AND (Sub_Category LIKE '%Emails %' OR Sub_Category LIKE '%Managers %')

GROUP BY...

Wouldn't OR'ing the two filters together do it?

SELECT i.Configurtation_Item, COUNT(i.ID) AS CountID, I.Sub_Category

FROM ConfigIssues AS i

WHERE Configuration_Item LIKE '%outlook%' AND (Sub_Category LIKE '%Emails %' OR Sub_Category LIKE '%Managers %')

GROUP BY...

sure enough... must be getting old... forgot that my Tally table is indexed, so that caused me to overlook it.

Definitely need an ORDER BY clause! TOP VALUES without an...

Here's an example... I'm just creating a bunch of dates from a table of numbers.

SELECT TOP 1 SomeDate, N

FROM

(SELECT DATEADD(dd,n,'1-1-2010') AS SomeDate, n

FROM dbo.Tally) x

WHERE SomeDate<=GETDATE();

What you want is...