Hello Again,

The Print works marvels! I really liked debugging this way. I almost got the Stored Proc to run. However I have an error here which I...

Hey Kenneth you are perfectly right

The Print statement was not printing out since i was never getting to it, cause there was an error.

Now i am printing an if statement...

Hi Kenneth, first of all thanks for you suggestion........I will change all the code of the stored prroc.

however, as I said before, when i use the Print Statement, all I...

Hi Kathi again

I am trying to use the Debugger in SQL Query Analizer, however when i do Debug on a Stored Proc, the following error crops up:-

SP debugging may not...

Thanks Kathi for your reply

I will try to get accustomed with the Debugger then and try to figure out what the problem is

Thanks again

Hello Kathi again,

I changed all instances of "" to '' and when i ran the stored proc, all i got was

Stored Procedure: johanndb.dbo.GetImageByCriteria

Return Code = 0

How come I am not...

I have modified my stored proc like this to cater for nulls :-

CREATE PROC GetImageByCriteria

(@inputDate ...

ok Jeff, thanks very much for your help

I am using the Enterprise Manager to build the database. Basically I want to store image's width and height in these fields, so a value of less than 2000...

Yeah sure!

This forum seems to be really cool, and I will have more questions I can assure you

Thanks again Kathi

oh thanks very much Kathi. I appreciate your help a lot! Learned something new

Hi Kathi

I tried coming up with something like the article you suggested, however, for my present knowledge, I found it quite hard to follow. So i decided to go...

Hello

I came up with this stored proc :-

----------------------------------------------------------------------------------------

CREATE PROC GetImageByCriteria

(@inputDate ...

ok thanks i will take a look at this article