Yes, option 4 is a joke.

This is an uncommittable transaction, you can see outlined in the linked BOL on TRY CATCH with Transactions. I ran into the issue because...

John Mitchell-245523 (3/1/2012)

---

Not sure I've understood correctly here, but if I have then you're a sysadmin on the instance - I assume you are since you need that, or something...

sabercats (2/29/2012)

---

Here are my full query and it did not get what i want

/****** Script for SelectTopNRows command from SSMS ******/

declare @dow int

declare @2SundaysAgo datetime

declare @lastSaturday datetime

select @dow =...

mckennap (2/23/2012)

---

Is it possible to add column(s) to a temp table using a local variable to determine the column name? Here's what I'm attempting but instead of substituting the value...

Ray_NA (2/22/2012)

---

The simple version of my problem is with two tables.

I have two different tables. one is a header and one is details . I need the rows to...

tarr94 (2/22/2012)

---

Brandie,

Can you explain what you mean by this?

Also, why can't you just insert a placeholder row for every day and just update the times when employees actually clock in?...

EdwinGene (2/21/2012)

---

Gail,

Thank you for your suggestions. Your suggestion about sargable predicates has helped me to find an alternate way to invoke the query to get SQL Server to use...

additionally the number of rows in the table can determine if an index gets skipped. Without reproducible code to work with, it's like calling your mechanic and saying "My...

James,

At the risk of sounding snotty, you handicapped Case 2 intentionally to remove it from consideration. Neither of the other cases will return the same RESULTS as case 2...

Use the Split function outlined in this article:

http://www.sqlservercentral.com/articles/72993/

Well, I found the issue. Turns out that the client had disabled the reporting tables and was running reports directly from the live data... Because each of the queries...

Thank you both for your responses. I'm investigating our last update to see if any of those SP's/views are implicated. I've run a trace, but nothing appears out...

Someone above said that overloading the "=" sign to do the alias would be even more confusing... I'd argue that it's not, it's a reuse of the Assignment, but...

The answer is "It Depends".

Several factors will influence:

1. Data Load

- Are you sure the data load between 2000 and 2008 R2 is the same? a variance of...

a Google whack (as originally defined) is to enter 2 words into Google and get exactly 1 link in response. Since Google then cached the Google Whacks, as soon...