Can any one of you provide stored procedure for comparing two SQL Server Database Schema or any other way for comparison.
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...
I would like to know, any body have currency conversion stored procedure, please post me.
for ex: dollar to euro..vice versa..etc..
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
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)
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...
one of the requirement i want to store ouput as below,any bdy can help..thanks
yes both scenarios are different
quote:Originally posted by Madhivanan
can u please give me the correct syntax of set result mode
When you use QA, press Control+T and...
not meet the requirement..
yes iam using sql server 2005
quote:Originally posted by Roji. P. Thomas
You can also try
Roji. P. Thomas...
i am getting the 255 charcters only..one row only..im not getting the total sp text..
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
thanks a lot dinesh
Separate names with a comma.