I haven't been able to figure out how to get the data..

ColA ColB Date1 Date2 Min

to show up in a graph where you get each result of...

I created that set of code, for this example to show what I was trying to do.. not the code that is in the stored proc (it is doing a...

That is a simplistic version of the code.. the problem I have with IF statements, is that you have to create a very long IF THEN Else IF... version to...

It is running in the background... it went from:

14/2012 22:39:27.495""0""1""0""0""1.0149924959519718""500""30.800937626858559"

"06/14/2012 22:39:32.495""0""1""0""0""2.8118779960191742""500""122.80416470472795"

"06/14/2012 22:39:37.494""0""1""0""0""1.4837434959583784""500""14.800478387071642"

"06/14/2012 22:39:42.494""0""1""0""0""2.3431249959999789""499""140.4046486817937"

"06/14/2012 22:39:47.494""0""1""0""0""1.4056189959615772""499""74.402108052269298"

"06/14/2012 22:39:52.494""0""1""0""0""2.3431249959999789""499""117.40426821893001"

"06/14/2012 22:39:57.494""0""1""0""0""1.6399964959775692""499""14.600491867517608"

to writing this:

"06/14/2012 22:40:22.494"" "" "" "" "" "" "" "

"06/14/2012 22:40:27.494"" "" "" ""...

Lynn Pettis (6/8/2012)

---

dwilliscp (6/8/2012)

---

Ok.. I ran the statement "SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 4)

" and it does return the 5th of next month.

However I do not understand how...

Ok.. I ran the statement "SELECT DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) + 1, 4)

" and it does return the 5th of next month.

However I do not understand how it is doing...

Thanks.. I did open up a thread there..

I am using IE... and do not see any of the settings you listed.. 'http://MyServer/Reports/Pages/Settings.aspx'

Ok.. Thanks for your help. I guess you get all columns in the output file, even though they were not in the set trace command.

The problem is that when you do :

SELECT [Server]

,DATENAME (YEAR, [Net_Day]) + ' / ' + DATENAME(MONTH, [Net_Day]) as 'Net_Day'

...

Thanks.. not sure why it is going more than one hop.. but will do.

SELECT RUN_TIME

FROM MSDB.DBO.SYSJOBHISTORY

I have run_times from 200 up to 230200??? The run_date is YYYYMMDD but how you get the time the job ran from 200 or 230200 I have no...

My boss is against setting the Max Memory... so until I can Prove the effect of MS recommended setting.. I will just have to monitor.

I created a trace, and then exported to sql and now running in the background. However the Duration, CPU, and Memory are all blank... and getting a lot of records...

I found the following on MS site (http://msdn.microsoft.com/en-us/library/ms178067(v=sql.90).aspx)

"Allowing SQL Server to use memory dynamically is recommended; however, you can set the memory options manually and restrict the amount...