Create .cvs files.

They'll never realise...

Select H.Doc_ID

FROM Header_table H

LEFT JOIN Row_table R ON H.Doc_ID = R.Doc_ID AND R.Part_Id = 'Part1'

WHERE R.Doc_ID IS NULL

Actually you could just press F1 and type REPLACE in index keyword box.

Would get answer much faster.

REPLACE(AddressString, ',', ' ')

So, why it should be

John NY ...

Create view from these tables.

Create INSTEAD OF INSERT trigger to populate tables with data from table INSERTED.

Then just do INSERT INTO dbo.View.

This table must also have clustered index on that column.

No, I mean MUST have.

Then it will work very nice:

DELETE FROM dbo.Table

WHERE DateRecorded < DATEADD(dd, -30, GETDATE())

You need 4 tables:

Table dbo.Calendar to hold all possible dates;

CREATE TABLE dbo.Resource (

ID smallint IDENTITY(1,1) NOT NULL RPIMARY KEY,

Name nvarchar(100) NOT NULL

)

to hold the list of resources you manage (currently...

Start Profiler.

Start recording.

Create a new job from EM.

Stop recording.

Read the command EM used to create that job.

Copy commands to QA.

See BOL for the meaning of the commands and parameters.

Change whatever...

What do you mean "When I retrieve data from SQL Server 2000"?

Using which application?

Did you pass this information to SQL Server in any way?

So where it suppose to get it from?

Only if you have a crystal ball inside of your server...

- uncertain matching (see initial post)

- collation dependency

VARBINARY passwords are as human readable as VARCHAR. Just need to use simple CONVERT function.

Encrypting of passwords is a subject for another discussion.

OK, then my query must return right result.

Did you try it?

SELECT EID,EName

from Emp o

inner join GrpIn i ON o.OID=i.OID

where OTID = @OTID and OInd = 'N'

and (O.OID = @OID OR @user-id =1 or @UserId=2)

You did not tell why...

C'mon,

everybody forgot about poor Mark!

I don't see anything wrong with your first posting.

Update statement must work fine.

Were there any complaints?

How long you plan to use this software?

2, 3 years?

Then load 3 years amount of dummy data into database and try to run the application.

Don't sign the project off and...