I learned from Advanced TSQL (ben-gan,moreau): http://www.apress.com/book/bookDisplay.html?bID=72

You can select the results of a proc into another proc (see BOL: exec). You can also return a valid parameter from a proc as an output parameter but table...

If you are going to use a subquery the "with rollup" is unnecessary. But you do need another aggregate 😉

select sum(x.gt)

from (

...

Take out the columns in the select. You need them in the group by but you are not required to return them. Also your distinct is redundant with the group...

As long as you are exporting to the same file that should work.

SELECT MediaNewsId, MediaNewsHeadline, MediaNewsReleaseDate, MediaNewsBody

FROM CC_MediaNews

WHERE PublishOnIntra = Case when @readonly = 1 then 1 else PublishOnIntra end

and StoryStatus = 4

...

I love Mac. They are pretty, work well and the interface just makes sense. Everytime I use one even if it is for a minute or two I miss it....

Anytime I wanted to format sql data in Excel I transformed it to xml and wrote a stylesheet. Lot of gotchas around xml and a learning curve though so for...

I like sage (plugin for Firefox) but I don't have much to compare it to.

I like pluck - the folder set up is good and it's a web app....

On intelisence... Ultraedit has a form of intellisence and you can pretty easily edit the source file. I still use it over management studio (for a lot of reasons:-). ...

there is no reason to have month and yr tables. these values can be calculated other ways. Simply have a date column in the sale table. things like 'sale by...

line numbers are on the bottom of the screen. there is no way to display them on the side but ctrl-g will get you there.

i have never seen anyway...

it seems you cannot reference a udf in a computed col from any other database not just tempdb. You would have to create the function in tempdb.

i.e - this...

yes because the nvarchar is limited to 4000. exec is not limited this way and you can join multiple variables. i.e - exec @sql+@sql etc.

Dbcc traceon(257)

For the session...this will format the results for QA screen.