SQL Server database programming

Trying to make into function, want to combine the specify project_id to get the result in same row with all the information such as project_name, budget_code_id etc without any repeats. can someone help. thanks in advance. Declare @Full_Name varchar(5000) ...

I have a method (in c#3.0) which loops through all the SPs in a sql05 db and adds them to a tree control.  my problem is that I only have about 100 SP, but it takes for ever because its looping through all the system SPs as ...

I am using sql server 2000 and would like to return only the top 3 values for each group from the data below. Is there anyway to do this? If the square feet is the same, as in loannumber 1, I want to return either ...

hey all, if i had a number like the following: 0.28571 how do i round to .29? thanks, rodchar ...

Hi all, For security reasons, we need to drop all the extended stored procedures from the master database. Does this causes any malfunctioning in SQL server 2K? Any comments is appreciated. Roy ...