Ravi, You cannot use the T-SQL CASE to achieve the behaviour of Switch or SELECT CASE in other languages. In T-SQL CASE is an expression, not a statement. Also...
Ravi, If executing the proc based on a variable value is your intention ..... have a look at this code segment. declare @sql varchar(100) , @your_variable int...
Hi, How can i determine the space used by a column of a table in sql server. What the proces to know the space used by a null values in a column of a table . I...
Hi Guys, I have a scenario, in which I have to optimise a stored procedure,which deletes unwated data. There are 2 table like parent child(but no referential ...
Hi Santosh first of all, tell me please why you select record key into temp table????? do you have similiar column into both parents and child table? if yes ...
Hi, thanks for your mail. It is a legacy code and im optimising it.We have proper index in the table. The problem is the high traffic. As I said around 10000 ...
Hi guys, The below part is the where condition of a query is there any alternate way to compare that directly (We store the created date as datetime but while ...
Sorry guys, my full question is below The below part is the where condition of a query is there any alternate way to compare that directly (We store the...
Hi Santhosh, Try this DATEDIFF(hour, cast(createdate,datetime) = cast('12/12/2005 1:00 PM',datetime)) = 0 Hope this works for you. Regards, Raj Santhosh...
hi santhosh... its always better to format the date in the format of yyyymmddhh and then make the comaprison...you can use the convert function for this...
Hi Santhosh, Declare @dDate as DateTime Set @dDate = convert(DateTime, 'YYYY-MM-DD HH:00:00') -- Your choice of date with Minutes and seconds as "00" Select...
hi group i am getting most of calls sqlserver with IIS admin can any body give url or suggest any good books Thanks dilip ... Yahoo! India Matrimony: Find your...
Hi Comparing the data of the same table. Let me explain the same in more detail Typical customer table looks to Cust_ref ( Employee id) Cust_dept_id (may...
Lakshmi N Patwari
lpatwari@...
Oct 5, 2005 1:13 pm
1512
Hi Use the below query with appropriate actual field names Select distinct a.* from customer a, customer b where a.Cust_ref=b.Cust_ref and a.cust_deptid<>...
Hi, I have a query like insert into table1 select * from table2 order by col1 where col1 is a cluster index. according to my view there is no need of the order...
Theoretically I cant see any performance gain because of this...unless proved otherwise by any realtive querry performance Statistics... I would suggest just...
Well it is checksum question... I would suggest we are soon going to have launch seminars of SQL 2005 across India . We will announce about the events here in...
hi, where do i find sep CTP.(i'm new to this group) Thanks and Regards, Sudheer.K __________________________________ Yahoo! Mail - PC Magazine Editors' Choice...
Santhosh, We can visualize two scenarios here. 1. Table1 has Clustered index on the same column col1 Including Order By should improve the performance in this...
Can someone guide me how I can restore a SQL Light Speed version of a BackUp (.sls) file to a SQL Server 2000 database? Thanks in advance Senthil T R ... ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
