I agree with Paul - normalization is good for any OLTP system. Don't believe everything you read...I would start by not believing the quote above that it isn't good.

That...

I think David is on to something here. If both columns are meant to be the same and they actually do hold smallint data, then convert the float column...

Not as far as I know. I know exactly what you mean, as I've encountered it several times myself. What I've done in this situation is:

1. Start with...

I should have pointed out that you don't have to use SSIS for this. You could implement this is a SQL procedure using the BULK INSERT statement. The...

I really like the approach Luis took to split the data. You could use the BULK INSERT into a single field from my approach and then split the values...

This is a pretty interesting problem. I don't know if this is the best way to handle it, but here's one approach. Let me admit up-front that I've...

Glad I could help.

You're going to want to use the DATEDIFF function.

For something more specific, please post the DDL to create your tables and some sample data so we can see what you...

You have a GO after your USE statement. This terminates the batch above the GO, eliminating the variable declaration in the batch started immediately after the GO. Move...

Or do you want to use RAISERROR with a message that contains a variable string?

Example:

SELECT @intCount = COUNT(*)

FROM table_name

WHERE code = @passed_code;

IF @intCount > 0

...

Is this what you're looking for?

SELECT t2.[index], t1.[type], t1.code, AVG([current]) avg_current, AVG([bpo]) avg_bpo, AVG([forecast]) avg_forecast

FROM table1 t1

INNER JOIN table2 t2 ON t2.code = t1.code

...

Another possibility you may want to consider is to use a system tool to ghost the production server and then apply the image to the test server. I've never...

I admit I've never used the SOUNDEX or DIFFERENCE functions before, so I got to learn something today. That's always a good way to start the day. Thanks...

No problem. Glad I could help.

Ed Thompson (6/27/2013)

---

But the supreme rule is: all input should be viewed as questionable whether it is coming from a source internal or external to your organization. You can...