August 6, 2008 at 6:44 am
I think it shoyld be the temp table?
Update s
Set N = s.ID + 1 - sg.MinID
From #Serverstemp8 s
Join (Select #Serverstemp8.Name, ID, Min(ID) as MinID From #Serverstemp8 Group By #Serverstemp8.Name,ID) sg
ON s.ID = sg.ID
but it still only show the first result from the logical disk table... and 2 and 3 are all NULL..
August 6, 2008 at 6:50 am
We're going to need the table defs and some sample data to take this any further. Please see this article for guidelines on providing this:http://www.sqlservercentral.com/articles/Best+Practices/61537/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 6, 2008 at 7:11 am
Sure 🙂
I'm not sure how to create a INSERT script with pre-data..
but its simple, I use Name and productKey from devices, and DeviceKey is the relation key
in CIM_logicalDisk I want to Join values from Description, WIN32_Size and dc_SpaceUsed and here is NodeID the realation key to devices.
is this any better!? 🙂
Create logical disk table
/****** Object: Table [dbo].[CIM_LogicalDisk] Script Date: 08/06/2008 15:12:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CIM_LogicalDisk](
[LogicalDisk_LUID] [bigint] NOT NULL,
[NodeID] [bigint] NOT NULL,
[SnapshotID] [bigint] NOT NULL,
[DeviceID] [nvarchar](64) NOT NULL,
[CreationClassName] [nvarchar](256) NOT NULL,
[SystemCreationClassName] [nvarchar](256) NOT NULL,
[SystemName] [nvarchar](256) NOT NULL,
[Win32_FreeSpace] [bigint] NULL,
[Win32_Size] [bigint] NULL,
[Description] [nvarchar](512) NULL,
[R_SizeMB] [nvarchar](256) NULL,
[R_UsedMB] [nvarchar](256) NULL,
[R_UsedPercent] [nvarchar](256) NULL,
[dc_SpaceUsed] [bigint] NULL,
[dc_PercentSpaceUsed] [int] NULL,
[BlockSize] [bigint] NULL,
[NumberOfBlocks] [bigint] NULL,
CONSTRAINT [CIM_LogicalDisk_PK] PRIMARY KEY CLUSTERED
(
[LogicalDisk_LUID] ASC,
[NodeID] ASC,
[SnapshotID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
create device table:
/****** Object: Table [dbo].[devices] Script Date: 08/06/2008 15:14:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[devices](
[DeviceKey] [int] NOT NULL CONSTRAINT [DF_devices_DeviceKey_1__13] DEFAULT (0),
[Name] [char](256) NULL CONSTRAINT [DF_devices_Name_7__13] DEFAULT (' '),
[GUID] [varchar](128) NOT NULL CONSTRAINT [DF_devices_GUID_3__13] DEFAULT (' '),
[Discovered] [bigint] NOT NULL CONSTRAINT [DF_devices_Discovered_2__13] DEFAULT (0),
[ProductSubType] [char](32) NOT NULL CONSTRAINT [DF__devices__Product__733F3813] DEFAULT (' '),
[OverallStatus] [int] NOT NULL CONSTRAINT [DF_devices_OverallStatus_1__20] DEFAULT (10),
[ProductType] [int] NOT NULL CONSTRAINT [DF_devices_ProductType_1__20] DEFAULT (0),
[ProductTypeStr] [char](32) NOT NULL CONSTRAINT [DF__devices__Product__761BA4BE] DEFAULT (' '),
[ProductName] [nchar](100) NOT NULL,
[timestamp] [bigint] NOT NULL CONSTRAINT [DF__devices__timesta__770FC8F7] DEFAULT (0),
[LockFlags] [int] NOT NULL CONSTRAINT [DF__devices__LockFla__7803ED30] DEFAULT (0),
[fullDNSName] [varchar](256) NULL,
[MxGUID] [char](32) NULL,
[discoveredName] [nvarchar](256) NOT NULL DEFAULT (''),
[durableName] [nvarchar](256) NOT NULL DEFAULT (''),
[wwName] [nvarchar](256) NOT NULL DEFAULT (''),
[subType2] [char](32) NOT NULL DEFAULT (''),
[subType3] [char](32) NOT NULL DEFAULT (''),
[subType4] [char](32) NOT NULL DEFAULT (''),
[subType5] [char](32) NOT NULL DEFAULT (''),
[subType6] [char](32) NOT NULL DEFAULT (''),
[subType7] [char](32) NOT NULL DEFAULT (''),
[subType8] [char](32) NOT NULL DEFAULT (''),
[nodeLuid] [bigint] NULL,
[uniqueIdentifier] [varchar](256) NULL,
CONSTRAINT [PK___5__11] PRIMARY KEY CLUSTERED
(
[DeviceKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
August 6, 2008 at 8:32 am
tgh (8/6/2008)
I'm not sure how to create a INSERT script with pre-data..
I really need some sample data, to see what's going on for you. Please execute the following commands with your outputs set to Text Mode and post the results here:
Select top 8
'INSERT Into dbo.devices Select '
DeviceKey
, ', '''+Name+''', '
, ProductType
, ', '''+ProductTypeStr+''''
, ', '''+ProductName+''''
From dbo.devices
Select 'INSERT Into dbo.CIM_LogicalDisk Select '
, LogicalDisk_LUID
, NodeID ,', '
, SnapshotID ,', '
, DeviceID +', '
, ''''+SystemName+'''' +', '
, Win32_Size ,', '
, ''''+[Description]+'''' +', '
, dc_SpaceUsed
From dbo.CIM_LogicalDisk
Where NodeID IN(Select top 8 DeviceKey From dbo.devices)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 6, 2008 at 9:41 am
This is what I got! I took some more, to actually have an output in devices 😀
DeviceKey ProductType
------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------------------------ --------------------------------------------------------------------------------------------------------
INSERT Into dbo.devices Select , 'sgtsc-mgnt-04 1 , 'Server ' , ' '
INSERT Into dbo.devices Select , 'im_ilo00dp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00crmsql01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00exfe01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00crmapp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00dcfp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00aos01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00aos02 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00aos03 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00web01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00job01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00daxweb01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00nav01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00spp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_ilo00ts02 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select , 'im_srv00exfe01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select , 'im_srv00crmsql01 1 , 'Server ' , 'ProLiant BL480c G1 '
INSERT Into dbo.devices Select , 'im_srv00dp01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select , 'im_srv00crmapp01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select , 'im_srv00dcfp01 1 , 'Server ' , 'ProLiant BL460c G1 '
(20 row(s) affected)
LogicalDisk_LUID NodeID SnapshotID Win32_Size dc_SpaceUsed
--------------------------------------- -------------------- -------------------- ---- -------------------- ---- ------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- ---- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------
INSERT Into dbo.CIM_LogicalDisk Select 2190433330671 64 , -1 , Logical Disk 0, 'im_srv00exfe01.sgtsc.local', 36376150016 , 'C:\ [:NTFS]', 9155117056
INSERT Into dbo.CIM_LogicalDisk Select 2190433330732 65 , -1 , Logical Disk 0, 'im_srv00crmsql01.sgtsc.local', 20959985664 , 'C:\ [System:NTFS]', 14557380608
INSERT Into dbo.CIM_LogicalDisk Select 2190433330733 65 , -1 , Logical Disk 1, 'im_srv00crmsql01.sgtsc.local', 41933602816 , 'E:\ [SQLSYSTEM:NTFS]', 687865856
INSERT Into dbo.CIM_LogicalDisk Select 2190433330734 65 , -1 , Logical Disk 2, 'im_srv00crmsql01.sgtsc.local', 15407775744 , 'D:\ [BACKUP:NTFS]', 4532994048
INSERT Into dbo.CIM_LogicalDisk Select 2190433330735 65 , -1 , Logical Disk 3, 'im_srv00crmsql01.sgtsc.local', 31421628416 , 'F:\ [LOGS:NTFS]', 6126829568
INSERT Into dbo.CIM_LogicalDisk Select 2190433330736 65 , -1 , Logical Disk 4, 'im_srv00crmsql01.sgtsc.local', 52419362816 , 'G:\ [SANSQLDATA:NTFS]', 7842299904
INSERT Into dbo.CIM_LogicalDisk Select 2190433330650 66 , -1 , Logical Disk 0, 'im_srv00dp01.sgtsc.local', 10485760000 , 'C:\ [:NTFS]', 9425649664
INSERT Into dbo.CIM_LogicalDisk Select 2190433330651 66 , -1 , Logical Disk 1, 'im_srv00dp01.sgtsc.local', 25898778624 , 'D:\ [data:NTFS]', 22836936704
INSERT Into dbo.CIM_LogicalDisk Select 2190433330612 67 , -1 , Logical Disk 0, 'im_srv00crmapp01.sgtsc.local', 22422749184 , 'C:\ [:NTFS]', 18189647872
INSERT Into dbo.CIM_LogicalDisk Select 2190433330613 67 , -1 , Logical Disk 1, 'im_srv00crmapp01.sgtsc.local', 13961789440 , 'D:\ [Data:NTFS]', 1170210816
INSERT Into dbo.CIM_LogicalDisk Select 2190433330708 69 , -1 , Logical Disk 0, 'im_srv00dcfp01.sgtsc.local', 36376150016 , 'C:\ [:NTFS]', 25176309760
INSERT Into dbo.CIM_LogicalDisk Select 2190433330709 69 , -1 , Logical Disk 1, 'im_srv00dcfp01.sgtsc.local', 52419362816 , 'D:\ [HomeDir:NTFS]', 2073034752
INSERT Into dbo.CIM_LogicalDisk Select 2190433330710 69 , -1 , Logical Disk 2, 'im_srv00dcfp01.sgtsc.local', 209711005696 , 'E:\ [Data:NTFS]', 64998080512
(13 row(s) affected)
August 6, 2008 at 9:54 am
Arrgh! Sorry, bug in my script. Please re-execute with this script.
Select top 8
'INSERT Into dbo.devices Select '
, DeviceKey
, ', '''+Name+'''' +', '
, ProductType
, ', '''+ProductTypeStr+''''
, ', '''+ProductName+''''
From dbo.devices
Select 'INSERT Into dbo.CIM_LogicalDisk Select '
, LogicalDisk_LUID, ', '
, NodeID ,', '
, SnapshotID ,', '
, DeviceID +', '
, ''''+SystemName+'''' +', '
, Win32_Size ,', '
, ''''+[Description]+'''' +', '
, dc_SpaceUsed
From dbo.CIM_LogicalDisk
Where NodeID IN(Select top 8 DeviceKey From dbo.devices)
[/quote]
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 6, 2008 at 10:31 am
hehe.. ok, no problem, have lots of time, the streets are emty, Evvverybody want to see Paris Hilton here in DK.. hehe
again, took 20 rows, to get data from logicaldisk
DeviceKey ProductType
------------------------------- ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------------------------------------ --------------------------------------------------------------------------------------------------------
INSERT Into dbo.devices Select 2 , 'sgtsc-mgnt-04 1 , 'Server ' , ' '
INSERT Into dbo.devices Select 25 , 'im_ilo00dp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 26 , 'im_ilo00crmsql01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 28 , 'im_ilo00exfe01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 29 , 'im_ilo00crmapp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 32 , 'im_ilo00dcfp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 35 , 'im_ilo00aos01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 37 , 'im_ilo00aos02 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 40 , 'im_ilo00aos03 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 46 , 'im_ilo00web01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 49 , 'im_ilo00job01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 52 , 'im_ilo00daxweb01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 54 , 'im_ilo00nav01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 57 , 'im_ilo00spp01 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 61 , 'im_ilo00ts02 12 , 'MgmtProc ' , 'Integrated Lights-Out 2 (iLO 2) '
INSERT Into dbo.devices Select 64 , 'im_srv00exfe01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select 65 , 'im_srv00crmsql01 1 , 'Server ' , 'ProLiant BL480c G1 '
INSERT Into dbo.devices Select 66 , 'im_srv00dp01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select 67 , 'im_srv00crmapp01 1 , 'Server ' , 'ProLiant BL460c G1 '
INSERT Into dbo.devices Select 69 , 'im_srv00dcfp01 1 , 'Server ' , 'ProLiant BL460c G1 '
(20 row(s) affected)
LogicalDisk_LUID NodeID SnapshotID Win32_Size dc_SpaceUsed
--------------------------------------- -------------------- ---- -------------------- ---- -------------------- ---- ------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- ---- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------
INSERT Into dbo.CIM_LogicalDisk Select 2190433330671 , 64 , -1 , Logical Disk 0, 'im_srv00exfe01.sgtsc.local', 36376150016 , 'C:\ [:NTFS]', 9155117056
INSERT Into dbo.CIM_LogicalDisk Select 2190433330732 , 65 , -1 , Logical Disk 0, 'im_srv00crmsql01.sgtsc.local', 20959985664 , 'C:\ [System:NTFS]', 14557380608
INSERT Into dbo.CIM_LogicalDisk Select 2190433330733 , 65 , -1 , Logical Disk 1, 'im_srv00crmsql01.sgtsc.local', 41933602816 , 'E:\ [SQLSYSTEM:NTFS]', 687865856
INSERT Into dbo.CIM_LogicalDisk Select 2190433330734 , 65 , -1 , Logical Disk 2, 'im_srv00crmsql01.sgtsc.local', 15407775744 , 'D:\ [BACKUP:NTFS]', 4532994048
INSERT Into dbo.CIM_LogicalDisk Select 2190433330735 , 65 , -1 , Logical Disk 3, 'im_srv00crmsql01.sgtsc.local', 31421628416 , 'F:\ [LOGS:NTFS]', 6126829568
INSERT Into dbo.CIM_LogicalDisk Select 2190433330736 , 65 , -1 , Logical Disk 4, 'im_srv00crmsql01.sgtsc.local', 52419362816 , 'G:\ [SANSQLDATA:NTFS]', 7842299904
INSERT Into dbo.CIM_LogicalDisk Select 2190433330650 , 66 , -1 , Logical Disk 0, 'im_srv00dp01.sgtsc.local', 10485760000 , 'C:\ [:NTFS]', 9425649664
INSERT Into dbo.CIM_LogicalDisk Select 2190433330651 , 66 , -1 , Logical Disk 1, 'im_srv00dp01.sgtsc.local', 25898778624 , 'D:\ [data:NTFS]', 22836936704
INSERT Into dbo.CIM_LogicalDisk Select 2190433330612 , 67 , -1 , Logical Disk 0, 'im_srv00crmapp01.sgtsc.local', 22422749184 , 'C:\ [:NTFS]', 18189647872
INSERT Into dbo.CIM_LogicalDisk Select 2190433330613 , 67 , -1 , Logical Disk 1, 'im_srv00crmapp01.sgtsc.local', 13961789440 , 'D:\ [Data:NTFS]', 1170210816
INSERT Into dbo.CIM_LogicalDisk Select 2190433330708 , 69 , -1 , Logical Disk 0, 'im_srv00dcfp01.sgtsc.local', 36376150016 , 'C:\ [:NTFS]', 25176309760
INSERT Into dbo.CIM_LogicalDisk Select 2190433330709 , 69 , -1 , Logical Disk 1, 'im_srv00dcfp01.sgtsc.local', 52419362816 , 'D:\ [HomeDir:NTFS]', 2073034752
INSERT Into dbo.CIM_LogicalDisk Select 2190433330710 , 69 , -1 , Logical Disk 2, 'im_srv00dcfp01.sgtsc.local', 209711005696 , 'E:\ [Data:NTFS]', 64998080512
(13 row(s) affected)
August 6, 2008 at 10:50 am
OK, got it:
Select TOP 99999999 devices.Name
, CIM_LogicalDisk.Description
, CIM_LogicalDisk.WIN32_Size
, CIM_LogicalDisk.dc_SpaceUsed
, Identity(int) as ID
, Cast(0 as int) as N
Into #Serverstemp5
From devices
LEFT JOIN CIM_LogicalDisk
ON devices.DeviceKey = CIM_LogicalDisk.NodeID
WHERE devices.ProductTypeStr = 'Server'
Order by devices.name--**
Update s
Set N = s.ID + 1 - sg.MinID
From #Serverstemp5 s
Join (Select [name], Min(ID) as MinID From #Serverstemp5 Group By [name]) sg
ON s.[name] = sg.[name]--**
Select Name
, Max(Description1) as Description1
, Max(Drive_Size1) as Drive_Size1
, Max(dc_SpaceUsed1) as dc_SpaceUsed1
, Max(Description2) as Description2
, Max(Drive_Size2) as Drive_Size2
, Max(dc_SpaceUsed2) as dc_SpaceUsed2
, Max(Description3) as Description3
, Max(Drive_Size3) as Drive_Size3
, Max(dc_SpaceUsed3) as dc_SpaceUsed3
From (Select Name
, Case N When 1 Then Description Else NULL End as Description1
, Case N When 1 Then WIN32_Size Else NULL End as Drive_Size1
, Case N When 1 Then dc_SpaceUsed Else NULL End as dc_SpaceUsed1
, Case N When 2 Then Description Else NULL End as Description2
, Case N When 2 Then WIN32_Size Else NULL End as Drive_Size2
, Case N When 2 Then dc_SpaceUsed Else NULL End as dc_SpaceUsed2
, Case N When 3 Then Description Else NULL End as Description3
, Case N When 3 Then WIN32_Size Else NULL End as Drive_Size3
, Case N When 3 Then dc_SpaceUsed Else NULL End as dc_SpaceUsed3
, N
From #Serverstemp5) as Disks
Group by Name
drop table #Serverstemp5
go
I have flagged the three lines that I changed.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 6, 2008 at 11:56 am
Damn, you actually did :w00t:
nice, thank you so much...
Now I will sit down an try to understand what you did, so I can add the 3. and 4. table and so on..
This is possible, right 😉
/T
August 6, 2008 at 12:16 pm
I couldn't say for sure, but Yeah, I would think that you could.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply