Can any one of you provide stored procedure for comparing two SQL Server Database Schema or any other way for comparison. SURYA
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...
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...
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...
hi when i try to retrieve stored proc text iam getting some extra spaces, is there any settings for this sp_helptext <spname> SURYA
hi any body can u please send me sp_changeobjectowner and sp_changedbowner as i need change object owner.unfortunately got dropped in my db thanks...
Hi We are planning to migrate from sql server 2000 to 2005. can you please let me know what are the steps to be taken care. Thanks SURYA
Hi, I have table and data has stored firstname , last name UserName ------------------ Rama, Rao Krishna, charan I want to split the first name...
I have table like this sno name ------------ 1 A 1 B 1 C 2 D 2 E 2 F badly I want to show output like this...
Hi, I have data like this, i want to find out the required value. Col1 ---- abcdeff9.9.9.9sadfjkjksd uytuyt1.3.5ughjghjghj jkhjkhjk4.2.5kjjkjkj i...
The qry lists all open Fail trades from x Fails table grouped by CNo and AccNo. The Pair off report displays all open tags that can be paired off...
hi, i have one oracle sp, i need to convert into sqlserver sp. any bdy help..thanks advance the SP look like this. CREATE PROCEDURE Concat_text (...
Transact-SQL Optimization Tips •Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your...
Hi.. Is there any other alternative way for selecting group by records..my qry is taking little bit time for retreiveing records... ex.. select...
hi.. I want to transfer the database from once place to other place.. please... thanks in advance... SURYA
Hi, I have two tables A and B having amount columns, While inserting i have to check the both amount columns, based on the input amount i have to...
Hi. I have a table like this... col1 ---- abc def ghi jkl mno pqr stu -- -- -- upto 40 rows in reporting purpose i want to show the output like...
Congratulations to Satya for (10000-100) posts upto now... SURYA
Hi. I have done update statistics for one table, unfortunately i did the same thing onceagain to that table. Is anything effect that table or not ?...
Hi.. Is there any way to re-write this query. The query is correct one, but i am not able to get the data faster. I am combining the same qry with...
Separate names with a comma.
