There's no way. When Windows starts the application it looks into it and sees it's a console application. It pops up a console. This is the correct behavior.

Yes, it would be possible to modify it so there would be a sgminer-noconsole and yes, it's also possible to modify it so it spawns a console only on request but most people isn't interested in moving the miner that way.