Here's a complete example for you...

you simply change whatever application is looking at "my_table" to report the current status to point to "ViewOfMyTable"...all done...no process needing to run every thirty...

well...you can have a calculated column as a primary key...so i'd make it built off of an identity like this:

[font="Courier New"]CREATE TABLE #example(myid INT IDENTITY(1,1),

myCalculatedPK AS 'martmp_' + RIGHT('00000000' +...

select

ALIAS1.naam,

ALIAS1.Aantal_Incidenten,

ALIAS2.naam,

ALIAS2.Aantal_Inc_Portal

FROM

(

select vestiging.naam, count(*) as Aantal_Incidenten

from incident, vestiging

where incident.aanmeldervestigingid = vestiging.unid

group by vestiging.naam

) ALIAS1,

(

select vestiging.naam, count(*) as Aantal_Inc_Portal

from incident,...

another way to do it wiht a CASE statement, if you need to do lots of different race codes:

SELECT

SUM(CASE WHEN race_code = '01' THEN 1 ELSE 0...

it's suprisinglyy easy... you just need to use the two tables as aliased subselects:

SELECT ALIAS1.AM,ALIAS2.CM

FROM

(SELECT COUNT(*) AS AM

FROM dwh_test.dim_employees

WHERE

...

the trick for # of recurring substrings in a string is to use the replace function:

declare @MySchedule varchar(168)

SET @MySchedule = REPLICATE('123456789',40) --overkill

select @MySchedule

/*results:

123456789123456789123456789123456789123456789

123456789123456789123456789123456789123456789

123456789123456789123456789123456789123456789

123456789123456789123456789123456

*/

--how many times is there a 9 in...

again, I call BS.

what possible business process needs to scan the table every 30 seconds? how often is the table queried against per second? you've explained just fine what you...

When it comes to beating a dead horse with management, I've been there as well....sometimes they don't want to listen.

What is the real issue by the way? cursors? we might...

steveb's suggestion is the best, bar none. copy database wizard is not reliable compared to the built in ability of a SQL 2005 server to update an existing 2000 MDF...

for a trigger to be handled correctly, you cannot declare variables....

you have to keep everything SET based.

once you declare a variable, you are telling me you are thinking of one...

you can do it in 8000 char bites. the NULL parameter in your original statement below is WHERE to insert more text in the text field, and thenext parameter...

a table scan isn't necessarily evil....is the select very slow or anything?

how many rows are in the temp table?

what is the CREATE TABLE statement for the table?

is there...

you can't put a select statement there, only a string. you cannot select all columns in a table as a string...you'd have to build a string and use that.

you'll need...

from what i read, you cannot create a clustered index on CE other thant eh PK of the table'http://www.developmentnow.com/g/97_2005_2_0_0_384968/Clustered-Indexes.htm

also, CE can only use one index at any time, but i...

also stating the obvious...maybe in one database, the field is not null, and the database that doesn't show the value it is null...did you query both dbs to check the...