You can't do things like "WHERE txtField LIKE '%Smith%'" with a text column, for instance.

That's not true, you can use LIKE and IS NULL on a text column, you can't use any...

It's the winter solstice and shortest day down here. Sunrise was about half past 6 this morning and sunset will be around quarter to six this evening. (about, I'm not...

You don't need the brackets around the select. Also the Order By is not necessary in an insert. The concept of order of rows in a table is meaningless. Order the...

Isaac Asimov's robot stories, especially The Positronic Man (with Robert Silverberg). The book I, Robot is a collection of short stories

Also Arthur C Clark's Rama series and Songs...

Do you have an identity column, a time stamp column or a column that shows date entered (default getdate())? If not, there's no way to get the latest 3 rows....

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...