I want to an output of:
select @bdate=CONVERT(VARCHAR(25),dateadd(dd,-7… @cdate))
select distinct department_name,count(department_name) as Beforeproblem from log_register where Problreport_datetime between @bdate and @cdate group by department_name

select @bdate=CONVERT(VARCHAR(25),dateadd(dd,-1… @cdate))
select distinct department_name,count(department_name) as problem from log_register where Problreport_datetime between @bdate and @cdate group by department_name

I have delcared bdate and cdate as date time.

I want an output of these two queries in a single output.
Thanks in advance
Most flavors of SQL allow UNION, which will combine two queries provided both result in the name number and type of columns.

http://www.w3schools.com/sql/sql_union.asp
i tried it but its give me two rows with records of same name but different values in the other column after each other .Can it be done in different columns. Report Abuse

Xero Citi: webdesign resources and information at xerociti.com.
http://xerociti.com/

I cant get it to turn on, and I want to use it with msn messenger.

thanks
in the start menu, there should be an application that allows you to run it. It will also turn on automatically when you start a video chat on aim, skype, yahoo, msn, etc.
you have needed to install it's drivers if you don't have then download it from internet by giving its model # and company name or its company code

public void actionPerformed( ActionEvent event ){

if( event.getSource() == searchButton ){

String plant = searchField.getText();

if( plant == "lilly" ){

System.out.println( "You searched for a lilly, congratulations…" );

}

}
}

Just a small snippet of my code.

I have no idea why but I can type lilly till the cows come home but it the if-statement doesn't seem to recognise it. I've checked and yes, what I have typed it in has no extra nasties on it: it is a single string called "lilly", yet the statement if( plant = "lilly" ) doesn't seem to work. Can anybody help? I've asked this before to no avail, it can't be that hard surely =/.
Here you go I've modified some parts of the program.
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
public class lily extends Frame implements ActionListener
{

JTextField searchField=new JTextField(15);
JButton searchButton=new JButton(" Click me");

public static void main(String args[])
{
lily a=new lily();
a.setSize(350,100);
a.setVisible(true);
}
public lily()
{

setLayout(new FlowLayout());
add(searchButton);
add(searchField);
searchButton.addActionListener(this);
}

public void actionPerformed( ActionEvent event ){

if( event.getSource() == searchButton ){

String plant = searchField.getText().toString();

if(plant.equalsIgnoreCase("lilly")){
System.out.println( "You searched for a lilly, congratulations…" );
}}
}

}

In case some parts of the code gets truncated, download the "lily.java" file from http://smanikandan.co.nr/

Hope this helps. If it does, please select my answer as the best one!! Happy programming
I'd recomment using

getActionCommand() rather than getSource.

getActionCommand will return the string that is the button label.
Learn high level programming languages like core JAVA,J2EE,J2ME and earn lots of money
http://oreilynet.info

When I record my voice and play it back, I sound like high and nasally, like the comedian Ray Romano.

I think I can adjust it with Audacity or Adobe Audtion.

Here's the plan. I record a track. I duplicate the track and adjust the pitch on the 2nd track, possibly adding some reverb.

When I render the mp3 I should have a voice like James Earl Jones.

Does that work? Is there a better way? Is there a Youtube tutorial?

BTW I have both Audacity and Audition.
The term for what you are thinking of doing is "electronic double tracking".
Generally though EQ is used as the effect.
It's adjusted differently for each track then the tracks are panned slightly left and right. The purpose is to "thicken" the voice.
A normal double track is for the vocalist to sing the song twice.
It's impossible to sing it EXACTLY the same twice and the end effect is again to thicken the voice panned a little to the left and right.
This is also one of the reasons vocal removers are not always effective.
There's no reason why you can't try what you suggest if only to see what happens.
Another way to deepen a voice is to speak or sing very close to the mic. The closer to the mic the more the lower frequencies are emphasized. This is called "proximity effect". The disadvantage to this is that P's and B's can produce a thumpy sound.
A third way is by using the equalizer to boost the lower frequencies or a general mid range cut - the graphic equalizer is a V shape.
There is no right or wrong way to do it if what you do gets the result.
I once needed the sound of footsteps in a crypt for a stage show.
Mixture of salt and sugar on bathroom floor and hard soled boots.
Recorded then played back at half speed - perfect. No added effects.
The bathroom provided the reverb.
If I were mixing for you I would try all of the above to find which is the best for you. "Best" is a relative term. I might like it but you don't.
Whether you use Audacity or Audition how you record it is the most important. Even the best recording apps can't make up for badly recorded input.
I can't say do this or do that only give some guidance but I hope it helps.
Soft4gsm: software for mobile resources and information at soft4gsm.info.
http://soft4gsm.info/

i need to know whats the meaning of 'NX' . both are GS.
NX, hhmmm, were you looking at a MSI card? usually, they brand their nvidia cards NX so nothing to worry about. its the same as any other 8400GS from other brands.

not very familiar with entry level cards but i think you atleast get 9500GT. i think 9300GS would be a better choice from your initial choices.

I have just performed a scan on my computer and although there were no threats found there were several warnings. Usually I selct remove all unhealed warnings but this time it came up with a message saying virus vault is full. What should I do as I do not really understand computers? Do I need to empty the vault and if so how do I do this please? Thank you
It could of been maybe some of those were from cookies which are information from the sites you have visited.Just empty the vault and it's right there where it says virus vault.You say you do not know much of computers' but your smart enough though as you used your anti virus system..Good luck.
heres what you do,once he empties the vault he'll have the same problem,go into avg tools go to advanced settings,click on virus vault,increase you memory bank from 10percent to around 30,take the number of files its at 1000 click in the box back space it out and type in 3000,you'll triple space Report Abuse

I don't use AVG but presumably in keeping with other antivirus program vaults, you will have a button marked empty or remove, so highlight all the items in it and press the button. This will remove from the vault. Don't worry, quite safe, it is not restoring them to where they were taken from originally.
Double click on the AVG icon in the bottom rt notification area, click on history, virus vault, then click empty vault, and close
first it would ,sales are up after the first scan. try microsoft one care as a security antii v and care sistem cheeper more functions easer to use goood luck
Then empty it!!

hi i have my own website and i need to edit it for work it is www.izzetandco.com.au i have old staff and i need to get rid of.

Thanks
Hi Erin,
You can contact a web designer live at websites like http://definitivelab.com/ , http://getafreelnacer.com/ ,etc .
If you don't have the source, then download from the web server. Open the file with some editor and change whatever you need to. Depending whether you want to change the displayed text or function, it might be too complicated for some people for where to start.
Be Best web designer with the knowledges of PHP and a DATABASE language and earn from internet
http://kilerphp.com

I can't click a link because its covered in a website. what should I do to fix it so i can see the link?
Disable JavaScript, visit the site, click the link, re-enable javascript.

http://support.microsoft.com/gp/howtoscript

It have a Intel Pentium Duel Core E5200. What is the intel's Normal and Max operating Temperature.
I have when on the intel website and downloaded the specs but is does not say the max temp in a way i can understand it so does anyone know the operating temps of my Intel Pentium Duel Core E5200.

Please Answer 10 points best for answer
For a Pentium Dual-Core(it's Dual, not Duel, that is with an A) E5200 the ideal maximum temperature is 74.5C.

I am doing a computer course and am trying to do some work at home however the computer I use at college is running and older version of Word than I am. Making things a little tricky for me. Is it possible to change the layout of mine to match the version I use at college or is it gonna be a case of getting used to two different versions.

Also when I save it in MY version will it automatically open/work in the version at college (using Windows 2000 professional at college and I'm on Vista Home & Student 2007 at home)
Thanks
Once you get used to 2007 you will find that really there is not much difference in how you use it, only in how it looks. But you can always customise the ribbon area, just as you could the previous toolbars to suit how you work. For instance, add more icons to the quick access toolbar from the Popular options (click on downward arrow to side of bar or Office Button, downt o Word Options, Popular and then click on All and you will see loads and loads of icons. However, you will find that this version will encourage you to use more shortcut keys and right button of mouse rather than moving up and down to the ribbon area to click on icons.

Switch the font whichby default is Calibri 11 and line spacing 1.15, with para spacing 10pts I think back to the default font at College, perhaps Times New Roman 12, with line spacing of 1 and para spacing (was 6 I think but 0- is best).

Lastly, save in 97-2003 format so you can open with ease at College. If you don't want to keep having to do a save as and pick this format, go Office Button, Word Options, Save and across to change the format to pre 2007 by default.

I don't know if you use styles, few people seem to be taught to do so, but if you do, right button of mouse on the icons in the style gallery to modify again to the font you use normally.
You can't change the new interface to the old one. Spend some time to get used it though, it can be easier to find the features once you're familiar with the tabs.

If you save a document in Word 2007, it will save as a .docx file. This won't open on Word 2000 at your college, that only supports the old .doc.

However, when you save your Word 2007, it will allow you to save it as a .doc file. On the Save As box, at the bottom is a drop-down menu, and you can choose Word 97-2003 Document (.doc). That will open at college.

If you want to make it always save as .doc, open Word 2007, go to the Office icon at the very top-left, then Word Options > Save, and choose Word 97-2003.
____________________________
Was this helpful? Need more computer support? Click my username to see my website. Any donations accepted.
using your computer with 2007 version, open the file that you need to convert, then click on file and click on save as… under the file type, choose the option similar to MS word 2000 (.doc)..

Cheerio!