select convert(char(20),getdate(),108)

I ran a particular option( by two users) from the application and this situation arised.

Thank you very much.

Can we use datediff?

Rajesh

I really appreciate all your valuable suggestions and comments, but I am keener on your comments on the following statements?  

 If an alias is not present, the engine must resolve which...

Try this, not sure this is what you wanted.

Select a.RowId, A.data,

 case

  when A.UserId <> 100 then 0

  else UserId

 end as UserId

 from (

Select a.RowId,A.Data,b.userId from TableA a

inner Join TableB...

Use LEFT JOIN

Rajesh

I am pretty much convinced that in order to avoid ambiguity, we should use alias names. Also if there is a self join, there in no way we could join...

Thanks very much for the reply.

It was my impression, but in Oracle, according to our Oracle DBA

• If an alias is not present, the engine...

Check this out.

select  cast( sum( cast( left(cast(Hours as varchar(10)) , patindex( '%.%', cast(Hours as varchar(10)))-1) as int) )+ sum( cast( right( cast(Hours as varchar(10)),2) as int))/60 as varchar(10))+ '.'...

not sure this could be another solution?

select  cast( sum( cast(left(cast(Hours as varchar(10)) , patindex( '%.%', cast(Hours as varchar(10)) )-1) as Int ) + cast(right(cast(Hours as varchar(10)) , 2) as Int...

Instead of view if the result set is stored in a # table,  isnull is working fine.

SELECT ID, 1  As Val into #temp2 FROM tb1 WHERE ID < 5

SELECT...

Thank you very much for your valuable reply , both peter and Kenneth.

Kenneth, I can't really agree with what you have said.

it's possible for two concurrent connections to...

Hi Dilip,

It is working perfetly fine and loads of thanks.

Cheers

Rajesh

Thanks Dilip,

It looks good. However let me give it a try.

Cheers

Rajesh

Hi Dilip,

Well, my knowledge in VB or .NET is very limited that is the reason why you could see this particular thread. I know I have to use ADODB.Command...