Yes, the name is _WA_Sys_PERSON_ID_1A69E950. Do you know what that is?

Why not simply

select * from JobLines where StartDate >= @StartDate

and then let the client display it on the above form?

Instead of

Where SubString(A.strSurname,1,1) = @strFirstLetter

I think I would write something like

Where

(SubString(A.strSurname,1,1) = @strFirstLetter and @SearchCol = 'SurName')

or

(SubString(A.strFirstname,1,1) = @strFirstLetter and @SearchCol = 'FirstName')

A similar change can be applied in the...

Eunice, I cannot see how you create the display data from your testdata. Could you explain further?

I haven't tested it, but I think something like the following might work:

SELECT    

dbo.Erika_test_claim_billed.childid,

dbo.Erika_test_claim_billed.parentid,

dbo.Erika_test_claim_billed.checkdate,

dbo.Erika_test_claim_billed.docid,

sum(case when dbo.Erika_test_adjustments.seq = 1 then dbo.Erika_test_claim_billed.billamt else 0 end)

FROM

dbo.Erika_test_adjustments RIGHT OUTER JOIN

dbo.Erika_test_claim_billed ON...

I can only see that it is working . Could you post an example where it is not working?

How do you compare the...

No problem, I enjoyed solving it...

select s1.ip, s1.datet, min(s2.datet), cast(datediff(mi, s1.datet, min(s2.datet)) as varchar) + ' mins'

from statisticss s1 inner join statisticss s2

on s1.ip = s2.ip

where

s1.error = 1 and s2.error = 1 and s1.datet <...

I think you have some errors in your data - '2005-07-21' should probably be '2005-07-20'. Anyway, I have put together a query that might give you what you want. It...

I think you are right - global tempo tables shouldn't be used for this purpose

To answer your second question, I don't know

I cannot see my own post, so here we go again

You are right, ##MyTable works. Learned a new trick

You are right, ##MyTable works. Learned a new trick

Is it necessary to create a temp table and insert data into it? Why not...

I guess Jamie means building an SQL statement in a string and then executing it, like the following:

declare @STR varchar(100)

set @STR = 'select * from sysobjects'

exec(@str)

But...

Stupid question back

Do you have a linked server connection between the servers?

Are you building a string and then executing it with exec()? I would insert this string into a logtable before executing it. But this is probably not what you are...