Perhaps the OP simply forgot to include the other cases in the where clause

ChrisM , If I can borrow your code...

Use ProdDB

SELECT TOP (100) PERCENT

[Prod No] = p.ProdNo,

[Prod...

Just want to mention that I have an old fashioned way of dealing with no data. Be mindful that your report viewers may want to see items that 0 counts,...

SSIS is a great tool.Once you connect to your data source within a dataflow task you can create a derived column. Here there are built in string and other operators...

For your third question >

http://msdn.microsoft.com/en-us/library/ms130214(SQL.105).aspx

Don't forget about Books online as this continues to be a valuable resource. Since you have a background things will come back, learning the new...

I know this is a SQL forum, but for crazy Excel imports, I've found creating macros in VBA to be very helpful. One can move the data to a new...

Will this work if the next time you get "This is effective as of May 5, 2014" ? - just giving a heads up in case you are using a...

In SSIS 2008, you can right click the Project (top node) in the VS solution explorer. From there go to Properties , Debugging , Run64BitRuntime... set this property to false....

Fantastic solution Lowell, I reckon you meant

WHERE Datediff(dd, T1.discharge_date, T2.admit_date) < 30

?

Good Point, thanks.

You don't necessarily need to use a join, try the WHERE EXISTS clause. Look it up on MSDN.

I've come across somewhere that using BETWEEN is slower that actually using the less than/greater than operator. I have not done any testing on it. Any quick feedback on...

It would be good to investigate how the tables are joined, are the indexes appropriate, is it fast when you call it from ssms? As mentioned by others taking the...

The query is going to return a result to the screen from your select and the insert two columns into your non temp table. If you want to automate email...

A typical update using a IF could look like

IF (month(getdate())=4)

begin

update t1

set t1.columnA=t2.columnA

from table1 as t1 inner join table2...

Were you disabling your indexes when employing SSIS? Or only when using t-sql?