Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Here is my SP
 
  alter PROCEDURE PopulateAllObjectiveQuestionsByTopic
    @TopicID dtid
    as SET NOCOUNT on
 
    begin
       Declare @LevelID varchar(10)
       select @LevelID = substring(@TopicID,1,2)
        declare @SQLString varchar(max)
       select @SQLString = 'select QID,Marks,Question from QBObjective where '+@LevelID+'SubjectID='''+@TopicID+''''
        exec (@SQLString)
    end
 

When i exeute at SQL i'm returning data but not at EF, is there any thing wrong with my SQL or approch
 
When i attach it to a Function Import it is saying "The selected procedure returns no columns", but i'm returning data at MSMQ
Posted 4-Nov-12 21:39pm
Comments
Rohit Shrivastava at 5-Nov-12 15:25pm
   
Instead of executing dynamic query write a static query with param, change to following
 
select QID,Marks,Question from QBObjective where CASE WHEN @LevelID = 1 THEN 1SubjectID
WHEN @LevelID=2 THEN 2SubjectID
END = @TopicID
 
I am sure you have limited number of Level as these are referring columns.
snsrkrishna at 6-Nov-12 13:38pm
   
thank you, working

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Placing answer from comments:
 
Quote:
Instead of executing dynamic query write a static query with param, change to following
 
select QID,Marks,Question from QBObjective where CASE WHEN @LevelID = 1 THEN 1SubjectID
WHEN @LevelID=2 THEN 2SubjectID
END = @TopicID
 
I am sure you have limited number of Level as these are referring columns.

 
Thanks
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 390
1 Sergey Alexandrovich Kryukov 329
2 BillWoodruff 210
3 Afzaal Ahmad Zeeshan 204
4 CPallini 185
0 OriginalGriff 5,515
1 DamithSL 4,451
2 Maciej Los 3,902
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,175


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100