Can you elaborate a bit on how you intend to use the # of entries in a query? I don't quite follow you what 'entries' means in this case.

Most helpful...

Well, what do you want to do? You have several rows that will match for minimum date on both your Ref_no examples...

/Kenneth

There is - write a proc that suits each different database.

Better, more robust and much less prone to errors and maintenance and debugging problems (problems you will get if...

You don't have any 'datea' and 'dateb' - you have tarih and tarib

Which of them is start and end?

In your query below, explain in simple words your intentions with...

Agreed, there is something else in the works here.

A INSERT <table> SELECT ... FROM... does not return a resultset.

/Kenneth

If you don't have any app that can recieve the data (assume this is select statements?) you could redirect it  and insert into a temptable instead. Though, as Kory says -...

Can you provide a few sample rows of data with dates that you won't find with your query, but you expect the query to find them?

Could you also elaborate on...

I can't really see how.. Perhaps by looking for numbers? Though you'd have to scan the results by eye anyway, I'd imagine. I mean, if there's no rhyme or reason...

Well, first of all, let me just state that I'm not a math guy.

Precise in my mind could also be called 'predictable'. Floats...

You should also avoid the systemspids 1-7.

/Kenneth

If you're not allowed sysadminsrights, do you think that they would let you send emails out of their control?

Why don't you ask the serverowners for their suggestion about what you...

There is only one format that is unambigous and language independent - yyyymmdd (20051027) - convert displaystyle 112. If you use any other format you're at risk of either parsing errors...

decimal is precise, while float is approximate.

Using floats in the wrong place or for the wrong purpose will produce 'corrupted' data (in the...

You have to use EXEC('Kill ' + @spid) since 'KILL' won't accept a variable as parameter

Though note that if you have quick users, there's nothing preventing them to reconnect immediately...

I can't repro that - I get these results when running the proc in QA:

Hello

hi

--------

hi

(1 row(s) affected)

Profiler only shows you what the server sees - that is what...