Ahhh - Sorry about that. So you want to create N empty rows in the target table?

I suppose you could use a while loop. I wouldn't use a...

Take a look at SET ROWCOUNT. We have used this with some success.

SET ROWCOUNT 10

INSERT INTO tblTarget( intTargetField )

SELECT 0 FROM tblWithLotsOfRows

SET ROWCOUNT 0

Guarddata-

What kind of encryption was used to get the data in? Many of the encryption algorithms produce text results that can be read as text and fed into the...

Keep in mind also - depending on your configuration you may actually be storing twice as much when saving in the database because of the transaction log. We have...

Even NOT EXISTS is better than NOT IN

SELECT empleave.* FROM empleave WHERE NOT EXISTS (SELECT * FROM emp WHERE Emp.EmpCode = empleave.EmpCode)

Guarddata-

Sorry - I must have closed the browser before my last response registered.

I would do two thing:

1) Start with the table that reduces the result the best. In this...

When you say "name of the table I am importing from", it sounds like you are executing a BULK INSERT or bcp call. If that is true, you need...

jraha - Good call! Joining is faster than using IN statements and using a subquery DOES mean that it gets executed for each row.

By the way - does TOP...

Since there are two questions, let me take an initial stab and you can steer me into greater understanding.

First - I would start with the v_call_type table and make sure...

Just a thought. Try putting an ELSE condition in your CASE (i.e. CASE WHEN @Religion IS NULL OR @Religion = '' THEN ud.religion ELSE @Religion END )

You also...

Wow! For a minute I thought you actually believed that Microsoft has desires for something other than "sheer profit". I don't want to start...

I don't know the exact terminology, but by repeating the table name in the from clause, it creates the ability to use the abbreviation (d) in the join statement. ...

You need to have some kind of data that shows where you are. If there is an ID, select and order by ID. The next select has a...

What kind of "file" are you referring to? Is this a file of information to be imported? If so - bcp can batch the input. If it...

Another vote for Stored Procedures. There are times when the SQL is dynamic enough to be done "better" from another tier, but when the parameters and output are known...