But, you might be able to get a team together from here that can help, if you are willing to work with geographically dispersed individuals.

The marvels of modern technology.

sturner (6/26/2012)

---

Its...

As an individual, nope....

Not sure why you got the error message you did, the function only has one parameter and you are passing it one parameter.

The following, however, is how I would do...

ScottPletcher (6/26/2012)

---

OK, but it's not the odds against losing it,...

Smoky

Sean Lange (6/26/2012)

---

I guess that depends on what you...

Try the following code snippet based on what you originally posted:

DECLARE @Document TABLE (DocumentID INT);

INSERT INTO C_Documents (

DocumentSectionID,

FullPath,

FileName,

FileTitle,

Description,

UserID,

DateCreated,

TimeStamp

)

OUTPUT INSERTED.DocumentID INTO @Document(DocumentID)

VALUES (

@DocumentSectionID,

@FullPath,

@FileName,

@FileTitle,

@Description,

@UserId,

GETDATE(),

GETDATE()

);

INSERT INTO F_ProjectDocument(

ProjectID,

RoundID,

DocumentID,

DocumentTypeID,

FFPUploadID,

UploadOn,

UploadBy,

DateCreated,

UserID,

TimeStamp

)

SELECT

--VALUES (

@P,

@R,

D.DocumentID,

@DocumentTypeID,

@FFPUploadID,

GETDATE(),

@UserId,

GETDATE(),

@UserId,

GETDATE()

--)

FROM

@Document d;

UconnDBA (6/26/2012)

---

Unless there is absolutely another reason to do otherwise, which i have to this point i have yet to find in the 10+ years have been doing SQL...

...

river1 (6/26/2012)

---

Hi,

I have this query:

(SELECT

DISTINCT([NIF_ANTIGO]),

[NIF],

[FILIAL_NUMBER],

[STATUS],

[COD_GRP_CONTRIBUINTE],

[COD_TP_SINGULARES],

[COD_MET_TRIBUTARIO],

[COD_TP_IMPOSTOS],

[GRANDE_CONTRIBUINTE],

[NOME],

[MORADA],

[COD_CIDADE],

[C_POSTAL],

[TELEFONE],

[FAX],

[COD_PROVINCIA],

[COD_MUNICIPIO],

[COD_REP_FISCAL],

[DT_INICIO],

[DT_ALTERACAO],

[DT_CESSACAO],

[COD_MOT_CESSACAO],

[MOT_CESSACAO],

[COD_TP_INSTITUICAO],

[COD_FUNC],

[COD_COMUNA],

[COD_BAIRRO],

[OBS],

[DT_BEGIN],

[BI],

[OLD_NIF],

[PSERVTCO],

[PSERVTCP],

[PSERVA],

[DTACESSACAOTCO],

[DTACESSACAOTCP],

[DTACESSACAOA]

FROM

BULK_CONTRIBUINTES_21 A

WHERE

A.VALIDO_BULK IS NULL AND

A.NIF_ANTIGO NOT IN

(SELECT NIF_ANTIGO FROM SGCTCentral.DBO.CONTRIBUINTES WHERE NIF_ANTIGO IS NOT NULL) )a

Shoudn't it return only...

I'd say both queries have issues as well. Since you are apparently using SQL Server 2005 (this is a SQL Server 2005 forum you posted in) and are using the...

Please realize that I am just shooting in the dark here since I can't see from here what you see there. If it is the service account, you should...

mtillman-921105 (6/25/2012)

---

Lynn Pettis (6/25/2012)

---

Evil Kraig F (6/25/2012)

---

bitbucket-25253 (6/25/2012)

---

Any one know if those spreading Colorado wild fires are threatening Steve's home or the horses? Any one hear from Steve on...

Which server are you trying to run SSIS package? I wouldn't be surprised if the problem is the account on which your Dev box is running (Local Service Account)...

Evil Kraig F (6/25/2012)

---

He's...