Hi,

try this

declare @i varchar(1000)

select @i = YEAR(getdate())

select CAST(@i AS bigint),@i

Hi,

create the table T2 with the totalpay column as int,

then create trigger

t.hitendra (7/24/2009)

---

Hi

Guy needs total=rate*hours.

Above answer would simply...

Hi,

use the compute column in the table like

create...

Hi,

update #temp

set TOTALAVR = ((isnull(AVR1,0)+isnull(AVR2,0)+isnull(AVR3,0))

/(case when (AVR1 is null)or

(AVR2 is null)or

(AVR3 is null) then 2

when (AVR1 is null and AVR2 is null)or

(AVR1 is null and AVR3 is null)or

(AVR2 is null...

Hi,

update #temp

set TOTALAVR = ((isnull(AVR1,0)+isnull(AVR2,0)+isnull(AVR3,0))/3)

Hi,

try with this

create table #temp

(

slno int,

name1 varchar(10),

AVR1 int,

AVR2 int,

AVR3 int

)

insert into #temp

select 1,'ABCD',5,15,25

union all

select 2,'BCDE',10,20,30

union all

select 2,'CDEF',20,30,40

alter table #temp add TOTALAVR int

update #temp

set TOTALAVR = ((AVR1+AVR2+AVR3)/3)

Mia G (7/21/2009)

---

select acctNum as acno into #inactiveAccts

from acctMainTbl

where acctNum not in (select acctNum from deceasedAcctTbl)

and acctNum not in (select acctNum from oneYrActList)

update activeField

set activeField = (case when acctNum is...

Hi,

ref link: http://www.sqlservercentral.com/Forums/Topic755240-145-1.aspx

Hi,

try this

01)

select col1,col2,sum(col1+col2) as col3, (sum(col1+col2)/2)as Col4

from MYTABLE

group by col1,col2

02)

select *,(col3/2)as col4 from

(

select col1,col2,sum(col1+col2) as col3

from MYTABLE

group by col1,col2

) AS X

satishp.mst (7/17/2009)

---

What I want is to store date and time, but time should always default to zero.

For e.g. 17/07/2009 00:00:00

quote]

Hi,

only option you must convert the datetime and insert it ...

The where condition not validate two different numbers even the string like @a = 'N,R'

so try this

declare @a varchar(20)

set @a='ABCD'

select @a

select substring('ABCD',number,1) from

/*Your Number table (or)*/

(select 1 number union...

Hi,

In that scenario, my small suggestion is use the status of...

Hi,

ref link: http://www.sqlservercentral.com/Forums/Topic697814-169-1.aspx#bm698331

ARUN SAS

Mansfield (7/16/2009)

---

Since you have done the pivot the hard way, here's the equivalent to unpivot...

insert into Customer (customerName, product, qty)

select customer, 'Chair', ChairQty from Target

union select customer, 'Table', TableQty...