( didn't notice it the extra pages of posts )

assuming the begin and end fields are datetimes....

select Client_Rep, datediff(mi, s, e) minsInWork, d...

Rajesh

What problem are you having?

I would say that if there's a lot of data, using a character id field isn't generally recommended since it will be a fair bit slower than...

It sounds like you need to index one (or both) of the temp tables so that joining can work efficiently.  Difficult to say without seeing the whole thing though - you...

have a look at "convert" in BOL

you can use:

select convert(char(10), effective_date, 103)

to convert the date to a gb date string

however, if you're going to put it in an xml doc...

brains a bit sluggish this morning, but can't you just do a:

select count(*)

from (

        .... first query

       ) t

use the iso standard: yyyy-mm-dd

e.g.  2004-06-15

might be worth mentioning that we've seen the error message '3704 operation is not allowed when the object is closed.' before raised in ADO, when a different error was actually occurring...

Is this what you want? 

declare @source_ptr binary(16), @target_ptr binary(16), @id1 int, @id2 int

select

@source_ptr = textptr(col1) from tbl1...

cheers - thought there must be a reason for it

jt

Off the path I know, but just curious because I've seen sql written like this before and was wondering why you'd want to write:

Select count(DocID) as...

Noticed that a single £ or $ evaluate to true aswell - guess they're classified as valid money types, and also a period, so there might be some others.  Maybe...

simplest is:

  SELECT   UniqueID

  FROM     Table

  WHERE   CONTAINS(*,@Criteria)

where @Criteria would be something like

'FORMSOF(INFLECTIONAL,"test") AND FORMSOF(INFLECTIONAL,"criteria")'

or just 'test'

if you modify and run the following script against your db (just need to edit the table fti...

You need the full-stop, so ".doc", ".html" etc. in the doc type column.

Might be silly, but have you started the catalogue population off?  ie. Started off full pop, turned on...

I think it's up to the db optimiser to decide how to execute a query - so I don't think it would make a difference whether you write

select *

from A

join...

you could order by crdate if the views were created in the correct order (ie. dependents after the views they depend upon)

is there a word for something that something else...