April 28, 2016 at 11:46 am
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/
April 28, 2016 at 11:47 am
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/
April 28, 2016 at 12:33 pm
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.
April 28, 2016 at 1:07 pm
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.
April 28, 2016 at 1:17 pm
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/
April 28, 2016 at 1:54 pm
it's much faster to import data into our software from 4 small tables as compared to one big table. that's why.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply