Can any one of you provide stored procedure for comparing two SQL Server Database Schema or any other way for comparison. SURYA
for example i will pass the @value=01 (us dollar), @from_cur='USD' and @to_cur='INR' now i wanna show dollar in indian currency (using conversion...
Hi, I would like to know, any body have currency conversion stored procedure, please post me. for ex: dollar to euro..vice versa..etc.. thanks in...
thanks KH. SURYA
The Rules are: 01. Only two records should be consider 02. one record shld be start with EU 03. one record shld contain -ve value(ex: -1000) and...
table strcture and sample data ACNo Name QTY ============= B0 "XYZ" 927 B0 "EU" -4237 ZX "ABC" 100 ZX "DEN" 200 ZX "EU" 300 OF "AC" 100 OF "DG"...
Hi I have table i need to identify one record qty column shld be -ve value and another one is shld be +ve value ? One record name shld be starts...
accountno(unique field records) SURYA
thanks KH. input table i have many records.i pasted only one acno records. records also some times may vary. untill the qty equal or lessthan to -ve...
hi one of the requirement i want to store ouput as below,any bdy can help..thanks data: ===== Name qty ------------ GER 100 FRA 250 FEA...
yes both scenarios are different SURYA
quote:Originally posted by Madhivanan << madhi: can u please give me the correct syntax of set result mode >> When you use QA, press Control+T and...
not meet the requirement.. SURYA
yes iam using sql server 2005 SURYA
quote:Originally posted by Roji. P. Thomas You can also try SELECT OBJECT_DEFINITION(OBJCECT_ID('YourprocName')) Roji. P. Thomas...
hi thomas i am getting the 255 charcters only..one row only..im not getting the total sp text.. madhi: can u please give me the correct syntax of...
this code is from sp only. see the problem the quote is coming next line, so while compiling iam getting the errors Case "RTF" 'Word Document '...
see the problem below, after getting the text when i recompile the sp, its giving errors Case "Excel" ''For exporting into Excel...
hi when i try to retrieve stored proc text iam getting some extra spaces, is there any settings for this sp_helptext <spname> SURYA
thanks a lot dinesh SURYA
Separate names with a comma.
