Yes. Some of those things get updated also.

One thing that you're forgetting: on a cluster, you have a virtual sql name for each instance. So, I don't think that you have to worry about the named instance...

I think this will do what you're trying to do.

;

WITH CTE AS (

-- first, take the subquery that groups all of the data

SELECT kcfsr_fsi_line.store_number,

...

Okay, let's simplify it just a bit more.

1. Put the data directly into an XML variable, instead of a varchar then converting to XML.

2. Use a CTE instead of a...

Lowell, I'd recommend one change to your code - use the QuoteName() function for...

I'm using VMWare Workstation 6.5. Let me know if you want to see version numbers... I can dig those up tonight.

please post the code of what you've tried.

You would also need to send the results to text (not grid)

either: CHAR(10)

or: CHAR(13) + CHAR(10)

mtillman-921105 (10/25/2010)

Where I'm at right now the current system(s) are in FoxPro. It works. I'm part of the team rewriting the HR part using .NET and SQL Server, we redesigned....

Okay, it looks like I got it working.

What I did:

1. Used the VM Converter tool to copy my base VM to a new VM.

2. Used vmware-vdiskmanager to expand the disk.

3....

Disk Space:

USE [DBA]

GO

/****** Object: StoredProcedure [dbo].[spGet$ServerDriveStatus] Script Date: 10/25/2010 18:51:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spGet$ServerDriveStatus]

AS

/*******************************************************************************

Get an update of the Drive Status on this server.

********************************************************************************

Parameter...

Derrick Smith (10/25/2010)

Agreed...and the whole lack of a...

I have BIDS for both 2005 / 2008 installed, and working fine.

However, I do NOT have both SSMS 2005/2008 installed - I was having issues when one would patch, it...

Senthil T (10/25/2010)

I have this query where I build the where clause dyncamically based on user criteria selection, and return the total number of matches.

SELECT count(*) FROM tblGeneralInfo T1

INNER...

rmechaber (10/25/2010)

WayneS (10/24/2010)