Click here to Skip to main content
11,639,554 members (62,471 online)
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 20: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 Suvendu Shekhar Giri 330
1 Sergey Alexandrovich Kryukov 259
2 CPallini 177
3 himanshu agarwal 167
4 F-ES Sitecore 160
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,812
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,548


Advertise | Privacy | Mobile
Web01 | 2.8.150731.1 | Last Updated 6 Nov 2012
Copyright © CodeProject, 1999-2015
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