Does this stored proc really give the occurence of a value in the database or the occurence of a attribute/field name in the database ?

I have a value and I...

declare @time int

set @time = 70

select cast((@time / 60) as varchar(2)) + ':' + cast((@time % 60) as varchar(2))

Here's a way..

create table names1(id int not null identity(1,1),empname varchar(10))

create table names2(id int not null identity(1,1),empname varchar(10))

create table names3(id int not null identity(1,1),empname varchar(10))

--Insert values...

select coalesce((select empname from names1 where...

UPDATE #tblTesting

SET TestStr = CASE

WHEN...

A nice and simple way 🙂

Here's another way I used to use:

select dateadd(day,-1,dateadd(month,1,str(year(getdate()),4)+'-'+str(month(getdate()),2)+'-01'))

However, I created another proc for this particular query and am...

Is MERGE supported in Sql Server 2005?

Can I use dynamic sqls. Will there be a performance difference if I have more dynamic sqls in my stored proc?

Gail, Noel - Thanks for all the suggestions.

Today morning I dropped the procedure with this query and recreated it without making any change. It ran very fast. I ran it...

Another option would be to use:

last_update > cast(convert(char(10),getdate()-1,101) as datetime)

and

last_update < cast(convert(char(10),getdate(),101) as datetime)

I'm not sure about the performance difference in these 2 methods

GilaMonster (2/9/2009)

---

Parameter sniffing, or more accurately the lack of parameter sniffing. SQL doesn't know the values of the variables at compile time and hence guesses the rows affected. If it...

Thanks Lynn. I won't be able to post the execution plan, I am not allowed to post official work in public forums. Hope u understand.

Could u hint something for...

Thanks. I wanted to confirm if CASE can be used for such a thing. It would make things easier 🙂

:D:D Good one!!

Thanks for all the clarifications..

Thanks Gail..

Is there any difference between joining in these 2 ways?

select ...

from table t1

...