Thank you Jeff Moden

CustomerID ContactPerson CompanyPhone Home Phone Mobile Fax DefaultFlg

1 Richard 1876-926-0905 1876 946 0444 495 6764/8827471 1876-929-1485 1

1 Richard NULL NULL NULL 1876-882-7471 0

1 Richard NULL NULL NULL 1876-960 3882 0

From...

create table #temp (ranks int identity ,s_id int,s_name varchar(20),marks numeric(9,0))

Insert into #temp select * from student order by marks desc

select * from #temp

drop table...

select *,ROW_NUMBER() OVER (ORDER BY marks desc)ranks from student

Regards

Guru

hi ,

this may be correct or not i dont know any way try this

select URL1.*,URL23.URL2,URL23.URL3 from(select history.Contact,history,URL1.URL1 from(select Contact ,history from my_test where history is not...

hi iam777here4u,

I think you can create where condition from UI (.net code). If Modifier values are not null.

Suppose Modifier1 and Modifier2 has values and Modifier3 is null you...

DECLARE @N float

DECLARE @a Float

set @N=(SELECT CONVERT(numeric,(493-1)) / 493 *100)

PRINT @N

PRINT cast(@N as numeric(18,2))

--Result

--99.7971

--Expected Result

--99.80

SET @a=(select CONVERT(numeric,(24625- 1 ))/24625 *100)

PRINT @a

PRINT cast(@a as numeric(18,2))

PRINT...

create table QMaster (dates date,cnt int,Empcode int)

Insert into QMaster values('2/4/2011', 1 ,104),('2/4/2011', 1, 105),('2/4/2011', 1 ,104),('2/6/2011',1, 105),('2/6/2011' ,1, 106),

('2/8/2011', 1 ,107),('2/9/2011', 1, 108),('2/10/2011', 1, 109),('2/11/2011', 1, 110),('2/11/2011', 1, 111),('2/24/2011', 1...

For email and age i think you can add constrain

Hi,

Another way for adding created date when insert you can use default value.. Instead of passing arg/creating trigger

Regards

Guru

Insert Trigger

ALTER TRIGGER [Inventory].[purchase_order_detail_FillUser]

ON [Inventory].[purchase_order_detail] AFTER INSERT

AS

SET NOCOUNT ON;

Declare @TransDetail_Id Int

Select @TransDetail_Id=purchase_order_detail_id from...

create table cust(cust_id int,cust_name nvarchar(30),cust_dob datetime, cust_city nvarchar(15) ,state_id int, cust_phone numeric(10,0) ,cust_email nvarchar(100), created_dt datetime, modified_dt datetime)

Insert into cust values(1234, 'Tim D','2/2/1988','Austin', 200 ,48595098,'tim@gmail.com' ,'3/2/2011','3/2/2011')

Insert into cust values(1235, 'Bill...

Got it,

Thanks Drew

Regards

Guru

Thanks Jim..

Regards

Guru

select convert(varchar, '2012-02-17 15:13:25.060', 103)

2012-02-17 15:13:25.060

When i convert/cast the string to date its formatting

select convert(varchar, cast('2012-02-17 15:13:25.060' as datetime), 103)

17/02/2012

Regards

Guru