HI There.

A colleage of mine has given me this advise but nothing too elaborate:
The auto increment number is through a Trigger that when a opportunity is created it adds one...

Apologies for the delayed response on this. I have been thinking to maybe do this..
Create the trigger against the opportunity table then create a new table called quoteno and...

Yes correct..
Each entry that a user enters has a unique client ID which is assigned to each client entry in the opportunity table. Each client that is entered gets...

HI
There is an Opportunity table and Quoteno is a user defined field that is recorded in the UdF table. Quoteno is specified by a type_id - in this...

i figured it out.. sorted the issue.. Thanks though

If I create my function as below, I get the following error:

Must declare scalar variable "@EndDate"

what I mean by the following is:

I don't want to put in a specific date,...

select statement:

select a.Owner_Id,

b.Name as KPI,

B.Record_Type,

B.Resource_Id,

C.Display_Name,

count(A.Owner_Id) as Max

from amgr_appointments A

right outer join AMGR_Resources B on A.Owner_Id = b.Resource_Id

right outer JOIN ADMN_User_Details AS C ON A.Creator_Id=C.User_Id

where b.Resource_Id in ('R25B2864CB6', 'R2691D72523', 'R25B2868972','R25B2868EE0','R39D1B39765', 'R0DF25BF278')

and...

No the right join brings all the rows however the action taken field is duplicated with the same number for each entry. It only has to apply to the entry...

@hugo, my apologies I am just trying to get to see which method will work best as I am fairly new at SQL:

1. what I need to be...

@Lynn, Thank you so much! You a Star

here my actual code to make things clear on what im trying to achieve here:

select

D.First_Name as FirstName,

D.Name as Surname,

D.Phone_1 as Main,

D.Phone_3 as Cell,

case when a.Type_Id = 98 then a.Description...

Table a and table b link together using type ID and code ID.

Table a contains the description of the fields ie. Relationship and owner and their respective values within the...

apologies for my ignorance however im new at this..

Must i not use a trigger or must i just use a different trigger?

How would i incorporate the code above into my...

IN MY CODE, something like this:

if EXISTS(SELECT AlphanumericCol FROM AMGR_User_Fields_Tbl I

WHERE I.AlphanumericCol IN(SELECT CLIENT_ID FROM AMGR_User_Fields_Tbl)

i cannot use a constraint of sorts as it changes the structure of the database.

Can you possibly give me an example