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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 NEWBIE :-(

Author  Topic 

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-30 : 09:12:00
Hello,

I'm 18 , work for an i.t firm in scotland , just started using my sql , im some sort of admin for our sql but dont know a heck of alot , its a database is basically all im aware of.

But we use a job logging system calle dmy helpdesk which ties in , anyone we have 10 support guys , and we have different sections tickets , and people , i dunno if its some kind of script or numbers , i could add them n stuff but is there some kind of command that does it for you , would be really helpful.

thanks for any help.

imagine making me the admin lol.

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts
Posted - 2009-03-30 : 09:22:41
Your description is really vague. I am not sure if anyone over here will be able to help you outt unless you post specifics. I'd think its your team members and you Boss who can only help you out right now ..
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts
Posted - 2009-03-30 : 09:30:52
quote:
Originally posted by tonyduffy

imagine making me the admin lol.


The sad part is making you admin but seemingly providing no directions. If they are willing to allow you to grow into the position - great, but you'd better learn to ask for guidance and training. Forums are great if you can explain what you're trying to do, show some examples of your data, both input and expected results, show your table layout and your attempt at code to accomplish your task. We DO NOT do homework here. 18 and working for an IT firm?? Call me cynical but it smells like a student to me.....

edit: Just noted "my SQL" - this forum is for MS SQL server. You may wnat to subscribe to an appropriate forum, somewhere like: http://www.dbforums.com/index.php which has a MY SQL forum...


Terry

-- Procrastinate now!
Go to Top of Page

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-30 : 09:40:43
ok i say admin,

i have the sql on my machine , im not a novice , i know my way about the system, i done a back up log of the helpdesk and imported it so it's like a dummy system.

so i can mess about on mine , and no doubt it will come.
asking for a bit of help it gets you slated , know what i mean fs.
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts
Posted - 2009-03-30 : 09:51:57
"know what i mean fs" - Nope (don't know what the quote means either. is that an insult??). What is it that you are attempting to do? What do your tables look like? Is it truly mysql or SQL server (there is a difference!)? If mysql, go to the link that was provided for more appropriate help.

"i done a back up log of the helpdesk and imported it so it's like a dummy system" - A full backup then a log backup and then a restore?? Is that what you mean by an import?

"im not a novice" - not so sure about that....

"and no doubt it will come" - I hope so.

This is not an attempt to get you upset. If you've come for help, state what it is that you're trying to do, show you attempt at it as well as some sample data and we can try to help.

Terry

-- Procrastinate now!
Go to Top of Page

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-30 : 10:15:24
Ok. I'm sorry just a little uptight about this.

Ok , we have a server were sql runs from , i backed the whole data onto a notepad , then imported it onto my machine.

I done the backup by clicking backup , new project and moved the part over to backup content , then executed the backup , now i have it on my sql dummy on my pc.

The system we use is a job logging system , like say the supporter is Me, my name is Tony , so it comes up Tony on the system , i wanna go and like get all my jobs for that week , and maybe put an announcment on to say this is what's what.

so say i have 300 jobs that week , is there some way , like for example on an spreadsheet , you can filter your name and it will show you what you've done.

Sorry for being snappy , thanks for any help.

Tony
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts
Posted - 2009-03-30 : 10:22:54
Tony, can you provide the table format and some sample data? It doesn't sound overly complex and with the info, we should be able to come up with something fairly quickly....

Terry

-- Procrastinate now!
Go to Top of Page

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-30 : 10:31:50
id group_id supporter_id company_id contact_id priority_id status_id platform_id category_id title description update_log version_id diskid_id date_created date_modified author_id survey contact_name
751 1 9 3 0 3 4 6 2 Payroll Printer rename printer and reconnect the department to it April 1, 2008, 10:41 am by Thomas Clay--//--Ticket created. Assigned to Thomas Clay.--//-- 0 0 1207042863 1207042863 9 0 john mcculloch


That how it comes up , i dont know if that makes any sense to you.

Tony
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts
Posted - 2009-03-30 : 10:47:25
Select * from helpdesk where contact_name like 'John%' will pull all records where contact name begins with "John". You can then filter on date (either date_created or date_modified, as long as it's a datetime field) where date_file >= '20090323' and date_field <= '20090330' to get a weeks worth of data. Is this getting closer to what you want to do?

Terry

-- Procrastinate now!
Go to Top of Page

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-30 : 11:01:11
yeah thanks,

I kinda get it , i'll have a mess about with this n let you know how i do,

thanks.

Tony
Go to Top of Page

godspeedba
Yak Posting Veteran

90 Posts
Posted - 2009-03-30 : 11:05:19
Kinda? A novice can understand this!
Go to Top of Page

tonyduffy
Starting Member

7 Posts
Posted - 2009-03-31 : 09:25:28
quote:
Originally posted by godspeedba

Kinda? A novice can understand this!


Back to warcraft ya fukin loser
Go to Top of Page

tosscrosby
Aged Yak Warrior

676 Posts
Posted - 2009-03-31 : 09:36:58
No need to get nasty folks.

Godspeedba, newbies have to start somehwere, correct? You either were or are in the same situation (I know I am/was).

And tony, being crude in your response will either get you banned, or at the very least, no help. Those providing help (freely!) have a low tolerance for disrepect. If you have additional issues with repect to your OP, please let us know what issues you're facing.

Terry

-- Procrastinate now!
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts
Posted - 2009-03-31 : 09:38:53
Besides, all the warcraft servers are down for maintenance today

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts
Posted - 2009-03-31 : 09:58:05
Seems like you need to learn all the basics and a good place to start is here: http://www.w3schools.com/sql/default.asp. Go through the tutorial and you'll be a slightly better admin in no-time

- Lumbago
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site