What options did you choose when you installed SSRS? "Install but do not configure"? If you did a default install, the install script should have created a ReportServer database....

How about...

SELECT ClientID

--,MAX(ServiceDate) AS LastSvcDate

FROM #Services

GROUP BY ClientID

HAVING MAX(ServiceDate)<DATEADD(d,-80,GETDATE());

Then just join that back to the Client table to get the client info...

Either mail merge to Word and create mailing labels or create a report in SSRS and do the same thing.

Getting warmer, but it seems you should read this before posting:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

I'm not trying to be difficult, but it's really hard to recreate something like your situation without it. Could...

if the date in 'field B' is less then TODAY() then format the 'field B' as Background Color Red and Font color White,

if the date in 'field B' is equal...

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