Yes, try it in the sql you pass into the proc. I use this to mail out two tables--I don't seem to recall this limitation...

Rookie>>

I am not sure about this. My idea would be that you need to have read/write/create/drop permissions to the tempdb. I would start by googling that?

I modified the HTML generating portion of the code to handle column names with spaces and numbers, and also column values with numeric values that might also have null values....

Unless you need to search based on the computed column. Then I would recommend a trigger or an indexed view, depending on how often that table is updated.

You know, I get tripped up here a lot.

Say that you have departments which have budget codes for every budget type reassigned every budget year. You want...

are emp1 and emp2 separate tables?

Otherwise,

Select t.id,

count(*) as EmpCt

from TABLE t

group by t.id

Yeah, I noticed that it wasn't the most efficient SQL I've seen. 🙂 Thanks for the info.

Sentence case with objects treated as proper nouns and any prefixes denoting styles in lower case.

Select wi.WidgetID,

wi.WidgetName

from dbo.WidgetInventory wi

where wi.WidgetID =...

I found this a while back. I'm sure you can google the coder's name and see what terms it's released under.

CREATE FUNCTION [dbo].[fn_SplitAndRemovePunctuation](@s VARCHAR(8000))

returns @out TABLE (wrd ...

My .02:

I prefer option B

1. It's readable. The aliases don't get into the way of the column, which is what I'm really interested in in the Select.

2. I know...