Hi
You try with the following query
SELECT name1, name2 FROM customers
WHERE charindex("SALLY",name1+" "+name2)!=0
I think it will sreve your purpose
Gopal
:-)
Hi
Yes there is a way to make it work
we have dynamic SQL feature provided by sybase
what you have to do is, assign the whole select statement
to a string variable say @exe_str
select @exe_str ="Select * From "+@TblNme
Then use this command to execute the statement in @exe_str...
Hi,
If there is any primary key for the temporary table, specify it.
like this
create table #tempTrans
(
RecId integer not null primary key,
SeqNo smallint not null,
CustAmount numeric(18,5) null,
CustQuantity numeric(18,5) null
)
while using cursors it is suggested to delcare primary key...
Hi
What I do to debug stored procedure is to run each individual statement/block seperate in editor and see the results for each run. Once the statement/block is executed then process on to next statement/block in the sp
definetly we will find where exatly we are going out of the box with the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.