A view is a Virtual Table, so what I am saying os that my view IS your second table.

Can't you do it with Maintenance Plans?

tosscrosby (4/1/2008)

---

I'm trying to determine when the next date a person would be eligible for taking leave. They person can only utilize 480 hours for the past calendar year. So...

You can do it with a View pretty easily:

Create View vwTable1 AS

Select USER_ID, VAL_1 - VAL_4 AS [Total]

From Table1

And it's always up-to-date.

Yes, it is possible with a CTE (assuming you mean code references).

Maybe I'm missing something here: How many Subscribers per Publication do you have?

Why not both? I...

This works:

Select Replace(Convert(varchar(22), DateAdd(d, -1, DateAdd(m, 1, getdate())), 102), '.', '')

Maurizio79 (4/1/2008)

---

Sorry, maybe i didn't use adeguate words.

I want to use more distribution server, that is what i consider "scale out".

But there is that possibility in sql2k5? That is, can...

Yes, but if you look at it, you will see that the file name is a variable: [font="System"]@file[/font]. You can write SQL procedure code to change it as needed.

Maurizio79 (4/1/2008)

---

Thanks for the reply, rbarryyoung.

Yes, we use republishing on the same distribution machine, that is: the online database exposes a publication, and the subscriber is the distribution database. then...

Fact and Dimension are terms from Data Warehousing where Dimensional Modeling of data is used instead of Relational Modeling. It's still understandable to SQL DBA's and even do-able in...

Hmm, upon further review, I don't think that my first reply actually answered you question. Part of the problem for me is that [font="Courier New"]@FromTvsFormNo[/font] and [font="Courier New"]@ToTvsFormNo[/font] ...

SQLZ (4/1/2008)

---

Say I want to run an ALTER INDEX ALL ON table_name REORGANIZE; command on all tables that are more than 10% fragmented.

I know I can use sys.dm_db_index_physical_stats to get...

Here's one way:

CREATE PROCEDURE [dbo].[SearchSP] ...