Not version. I gave already right.

Actually, I want to get these information using C#.Net. I don't know how to get in SQL Server 2005. That's y I asked. Now...

Let me first explain my scenario clearly. Because,U understood wrongly.:P

I want to retrieve the following information from SQL Server 2005.

1. Release version as "SQL Server 2005"

2. Number of servers available...

Hi,

U can use RowID property to delete the duplicate records, I think.

Hi,

First, check your select query with temp table whether it's giving your expected output or not. Then you try with Stored Procedure. Otherwise, send us the clear definition of your...

Hi,

You can use without using that variable also.

select distinct

case

when min(de.ModifiedDate) > min(em.HireDate) then min(em.HireDate)

else min(de.ModifiedDate)

end

from HumanResources.Department as de,HumanResources.Employee as em

Let me know, If you are still having...

Try this. It will give you the min date. But I tried this in SQL Server 2005. You change this to SQL Server 2000.

Actually, I have displayed the minimum date...

I think,the data you deleted with DELETE query is not matched with the function definition.

Preetha SG

Have you created any function, stored procedure, trigger or Constraint for that table. If you have created any of the above for primary key, then also it will give problem.

Preetha...

Hi,

Sometimes it won't include the dates specified in between clause. So better use like this, j.dtTransaction >= @FromDate and j.dtTransaction < @ToDate

Please give us some sample input data. Let...

Hi John,

I tried your query. It's giving the correct output. The output is starting with 0 only, If the id is starting with 1. If it is starting with 0,...

You can use ISNULL() to do this.

For example,select ISNULL(Value, 0) , ISNULL(Description,0) from @Table

We used only Table-valued and Scalar-valued functions for our testing. I can't able to tell more than this, I think. SORRY.

Hi,

First, we have created stored procedure and function in T-SQL for our project. Then we do the same in CLR. Then, based on different datasets (that means,...

Hi,

Thanks for your interest.

We completed the test and we sent the report that T-SQL is better than CLR for both scalar-valued and table-valued functions.

Best regards,

Preetha S

Hi,

Actually, I just wants to test the performance of T-SQL and CLR and i have to report that. I already read that T-SQL is faster than CLR. But...