Hi Rajendra, Before answering your question, I would like to know how often do you fire this query. Thanks Murthy Rajendra Prasad <rajendraprasad_t@...>...
How to concatenate all values of column to a row ? USE pubs GO DECLARE @title_ids varchar(150), @delimiter char SET @delimiter = ',' SELECT @title_ids =...
90
Rajendra Prasad
rajendraprasad_t@...
Apr 2, 2004 9:25 am
Hi Muthry, Thanks for your reply. The Query gets fired in a job which populates the tables from flat files. I need to link up the records to their related...
Hi all, I got following error in a box when executed a distributed query testprocs is a Store procedure which contain a simple SELECT QUERY. When I execute...
Hi Baleshwar are you using a loopback Link server? From Bol Loopback linked servers cannot be used in a distributed transaction. Attempting a distributed query...
Finding the number of days in the current month: SELECT DAY(DATEADD(d, -DAY(DATEADD(m,1,getDate())),DATEADD(m,1,getDate()))) This query can be altered to find...
Hi Rajendra, This we cann't achieve at one go. You have to make use of all the options that you have and then you have to apply the best which fits. Please...
Hi, While i am running a sql Procedure i am getting the following error. Error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (WrapperRead()). ...
Strange behavior of views.. Some of you must know this already.. just incase if you have never come across.. Use pubs Go create table rl_t1 (id int) go insert...
That is expected behavior, because view is an object with structure defined during creation (precompiled) alter the view and try again that will display two...
Hi Anand, Is this error occuring only when u run that particular stored procedure? If yes, can u tell us what r doing with that storedproc. Also, try...
Hi Anjana, Thanks for your timely help. This error occurs when run this procedure and another scrub which uses cursor to process more than 20000 records. These...
Hi Anjana, Thanks for your help and quick response. This error occurs when i run this procedure and another one scrub. That scrub uses cursor to process the...
Hi Anand, Actually the problem is MDAC 2.8. There is a patch available for this. This problem occurs when SQLserver used Named Pipe library rather then tcp/ip....
Hi, Pls anybody tell me how can i become an MVP __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! ...
Hi, Our MVPs here would defenetely be answering such FAQs and soon we would have them in the FAQ section of Sqlcon. But till then you can check this article...
106
Rajendra Prasad
rajendraprasad_t@...
Apr 6, 2004 10:45 am
Hi All, I am facing a problem in writing an SQL Server code. I want to have an XML File as error log. what is the best way of writing the same, with out using...
Dear All, If I execute 'SELECT @@Version', I'll get service pack version number, but where does SQL Server stores this number? Also, where can I find which...
SQL will use xp_msver extended stored proc to get info from OS. ________________________________ From: Mohammed Zaheer Khan (Satyam Computer Services) ...
One way to prevent deadlocks. One way of preventing deadlocks is to try to access the resources in all the transactions in the same order. For example: See the...
Hi, There are different ways to do the same..I will mail you a nice documentation on same by tonight.... If anyone has any good ideas about it..please reply as...
Ue the following script :- SET NOCOUNT ON GO USE master IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'wages') DROP TABLE...
I don't see anything wrong in that. I have seen the same example in SQL Transaction Help for Coalesce. The expected result for 5th row is 104000 i.e. 50*40*52....
The problem is that all four columns allow NULL values. The COALESCE function returns the first nonnull expression. The following COALESCE statement produces...
Usage of operators The speed of the query also depends on the operators used in the where clause. Key operators used in the WHERE clause, ordered by their...
117
Rajendra Prasad
rajendraprasad_t@...
Apr 8, 2004 4:16 am
Hi Murthy, Thanks a lot. I would work on those lines and get back to u. Pls provide me your inputs also. Regards, Rajendra. ... options that you have and then...
