Are you connecting to the same server and the same database? (it's caused me a red face from time to time before)

Is the query exactly the same, no additional clauses?

Are...

fyi, what you're trying to do does work in SQL 2005, with some minor mods. It's possible in 2005 to do the following

SELECT * FROM SomeTable S CROSS APPLY dbo.SomeFunction(S.aField)...

I'll second the suggestion 'go bash a developer across the head' (I'm a developer myself)

One thing I'd like to correct about your comments. The code inserting doesn't have to request...

No need for a having clause as far as I can see. Try this

SELECT

sales_person_id, COUNT(

I've done it for several exams. The amout of time per week is pretty dependent on how long you have before you plan to write the exam.

For my SQL...

If you have no better place to put it, then put it there.

Also note that the potential of hot spot has to be weighed against the probability of page...

With large volumes, a cluster on an increasing column can create an insert hotspot, but the volumn really needs to be excessive (1000s of inserts/sec)

It's actually quite a good idea...

Is it possible that there's an insert into the transaction table from somewhere else, with identity_insert switched on?

It almost sounds like someone's inserting the 'next' transaction and manually assigning...

Yes.

Install 2005 and when you get to the screen to select what you want installed, just install the workstation components. Unselect the database engine and all the other stuff.

Unrelated to your question, but something you should know.

Inner Join PWIN171.dbo.FE AS FERaised

           On LTrim(RTrim(Cast(tblHeaders.fldRaisedBy as char))) = LTrim(RTrim(FERaised.FE_CODE))

With the functions around the fields in the...

I've noticed 'problems' with the auto stats with large tables (+20 million rows) with clustered indexes on an increasing field.

I had a table a while back with DateAdded as...

If the record violates the pk constraint, any of the fk constraints or any of the check constraints, it won't be inserted and the trigger, if any, won't fire.

If the...

Doesn't looks too hard. One clarification please. Why didn't

appear in the thrid table?

What are...

Can you give the structure of the 2nd and 3rd tables, an example of input data and an example of your desired output please.

There's almost certainly a set-based solution for...

One minor correction

CREATE

Procedure select_Proc1

@Key3 varchar(10) = NULL

....

If you don't...