Passing table name as parameter into SP

Question

Passing table name as parameter into SP

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27060 More actions · Answer 1

Luis Cazares (4/28/2016)
Learner44 (4/28/2016)
Only one question now!!
How I can become like you pro in SQL
Please answer. I am ready to do whatever it takes.
BY the way that solution worked fine.
Read blogs, articles and books, install SQL Server on your local machine (Developer edition is now free), practice and try to answer forum posts (even if you don't post your answers or if there's already an answer). Appreciate the feedback on all code you post.

Go to PASS http://www.sqlpass.org/"> http://www.sqlpass.org/

Find local and virtual chapters, go to the meetings.

Read everything!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Michael L John One Orange Chip Points: 27060 More actions · Answer 2

I'm still wondering why you need to do this.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Learner44 SSCarpal Tunnel Points: 4466 More actions · Answer 3

Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so we drop them and create again for that week use.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

Learner44 (4/28/2016)
Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so we drop them and create again for that week use.

The question was why do you split the source table into 4 destination tables, not why you can drop the 4 tables you create.

Michael L John One Orange Chip Points: 27060 More actions · Answer 5

Learner44 (4/28/2016)
Because we do this exercise every week splitting one table into 4. So when we do this we don't care about what's in there into those 4 tables so we drop them and create again for that week use.

You keep telling us what you are doing, not why.

Why do you need to split a table into 4 different tables every week?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Learner44 SSCarpal Tunnel Points: 4466 More actions · Answer 6

it's much faster to import data into our software from 4 small tables as compared to one big table. that's why.