Title of the thread: what is net change method

As this looks like a performance issue, please read the second article I have referenced in my signature block. Following the instruction in that article will get you the...

Don't think my wife would approve. 😉

Sample code.

create table dbo.MyTestTable (

MyTestTableID int identity(1,1),

MyDate datetime default(dateadd(dd,datediff(dd,0,getdate()) - 1, 0)),

ADataValue int

)

;

insert into dbo.MyTestTable(ADataValue)

select 1

;

select

...

On my dev system master.sys.all_parameters returns 6776 rows. In the context of the particular database I tested it, sys.all_parameters, returned 6841.

SQL Server 2005 Enterprise Edition will not run on XP Pro. What you need on XP Pro is the Developers Edition. Same functionality as EE but costs about...

Show me...

I'd have to see the code for the insert as well as the DDL for the table. I have an idea, but it is better to see this first.

And that is why I designed my Dynamic Tally Table as an In-line TVF versus the multi-statement TVF in Frank Solomons' article in SQL Server Magazine.

Here is another option:

create table dbo.MyTestTable (

SearchResultID int primary key,

ContentID int,

RankVal int

)

insert into dbo.MyTestTable

select 1,2134,22 union all

select 2,2134,108...

Yesterday at midnight:

select dateadd(dd, datediff(dd, 0, getdate()) - 1, 0)

Here is my code with a slight change to hopefully account for Previous Day.

SELECT

'OPEN' as [AREA_DESCRIPTION]

,'OPEN' as...

If you would like some helpful help give us what we have asked for. Read the first article I reference in my signature block. Follow the instructions in...

Ten thousand posts isn't that far off actually. All it takes is one hot topic to bring out a lot of posts.

I guess we've been busy. I know I am. Between work, soccer, trying to research an article for SQL Server Standard, and life in general, not much time.