Presume it must be a restriction and that sql cannot do implicit aggregate within an aggregate and therefore you will have to do it explicitly (or is that the other...

Thats great, it's what we're here for.

What I meant with my last post was to create a parameter to the proc not in, such as

Create Procedure spInsertNProject(

@requestorname varchar(50),

@requestorLoc varchar(50),

@dueDate datetime,

@projName...

Declare a new parameter in your proc

@projectType varchar(50)

and change the where to

WHERE a.projectType = @projectType

I have noticed that you have specified projectType in your list of 'project table' columns but...

What I outlined should work fo you. My tblProjectType would contain the project types, e.g.

1 New DB Creation

2 DB Amendment

...

and tblTypeTask would contain the relationships of projectTypes and Tasks, e.g.

1...

Excellent Jeremy

Or simply use Design Table option in EM and remove tick from identity.

or

ISNULL(REPLICATE('0',5-LEN(PALLET_NUMBER)),'')+PALLET_NUMBER

You have not specified the relationship between projectType and Task.

Assuming two new tables

tblProjectType:

typeID int primary key

projectType varchar(50)

tblTypeTask

typeID int

taskID int

Then change insert/select to

INSERT INTO tblProjectTasks (

Project_ID,

TaskID,

statusID

)

SELECT...

If by product you mean row1.numb * row2.numb etc. Then

declare @r numeric(28,0)

set @r=1

select top 100 @r=@r*numb from tabela

select @r

Can't seem to find a way not to use TOP.

I think you have a logic problem, try

open pncursor1

fetch next from pncursor1 into @pname1

while (@@fetch_status = 0)

begin

print '...................p1'

open pncursor2

fetch next from pncursor2 into @pname2

while (@@fetch_status = 0)

begin

print 'p2'

fetch next from...

What order do you want for the selection and does the table have a PK or IDENTITY column?

e.g.

create table #t (IDno int identity(1,1),val int)

insert into #t values(34)

insert into #t values(67)

insert...

I have SQL7 SP4 on WIN2K and wanted to do external emails with attachments and due to our security policy and firewall restrictions I cound not use SMTP. Therefore I...

I have used this method before but could never get it to work with fields greater than 255 chars, even when following the documentation!

I run my DTS via SQL agent and use two scripts I found on this site (modified for my own use) to show failed and running jobs. I also log...

There are several threads on this site that refer to finding the version of MDAC installed. I use COMCHECK (downloadable from Microsoft).

Have you checked server to server connectivity?

Edited by -...