Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-04-20 : 21:22:33
|
| every day my manager tell me to execute multi query and delete some data also update,etc,I do every thing manually using new query and writing scripts T-SQLis there any way to reduce writing scripts,like ms access there are a lot of wizards and template query without coding like :find duplicated records,merge data, Tab-Cross,Pivoting etc..when I told my manager to write query every action ,he tell me that there is some way to reduce headache , I am ready to use any other software to simplify the amount of work.thank you. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-04-21 : 00:10:58
|
| there is SQL agent available in sql server by which you can schedule jobs to do your work on a regular basis... |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-04-21 : 00:11:36
|
| it applies only if your work doesnt change daily.. |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-21 : 03:35:56
|
| how can I utilize of SQL Agent to reduce manual script writing ? |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-04-21 : 03:55:19
|
| is it the same work you do daily?bcoz,if your work changes as per the requirement then you have to modify the TSQL manually... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2011-04-21 : 04:46:55
|
| Sounds to me as though you need to build up a library of scripts that you can use when you need to. You may find some of the standard sort of code e.g. pivoting, elsewhere on this site.-----------If debugging is the process of removing software bugs, then programming must be the process of putting them in. |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-04-21 : 05:05:30
|
| MR. Ahmed it is not the same every day, it is different.but I must do everything manually it is very headache ..!!do u know SSIS , or others tools like tools in MS ACCESS like filters and so on. |
|
|
|
|
|
|
|
|
daily headic in mms