Viewing 15 posts - 76 through 90 (of 99 total)
I get only the parameter list on the left. but the matching expression on the right side is not found in the navigation tab.
Thanks for reply.
April 28, 2010 at 6:01 am
Hi Mithun,
Thanks for the reply. Yes that was the mistake. I finally resolved this.
Thanks for all the experts who helped me 🙂
April 26, 2010 at 10:37 pm
Oh sorry. You are right. I am not executing that query. How to do that? Should i print that parameters agian?
Now how to get the result set?
April 25, 2010 at 11:07 pm
Hi,
Thanks for your reply. That link helped. But i am not getting desired o/p.
Following the method mentioned in the link, i tried writing this:
ALTER PROCEDURE [dbo].[sp_TEMP_TLCOMSSearchCand] (@CandID varchar(50) =...
April 25, 2010 at 10:40 pm
the CandID column is unique. My prob is the user may search by entering any key word. He may give only one or a combination of parameters.
My SP must...
April 25, 2010 at 9:32 am
The client DB has that column in INT.
We must store as NVARCHAR.
So, the INT value 10 should be stored as NVARCHAR "00:10"
April 23, 2010 at 3:44 am
Sorry it was a MINOR ERROR. I have corrected it.
Thanks for the code 🙂
April 21, 2010 at 5:28 am
Sorry it was a MINOR ERROR. I have corrected it.
Thanks for the code 🙂
April 21, 2010 at 5:28 am
Hi,
Thanks for the reply. but this is giving error. I think my SP has some prob.
Could you pls chk that and let me know?
ALTER PROC sp_TLCOMSCandExpertiseArea (@CandID varchar(50),@ExpertiseArea bigint,@var smallint...
April 21, 2010 at 5:25 am
Hi,
I tried but it is asking me to decalre @var !
it is coming from proc, y shud i decalre again?
April 21, 2010 at 4:15 am
Hi All,
Now that the SP has no error, i have a small doubt regarding its execution.
I have a @var parameter which is a output parameter.
it should return 0 or 1...
April 21, 2010 at 3:03 am
Thanks Gianluca,
I am new to this SQL Server procs and was really unable to find out the error. Thanks a lot!
April 21, 2010 at 1:57 am
I solved it. I was passing @CandID in the where cond. That was passing null.
Thanks.
April 21, 2010 at 12:36 am
The query executes but the second and third insertions are not happening.
but it is not showing any error. Please help
April 20, 2010 at 11:18 pm
Viewing 15 posts - 76 through 90 (of 99 total)