Any chance you have your compatibility mode set at 80 for the database you are using?

That's awesome, except that you posted it in the SQL Server 2005 section, regarding a question asked in July of 2009.

The thing, then, is to become indispensable, instead of irreplaceable.

As far as whatever you said about capitalism, I can't disagree...

Bob, I liked what you said and agree wholeheartedly.

I think that being insecure can help (as others have said) push you ahead. However, I know for a fact that dwelling...

How about correcting for the time zone? Maybe I'm not getting your question, but would something like this work:

SELECT dateadd(ss,(DATEDIFF(ss,GETDATE(),GETUTCDATE())),(DATEADD(n,261773,'2010-01-01 00:00:00')))

Well, I must be pretty bored...

Table Creation Script:

if object_id('tempdb..#tCMMembers')is not null drop table #tCMMembers

if object_id('tempdb..#tdwclaimTransactions')is not null drop table #tdwclaimTransactions

if object_id('tempdb..#tPlans')is not null drop table #tPlans

if object_id('tempdb..#tdwClaims')is not null drop...

Using Google: "tsql script to grant permission"

The first result is:

http://www.mukkapati.com/blog/post/T-SQL-Script-for-Grant(ing)-permissions-to-all-tables-in-a-database-to-a-user.aspx

I've made the edits for you down below. You just need to change "userid" to the person for whom you...

Alright, so with all the different ways of doing this, I decided to run some tests and see which way would be most beneficial.

I set out to try 1 million...

Tim, I had the same problem. I just removed all the offending whitespace and it works fine now:

---------------------------------------------------------------------

-- Create Table and Insert data

---------------------------------------------------------------------

if object_id('tempdb..TestTable')is not null drop table TestTable

Create Table...

I'm glad someone else came up with that. I was going in an entirely different direction. I ended up hooking this into a date table and was trying to pull...

Alright here goes.

The SSIS package starts by deleting the Active Directory table I created in SQL. That leads to a For Each container that uses a hand entered list as...

Found some stuff online regarding overlapping or intersecting dates. May want to check that out. I'm sure you've been looking around. Below is what I came up with trying to...

Probably will be. I'd be interested to find out how the performance testing goes.

Looks like it should work.

Giving it a try, it seems as if it will work just fine. Are you unable to try it out?

set nocount on

go

begin try

begin transaction

declare @counter int

declare @sql...