BULK INSERT

FROM ''

WITH

(

FIELDTERMINATOR = '\n',

...

If it's uniqueidentifier then it's not varchar, it's binary(16).

Treat it as it is, not as it seems to you.

P.S. Substring works for binary strings as well.

Did you actually check it? Did some tests?

If this table is more comfortable to read for you, it does not mean it always faster to operate for SQL Server.

Is it uniqueidentifier?

from OPENQUERY(MOTHRA,

 'select *

  from MOTHRA.INFOED_PEOPLE where mothraid not in (''00350077'', ''00072066'')') a

BOL:

BULK INSERT

Copies a data file into a database table or view in a user-specified format.

Syntax

BULK INSERT [ [ 'database_name'.] [ 'owner' ].] { 'table_name' FROM 'data_file' }

    [ WITH...

Use ROWTERMINATOR = 'DN:' in BULK INSERT

Why you need temp table at all?

Create FUNCTION GetNumberOfPostsInForum(@ForumId int)

returns int

as

begin

declare @NumberOfPostsInForum int

select @NumberOfPostsInForum=count(*)

from dbo.GetTopicsOfForum(@ForumId) T

INNER JOIN Posts ON Posts.TopicId= T.TopicId

return @NumberOfPostsInForum;

end

Because char(2) definitely not enouph for country.

What will code "AR" say to you about name of the country?

And if a person lives in USA it does not mean this person...

So, you do have separate table for states anyway.

And for referential integrity you must have FK constraint to State in Person table.

Because you limit capabilities of your system only to...

> It is perfectly acceptable to have the state name in the person record, instead of a stateid

Will you have list of states in your database?

Will you allow to enter...

What about me?

I was not born in any of states.

Can you make a record about me in your system?

My example is right.

You were trying to assign Custome Number to Person entity.

I told that Customer Number belongs to another entity.

Now you agree that Customer Number is a property...

Point is:

changing of Customer Number or becoming a VIP does not make you another Person. Your PersonId suppose to stay the same in any system.

And if you update a record...

Gender - yes, No.1;

customer number - what is this? Customer of what?

marital status - how many of them?

social security number - it's not a personal property, it's reference from...