you're not doing a join here.

Also, what do you mean by exclude some dates? Is there a reason you don't have these marked in your calendar table?

Follow Jim's advice, but as a few hints.

1. write a SELECT that calculates the data first. You can do this for all rows, joining with your table of days. Once...

You can modify Jonathan's script to check for logins that have a used in a specified database, or just make sure you manually add those logins. There isn't a way...

GilaMonster (6/25/2011)

---

Jim Murphy (6/24/2011)

---

Awesome. Some day, I'll enjoy it. You will blog about your experience...

ark.trofman (6/24/2011)

---

I understand that you need to have certain rules and make them available for the folks who want to publish here. Also I understand that the basic rules of...

Tom.Thomson (5/18/2010)

---

Nice guidelines up to a point. There something rather bizarre though: the claim that "following" is not a noun and therefor can't begin a sentence is pure nonsense....

I posted a note and Jonathan Kehayias wrote this: http://www.sqlskills.com/blogs/jonathan/post/Creating-a-new-Login-on-Multiple-Servers-with-the-same-SID-using-Powershell.aspx

I'd open a case with Microsoft. I've never heard of anything remotely like this with SQL Server that wasn't some programming mistake.

True, you could need to match up SIDs with SQL logins.

Likely PowerShell could somehow run the script, take the ouput and pipe that in as a new batch for a...

Doh!

Yep, Datediff needs a type and then the arguments: http://msdn.microsoft.com/en-us/library/ms189794.aspx

The CASE is here: http://msdn.microsoft.com/en-us/library/ms181765.aspx

basically you can use it in the SELECT or the WHERE clauses as

CASE WHEN xx then...

I'd completely agree with Gail. Weekly isn't granular enough. I'd go with a better trace or logging.

Note that this is a manual process. If you add logins to the primary, it should be with a script, and you should amend the script to also add the...

Never seen anything like this. Unless you perhaps had implicit transactions off. Perhaps one started and didn't commit?

The SELECT should return the rows, however, if it's the same connection.

I would...

That is strange. I might set up a trace that logs activity to see what is happening here.

There is no IF() function in T-SQL. You're mixing something from another language in there.

SELECT

room_type,rate_start_date,rate_end_date,rate

, DATEDIFF( case when rate_end_date > '2011-04-16'

...