Male/Female you say...

Look what professionals think about it:

http://www.nzhis.govt.nz/moh.nsf/pagesns/48/$File/4NMDSDataDictionaryv68.pdf

Go to page 118, chapter "Gender code".

See? 😛

Why not hockey stick?

Must be as useful.

Play with isql utility.

It has full description in BOL.

Hopefully it's what you need.

Jeff,

look again on the second post from OP.

He wants DIFFERENT OFFSETS for different days.

No matter how hard you try with GetUTCDate or registry reading it will always give you...

No need for CASE at all.

RIGHT('0000' + cast(R.PostalCode as varchar(50), 5)

I saw such errors.

One of our servers has a limitation on amount of data returned to a client.

If any connection exceeds this limit server blocks further communications from this connection.

QA...

What it has to do with T-SQL?

Run this and see how many rows it will return:

select * from DATABASE.dbo.sysobjects

where name = 'TABLENAME'

There is a way:

SET DATEFORMAT dmy

Can you explain what the point to have 3 identiacl rows?

And especially what's the point of keeping 2 of 3 identiacal rows?

Does it make any difference which 1 of 3...

You did not succeed.

For me these lines:

LMN 27 M

LMN...

vish,

I don't see any numbers assigned to the rows.

How can I tell which ones are 1,3,6,7?

This will apply cross-join to Servers and steps, so every server will have every step assigned, and it will insert into the table all records from that cross-join which are...

Easiest way - in QA menu click Query -> Show Server Trace.

Don't EVER load file straight into a table.

Even if that file is perfectly formatted for your favourite upload process.

Load it into staging table (single varchar column, maybe even text), DO...