Struggling to write a Iif or Switch statement in the expression for the following:

If the cell value is "Y" then nothing

If TODAY() is 10 day or less prior to SV3...

You need CHARINDEX() to find the position of the second dash (if it exists).

This almost works:

use tempdb;

go

SELECT OrderNo

, CHARINDEX('-',OrderNo,4) AS FindDash

, LEFT(OrderNo,CHARINDEX('-',OrderNo,4)) AS NoSuffix

FROM (

SELECT 'SO-123456' AS OrderNo

UNION ALL

SELECT 'SO-123456-01'

UNION...

If you can avoid using UNION, I probably would. (Maybe SQL Server acts different than it's stepbrother Access, where union query performance was appalling, but I don't know.)

Are you querying...

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