Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Asp.net form with a Where Box

    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...

  • RE: Asp.net form with a Where Box

    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...

  • RE: SQL Query to join a column on a row

    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...

  • RE: SQL Query to join a column on a row

    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

    ...

  • RE: SQL Query to join a column on a row

    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...

  • RE: SQL Query to join a column on a row

    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...

  • RE: Tree query help needed

    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(...

  • RE: Tree query help needed

    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...

  • RE: Tree query help needed

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

  • RE: Temp table in a stored proc

    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...

  • RE: join and conditional

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

  • RE: join and conditional

    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...

  • RE: join and conditional

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

    Ryan

Viewing 13 posts - 1 through 13 (of 13 total)