Choose CUSTOM INSTALL. The latter part of the installation allows you to specify these options.

Placing the CLUSTERED index on the Date column would be better that on the varchar column for DML commands but this is not my advice. First, why would you need...

try using IP for \\SR071025

..can't wait to see Ninja get in this...

This part is wrong (syntax)..

inner join full_address_indexed2 fav

on

paf.new_postcode = fav.

It can be a Marketing Scheme from a company with lots of clients. I was approched by Ford once for such a task. But In their case, the wanted to...

Use

BEGIN DISTRIBUTED TRAN

COMMIT DISTRIBUTED TRAN

Hey Nic, how about posting the DDLs of them views?

SELECT system_user

Dan,

1. Do you want all these aggregates in one resultset? What format?

2. Is the PLAYER_ACTIVE column a char(1)? Why not a bit? What are the possible values in...

Amen!

What if you have more columns? Will you be Altering the procedure each time you want to pass another column name?

Try this..

Alter PROCEDURE [dbo].[Get_TableValues]

@Value as varchar (100)

AS

EXEC ('Select Distinct ' + @Value +...

I f there are multiple payments made by a single insurance company to the same patient, you might need to sum up the PayAmount first.

SELECT PID, Payor, SUM(PayAmount) into #Table2

from...

we need more info here. what is the schema of your table. what do you mean when you say variable?

Create Table #dbnames(db varchar(50))

Declare @dbname varchar(50)

declare dbases cursor for

select name from master..sysdatabases

Open dbases

fetch next from dbases

into @dbname

while @@fetch_status = 0

begin

 print 'select top 1 ''' + @dbname + ''' from...