Database

Use TCP/IP Provider instead of named pipes. Regards, Aman

try something like this - I have to assume that userid appears in table3 also, therwise this is no way to join them select isnull(first_name,' '), [money deposited] from table1 t1 left outer join table2 t2 on t2.userid = t1.userid Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Thanks! Regards, Hulicat

select isnull(column,'N/A') from tablename where column='condition' Hope this will help you. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[deleted] Got it working! Bascilly deleted it and started again and managed to get it working from the advice you both gave (Wrapping the case in a sum and removing Workunittypeid from the top level group by). Thanks for the help - first and last stored procedure I attempt :laugh: modified on Thursday, August 6, 2009 5:45 AM

David, see my reply to Mike...

I had not heard of a cold backup before but there is plenty of resource[^] out there pertaining to this subject. Never underestimate the power of human stupidity RAH

Thank u 4 your post. I fixed my problem..Thank u all... CheeN

Try googling for Sql Server 2005 DTS

Hi David Skelly, for this problem can we use table partition method. will it help me to solve the problem. Thanks & Regards, Prakash

just remove column name in order by clause simly place column index . Tauseef A Khan MCP Dotnet framework 2.0.

This is a new table that I insert record in it and yes I am sure there are records and i am sure that my query is OK. I just need to know how to config the column that store hebrew characters to get abiility for query on it Shay Noy

Instead using four single quotes then use CHAR(39) set @sql=@sql+'update tbl_swbom_checklist_testers set '+@COLUMN+'='+CHAR(39)+@VALUE+CHAR(39) set @sql=@sql+' where tester='+CHAR(39)+convert(nvarchar(100),@tester)+CHAR(39)+' and package='+CHAR(39)+convert(nvarchar(255),@package)+CHAR(39) Hope this helepd you. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com modified on Tuesday, August 4, 2009 11:56 AM

Great thanks. dev

Oracle (PL-SQL) doesn't have temporary tables in the same way as SQL Server (T-SQL). Read up about Oracle Global Temporary Tables. These work in a different way from SQL Server #temp tables, but give you the same end result.

Thanks! If found this one [^] and several others [^]. But seem to have no match :-( Anyway, I keep searching for a match :-) • My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now!

Good day Satish Becacause of time i have, i will not write you a solution , but i will point to a problem First you use one variable to do all things. Why do you create one variable that will hold the SQl statement and one to store the results and evauate the result. i think you know what you are doing but you get confused by your code. declare another variable to hold the results after that you must test for only nulls and remove the quotes and try it like this DECLARE @Result VARCHAR(MAX) DECLARE @Final_Res VARCHAR(MAX) Set @Result = (SELECT TOP 1 WITH TIES theCol FROM (SELECT * FROM Tbl_Origin WHERE Zip_Final =@Zipcode ) AS t1 UNPIVOT (theValue FOR theCol IN (@Querystr)) AS u1 ORDER BY theValue DESC) IF @Result IS NULL Set @Result = 'Select Top 1 theCol from Tbl_Origin' else select @Result Hope this Helps Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/