Mike Feuti (3/11/2008)

---

This is what my select looks like on my test record:

Preferred name.email name_address email purpose

0...

you've...

suggestion: create the view in the required database and create a synonym for that view in the desired database.

the files you've identified are not sql server full text index catalogs.

you've posted this question in multiple forums on multiple sites. what indexing product (outside of sql...

the vs debugging package is safe but should be placed on development servers only. i'd personally keep them off test servers also (since i think test should mimic production...

by "auto-generate primary key", i assume you're referring to an identity column. if so, we typically add the identity column as the last column of the table, then create...

here's one solution:

select A.username, A.id

from your_table as A

join (select username, max(id) as max_id

from your_table group...

here's an old school alternative with another temp table:

select row_number() over (order by opid asc, ownerchg_date asc) as seq, *

into #op_hist

from #op_owner_history

select C.*, isnull(N.ownerchg_date,getdate()) as end_date

from #op_hist as C...

Cast rank_code as a varchar.

SELECT CASE RANK_CODE WHEN 1 THEN 'officer'

ELSE cast(RANK_CODE as varchar) END AS Rank_Code_Text

FROM tableA

Also, you should not redefine an existing column in the SELECT. ...

you appear to be creating "TransferLevel" in the CTE.

select ..., TransferLevel = 0 will name the output column "TransferLevel".

Does "TransferLevel" exist in dbo.CardActivationDetail or dbo.CardActivationDetail? If not, that's...

create trigger

on ms273512

after insert, update

begin

if ( update( {approval_field} ) )

begin

update rm00101

...

have you considered using reporting services? it supports all types of advanced/rich formatting.

Ian Crandell (3/3/2008)

---

ROLLUP is definitely on the right track to what I want, however it is not 100% there. Unless I am missing something, I don't see a way...

look for 'ROLLUP' in the sql server books and read the 'Summarize Data Using ROLLUP' topic.

the trigger can limit it's actions based on fields. you'd just have a

[font="Courier New"]create trigger trigger_name on table_name

after update as

begin

if update(column_name)

begin

...