On the bleeding edge of disaster is the place we are going to be I guess! My client has a business application that Ive seen personally from a large software...

It is necessary in this case. I was thinking about a module to parse out all the bad keywords like delete, truncate, ect.. But isn't there a way to use...

Joe C, Im not totally sure about everything you are talking about, but again I have no control over how the data structure is built, I only have control over...

heres what Ive got working good so far...

declare @config table

(

config_id int

,config_name varchar(50)

,config_req int

,config_length varchar(50)

,ctrl_id int

,map_fieldvarchar(50)

,map_dtype varchar(50)

,visible_add int

,min_val int

,max_val int

,is_money int

,mask varchar(50)

)

insert into @config

SELECT

mc.config_id

...

The design is for mapping tables that I have no control over. The config table will do the mapping for me, its a bit of a hack I know. Im...

the config table doesnt have a column named make, the make is a config record on the table. I got this solution to work (http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81585) but I will...

Heres what I have for unlimited children levels...

DECLARE @pid INT SET @pid = 3 --This get the parent you are looking for

DECLARE @Level INT

SET @Level = 1

DECLARE

@Hierarchy_List TABLE(...

I found a solution. Heres what I have....

Heres my table:

id pid name

--------------------------------

1 0 UntID

2 0 Vin Number

3 0 Make

4 3 Model

5 4 Model Number

6 0 Model Year

7 0 Vehicle Type

8...

Not quite the results I need. I need parent child and grandchild to be in separate rows.

I overlooked something. Your sugestion for testing the parms helped me find out that I needed single quotes around the empid when executing the proc. Thanks very much for the...

not too much. I may use the case way since I can add other conditionals to it like empty string checks.

select e.empid, e.ename, count(*) as 'tcount', sum(case when t.resolution is null and t.empid is not null then 1 else 0 end) as 'NULL resolution'

from employee as e

left join tasks as...

Thanks. That was a simpler answer that another I got at another message board. Works great!

Ryan