Post reply

Confused on parameter in a Where clause

  • April 25, 2019 at 7:02 pm

    #3536811

    i am using the below  code:

    I tried using PD_ID IN (@Part) but SSRS still bombs.

    @Part can be multiple parts

    thoughts?


    if object_id('TEMPDB..#temp1') is not null
    drop table #temp1;

    select * into #temp1 from
    (select distinct
    [PD_ID]
    , [LIKE_PD_ID]
    , [FLAT_LIKE_PD_ID]
    , [FLAT_PD_ID]
    from 
    [ADHOC].[FORD_PDLINK] P
    where
    PD_ID = @Part
    ) as test
    select * from #temp1

  • April 25, 2019 at 7:04 pm

    This was removed by the editor as SPAM

  • April 25, 2019 at 7:06 pm

    #3536820

    Of course once i asked for help, it started working with IN . . . thanks, sorry

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply