How about Visual Studio Team Suite 2005 / 2008...?

I have tried Visual Studio Team Suite 2008, and it is very handy for the SQL developers.

BUT Its Not Free...

One cannot execute sp in s SELECT Statement.

Can you change the SP into Function?

if yes, than it is possible to do it in the SELECT Statement.

Otherwise, CURSORS...

Why not to keep it as a seperate file on OS. If the SP is unusable, it should not be in the database.

Not in SQL Server, and not in any other RDBMS (I think...)

This script will help you...

CREATE TABLE [dbo].[MyDir] (

[Dir] varchar(255)

)

GO

TRUNCATE TABLE MyDir

DECLARE @cmd varchar(4000)

SELECT @cmd = 'Dir c:\*.*'

INSERT INTO MyDir(dir)

EXEC master..xp_cmdshell @cmd

SELECT ...

In my opinion, it all depends upon the experiences. Ones own experience and also of the closed ones (friends, co-workers, etc...).

Most of trhe people (including myself) thinks that the...

On seeing the question, i thought there might be a Default Order of the result set returned by the query without the order by clause. But after a research, I...

Try This...

Declare @edTime varchar(1000)

Declare @vTotTime int

-- Specify your End Biz hours Time here.

-- This time will join with each date to get the time difference for the specifies date

Set...

There is also a limitation on Index Size. AN index will not be created on the column greater than 900 bytes. Full text Search will be better option.

GR8

Check Event Log... you might get something from there...

There are many reasons of this error, print statements, wrong parameter settings, etc. But as for your scenario, i think it is...

I think repharasing the question would be a better thing to do. I have given you a query, but still i am not sure about the requirement.

Are you using Domain Accounts for Windows Authentication?

If yes, remove 'Builtin\Administrators' from security and add each Domain Acocunt with proper permissions.

And if the users are accessing SQL Server directly from...

Try This...

with wcte as (

Select ilr.person_code,

ilr.unique_ilr_id,

ilr.student_name,

ilr.forename,

ilr.surname,

ilr.middle_names,

ilr.person_code,

ilr.unique_learn_no,

ilr.sex,

ilr.date_of_birth,

ilr.ni_number,

ilr.student_address_1,

ilr.student_address_2,

ilr.student_address_3,

ilr.student_address_4,

ilr.student_Pcode_1,

ilr.student_Pcode_2,

ilr.telephone,

ilr.telephone_line_2,

ilr.email_address,

ilr.mobile_phone_number,

ilr.disability,

ilr.ethnicity,

RNO as Row_Number() Over (Partition By ilr.person_code Order By ilr.person_code)

FROM wce_ilr ilr

) Select * from wcte where RNO = 1

The distinct Applies to all the Columns in the Select List.

In case of "One column", on which column are you trying...