Are you using AdventureWorks as your model? Or if not, please post T-SQL to create tables and add some sample data and expected results. Apologies if I'm slow,...

join to a table-valued function using CROSS APPLY?

Sounds like you're doing what i used to do - summarizing unnormalized healthcare/oncology data. If you can either normalize your underlying tables or create a stored procedure or view...

Google is your friend.

If you're looking for something like interview answers, an interview like that will eat you alive unless you know the stuff cold. Any DBA worth his...

SELECTDate_Month

, LEFT(Date_Month,3) AS Mo3

, CAST(RIGHT(Date_Month,4) AS INT) AS Yr

, CAST(LEFT(Date_Month,3) + ' 1, ' + RIGHT(Date_Month,4) AS DATE) AS DateFun

FROM (

SELECT 'APR 2012' AS Date_Month

UNION ALL

SELECT 'JAN 2012'

UNION...

Two options:

Create another query based on the summary query and the original table. include the column from the original table that you couldn't use in the summary query.

Or

Build...

Maybe something like this?

SELECT fileName

, RecID

, page_follow

, rn

, PrevID

, RecID-PrevID AS GapSize

FROM

(SELECT [file_name] AS fileName

, [id] AS RecID

, page_follow

, ROW_NUMBER() OVER (ORDER BY [id]) AS rn

, MAX([id]) OVER (PARTITION BY...

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...