Re: [NF] Transact-SQL problem

On Tue, Jan 8, 2013 at 10:02 AM, Paul Newton wrote: > Hi all > > The following is a column definition (part of a create table statement in > Transact-SQL > > [wp_pssslip] [int] NOT NULL CONSTRAINT > [DF_wparm_wp_pssslip] DEFAULT (24) > > I want the default value for this field

RE: [NF] Transact-SQL problem

Thanks Paul - I will explore that ... -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett Sent: 08 January 2013 16:09 To: profoxt...@leafe.com Subject: Re: [NF] Transact-SQL problem On 1/8/13 8:02 AM, Paul Newton wrote: > Hi all >

Re: [NF] Transact-SQL problem

On 1/8/13 8:02 AM, Paul Newton wrote: > Hi all > > The following is a column definition (part of a create table statement in > Transact-SQL > > [wp_pssslip] [int] NOT NULL CONSTRAINT > [DF_wparm_wp_pssslip] DEFAULT (24) > > I want the default value for this field to be the

[NF] Transact-SQL problem

Hi all The following is a column definition (part of a create table statement in Transact-SQL [wp_pssslip] [int] NOT NULL CONSTRAINT [DF_wparm_wp_pssslip] DEFAULT (24) I want the default value for this field to be the lesser of 24 and the value of another field (wp_summpp