Comments by vemsoft - CodeProject

vemsoft 28-May-15 0:55am View

Thanks for your answer, In our example we are using CCES tool for executing the code and when i am writting c functions in assembly code it shows error can you plese tell me how to solve the error

vemsoft 22-May-15 0:59am View

i am using three architecture and getting thar status in data datble........
please help me how to compare tha status and display message "record already exist..."

vemsoft 19-May-15 2:52am View

yes i have column name component....here yhe user selects component...thats why i passed component=@component in where condition....

vemsoft 15-May-15 2:37am View

@component varchar(50)
declare @var varchar(100)
select @var = stringval from @output where(substring(stringval,1,10)=@subcompname)

select sno, @var as stringval, iRnumber, Drawingnumber from iRnumber where subcompname like '%' + @var + ',%' and component=@component

hai kamlesh when iam passing component in the above query iam not getting this...
please help me.........

vemsoft 13-May-15 7:50am View

Thank u.......kamlesh.its working....i added comma in the end

vemsoft 13-May-15 5:45am View

sno subcompname iRnumber Drawingnumber
1 c1,c2,c123 001 1

2 c200,c444,c555 002 2

3 c777,c878,c999 003 3

if i enter c1 iam getting but when i enter c123 iam not getting

vemsoft 13-May-15 3:22am View

here iam getting duplicate values.....when user enters 'c1' this query is retrieving c1,c122.c1422,c1000 etc......

i want only c1.

vemsoft 12-May-15 7:24am View

there exist IRNUMBER table and irnumber and drawing number columns in that table...........

vemsoft 12-May-15 6:56am View

at present iam getting only subcompname..using this procedure i want irnumber and drawingnumber in this procedure

vemsoft 5-May-15 8:54am View

please help me with query...........

vemsoft 5-May-15 8:54am View

please help me with query...iam new to procedures

vemsoft 4-May-15 5:58am View

here i want query to find c50 between c1 to c100................
thanks for your suggestion

Comments by vemsoft (Top 12 by date)