Jack,

I tried creating an Alert, but it doesn't seem to fire. Is there something else that needs to be done that I may be missing? I was sure...

Well, that last bit of info may be a bit old, but it was valid at my last employer. The reports were run on an automated schedule then dumped...

I also think it depends on the type of reports created as well. If the reports used by users are static, you may not need to count those users....

WILLIAM MITCHELL (4/2/2008)

---

A rule of thumb when writing your resume is to include only the last 10 years of work experience. I would expect that a degree that is more...

I'm not with Microsoft eithr, but based on my multiple readings of the licensing for SQL Server 2005, if you install Reporting Services on another server (other than the one...

The "create" in my...

Use this as a basis for writing your update query:

create table #MyTable(

RowId int,

RowDataCol1 char(10)

)

go

insert into #MyTable (RowId, RowDataCol1)

select 1, 'Data 1' union

select...

How are new rows added to the table, and when do they get numbered?

If you could provide the DDL for the tables (at least the key fields plus any non key fields used in the joins), some sample data (based on the DDL...

Sql Student (4/1/2008)

---

I got 2 tables where there are matching records.

But i need to pull out data from table 2 that is not present in table 1 along with the...

Are the row numbers the only way to identify the rows? Does the table have any other means to identify the order the data was entered?

SAMPLE DATA, TABLE DDL,...

If DC means Domain Controllers, my advice is to get the databases of them and onto their own dedicated server(s).

😎

Okay, I guess we are missing the point, so show us. Please provide the DDL for the table, sample data (in the form of an insert statement with union...

I have to agree with Grant and Steve. In our DW project, I have seperated the system tables ([PRIMARY]) from the data [DATA], default), non-clustered indexes ([Indexes]), and indexed...

Are you renumbering the rows after every insert, or are you looking for a means to update the row_number field as records are inserted? Can more than one row...