hi Lowell,

I'm curious why you need the +1 in the query

use msdb;

GO

DBCC CHECKIDENT ('dbo.backupset')

SELECT MAX(backup_set_id) + 1 FROM dbo.backupset

if the current identity is less than the max row in...

Not sure. Has the agent account password changed recently? Has disk space on the distributor filled up? Is the transaction log full on the distributor database?

For the current month ...

WITH MYCTE AS (

SELECT row_number() over (order by [dates] DESC ) as dayNum, [dates], datename(weekday, dates) as [Day Name]

FROM

( /* the last seven days in...

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