Hi Jacaob, I am facing problem while inserting data into table as order of files read from text file is changing some times, i.e., reading from text file through Stream Reader and again using split option and adding row to datatable and inserting to tab...

Hi Jacaob, I am facing problem while inserting data into table as order of files read from text file is changing some times, i.e., reading from text file through Stream Reader and again using split option and adding row to datatable and inserting to ta...

Hello RamiReddy , thanks for your reply but it will work when executed directly. But when i pass those id and amount as parameter to function then it returns the value not the max. Please refer the function mentioned in posted question. thanks, A...

Hi Jacob, I wanted to retrieva Max of particular column from table. For instance , Table has two columns as shown below Create table Max_A(id int, amount money) Values are in these form..... ---------------------------------------------...

Hi Jacob, I wanted to retrieva Max of particular column from table. For instance , Table has two columns as shown below Create table Max_A(id int, amount money) Values are in these form..... --------------------------------------------- ID ...

Yes Jacob, Error Message is displayed in Message Tab, but i want it to assign it to a variable that it what i am not able to do....

Thanks Sanjay for the reply. No if you go through my previous replies you you can understand what i am trying to assign to a variable. I dont find that error message in Error Log of SP_READERRORLOG System defined SP....

CREATE TABLE #ErrorLog ( SrNo INT IDENTITY(1,1) NOT NULL , LOGDATE DATETIME, ContinuationRow VARCHAR(255) NOT NULL , ErrorLogText VARCHAR(8000) NOT NULL ) INSERT IN...

Yeah the second one. i mean not able to assign to a varible but the condition is that i dont want to use try catch...

Thanks for reply Jacob. Actually i was able to grab error through Try Catch using Error_Message() system defined function . But i wat to grab this kind of error messages without try catch through scripting. So there a table with column not null an...