INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL String vs Separate SELECT Statements

SQL String vs Separate SELECT Statements

(OP)
There are, out in the field, several versions of an EXCEL workbook which contractors use to enter inventory. Before they begin, they are supposed to check for the latest version, but most don't. The differences are in the nature of more fields appearing in later versions.

My first step in processing these workbooks is to bring each worksheet into a corresponding table in a SQL Server holding database. The values in the various fields are then distributed to the appropriate tables and fields in the working SQL Server database.

At the moment, I am using SQL strings with IF statements to include or exclude the presence of newer columns in the INSERT statements. Would the processing would be more efficient if, instead of using the SQL string processing, I used the IF statements to route the processing to the appropriate individual INSERT statements?

RE: SQL String vs Separate SELECT Statements

Perhaps. The best way to see how a computer performs is to do testing. Try it each way.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


RE: SQL String vs Separate SELECT Statements

(OP)
Thank you. Guess that's the way to be sure.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close