look through this post by pinal dave

http://blog.sqlauthority.com/2008/05/29/sql-server-unpivot-table-example/

You're still converting the numbers you're performing the arithmetic on

try this - does it work better for you?

SELECT

CAST

(

(SUM

(

CASE WHEN STAT_PRODUCTIVITY.Action != 'Folder'

AND STAT_PRODUCTIVITY.Action != 'Assigned'

THEN Number...

Perhaps this link from @AndyLeonard will help

http://sqlblog.com/blogs/andy_leonard/archive/2010/07/19/why-does-ssms-generate-create-scripts-with-exec-dbo-sp-executesql.aspx

file permissions will sting you if they're not local admin or whatnot..

ah well.. i'm sure the user will be back.. when they are.. check the folder permissions and see how...

Yep, cause for example:

If you had 18.642372121 / 37.33121

What you're doing is

18.64 / 37.33 = 0.49933029.....

But what you want is the end result as 2 digits, not the entire math.....

Check the users permissions - do they have permissions to start a service? do they have permissions to the file structure etc?

What's your desired result?

My intention wasnt to sound rude. i was just being sensible. i already posted my reasoning in the previous post.

op is clearly over his/her head, so they shouldnt continue...

Actually.. you are here for some'bludy' advise from me, and anyone else who replies.. thats how you learn. starting your knowledge is one thing.. as you say, we all...

if you don't know, you're not the right person for the job. I'd advise seeking help from a professional, or explain to your boss that you they need to...

you could just use xp_cmdshell to execute the cmd file..

though personally, I don't like xp_cmdshell to be enabled at all - i'd advise looking at other options, but thats just...

Why not just use bcp? Its easy to do.. Open a command (the black dos type window) window and run the command..

bcp <yourdb>.<yourschema>.<yourtable> out <filename> -c -t,...

Sure

right click your stored procedure and click Script Stored Procedure As - then pick ALTER To - Then pick new query window

This will display your stored procedure - you can...

modify your stored procedure and add a PIVOT

ah ok - then in that case i don't feel quite so clueless - i was looking at this and was like.. HUH?