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.

Click on Control Panel. Scroll down to options, click on Forum Settings. Scroll down and you will find where you can change the number of posts per page....

That...

Now, if you really want help, we need the DDL for the underlying tables and sample data as well. You should be able to follow the instruction in the...

Three and four part naming conventions have been depreciated in SELECT lists. You really need to start using table aliases and two part naming conventions like this:

create view dbo.AB_CUST_ORDER_ACK...