gvalip

Hey I did the following using Sybase database - [code=sql]create table test_cust ( custid int, agentid int ) grant all on test_cust to public create table test_details ( custid int, detailname varchar(15), detailvaue varchar(15) ) grant all on test_details to public [/code] I then inserted records you mentioned above except …

It seems you want to [B]transpose[/B] the column to different row. I understand that the column targeted for transpose is [B]compCapacity[/B] from actual table. In target/resultant table do you already have the value for other columns [B]ProductId and ProductQty[/B].

It looks you have some alpha numeric upper and lower limits. You can look for the pattern of data to create a string and pass it to the query. Another way is to re-phrase the query but I am not too sure of the data and table size. If you …

I did following - [code=sql]create table test_insert_date (field1 datetime not null) grant all on test_insert_date to public create proc usp_test_ins_dt @field1 datetime null as select @field1 insert into test_insert_date values (getdate()) return [/code] After this, I executed the proc as - [icode]usp_test_ins_dt getdate()[/icode] I got error as [B]"Incorrect syntax near …