My first interactions with Access were all negative. My first DBA job I fell into on accident. It was such a pain we had users with linked tables...

SELECT

oh.*, o.UnitPrice

FROM Sales.SalesOrderHeader oh

OUTER APPLY (Select top 1 od.unitPrice from Sales.SalesOrderDetail od where od.SalesOrderID=oh.SalesOrderID order by od.unitPrice) as o

I did not test this, but believe that it...

This was my first article. Hopefully not...

Skip maintenance plans for index rebuilds. Use this http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html.

First you don't need the quotes for your in, because year returns data type of int. (http://msdn.microsoft.com/en-us/library/ms186313.aspx) Using functions is not recommended in the where clause you...

Some people are just motivated to do a good job and others need motivation. An interesting article was on MSN kind of related to this, but in the opposite...

I have been attending user groups on and off for years... Where is the beer?

SELECT *

FROM appt_exch where appointment_sk in

(select top (1) appointment_sk FROM appointments where appoint_type_sk=

(SELECT ITEM_SK FROM GROUP_ITEMS WHERE GROUP_CODE = 'APPTTY' AND DESCRIPTION = 'TRIAL')

and begin_time between '01/01/2014' and '05/31/2014'

ORDER BY...

Maybe I missed the boat, but is there a reason you aren't using a simple charindex?

select charindex(' ', field) returns where the first space is located, you can use that...

You could dump results into 2 temp tables and then use Except...

If you are querying from different servers you can output the result set to file and then use notepad++, this is something I have done for text file comparison in...

The pictures just made my otherwise crappy Friday. Thanks!

The joke is that you are always promoted one level beyond your competency. I have had some great managers, some awful managers and some in-between. Bad managers are...

Try this...

SELECTpd.year,

pd.period,

pd.startdate,

df.projectnumber,

df.startdate_contract,

df.enddate_contract,

MONTH(df.startdate_contract) AS month

FROMperdat pd (NOLOCK)

LEFT OUTER JOIN ProjectDateFields df (NOLOCK) ON df.startdate_contract BETWEEN pd.startdate AND pd.enddate

and df.projectnumber = 'CR1003753'

As soon as you added df to where clause it became an inner join.