SELECT DISTINCT
MAX(EdiStcID_Grp)EdiStcID_Grp,EdiStcID, DENSE_RANK() OVER(ORDER BY
MAX(EdiStcID_Grp)) [Grp#]
FROM
#tmpSRT tsrt
GROUP BY tsrt.EdiStcID
Tasty note to self
Subscribe to:
Posts (Atom)
Twitter / bobmihada
I use to bkite too
Facebook Badge
Tags
SQL
(27)
OpenFiler
(9)
ESXI
(7)
DBA
(5)
iscsi
(5)
Linux
(4)
BatchScript
(3)
CentOs
(3)
MIH
(3)
3ware
(2)
Autdit
(2)
Autogenerate
(2)
Automation
(2)
Cheap storage
(2)
Column level changes
(2)
Freenas
(2)
NAS
(2)
OPRIME
(2)
RESTORE DATABASE
(2)
SQL 2k5
(2)
SQL partitioning
(2)
Sans
(2)
XML Datatype
(2)
copy
(2)
file replication
(2)
hobocopy SQL
(2)
raid
(2)
redgate
(2)
turnkey fileserver
(2)
vmfs
(2)
vmware
(2)
win2k3
(2)
windows 2003
(2)
"Frame Work"
(1)
7z
(1)
7zip
(1)
ASCII
(1)
ASP.NET
(1)
Apple Mobile Device EtherNet
(1)
BACKUP
(1)
BACKUP DATABASE
(1)
Big Data
(1)
CACHE
(1)
CCD
(1)
CCR
(1)
CDA
(1)
Cloning
(1)
Code
(1)
Code Generation
(1)
Conficker
(1)
CronTab
(1)
DBCC SHRINKFILE
(1)
DISK FULL
(1)
DUDE
(1)
DVD
(1)
Dir /b
(1)
Directory
(1)
Disaster recovery
(1)
Disk
(1)
ESX
(1)
Example
(1)
FOR XML
(1)
Fatcory
(1)
Fault tolerance
(1)
FileName
(1)
FolderPath
(1)
Foreign Key
(1)
FreeProxy
(1)
GlassGiant.com
(1)
HA
(1)
HDA
(1)
HL7
(1)
Happy thought
(1)
ICS
(1)
IDE
(1)
INSTALL
(1)
Karma
(1)
Korea
(1)
LSN
(1)
Leadership
(1)
MU
(1)
OOP
(1)
Optimus
(1)
PBXIF
(1)
Performance Dashboard
(1)
Permissions
(1)
Primary Key
(1)
RDP
(1)
RESTORE LOG
(1)
Redundancy
(1)
Remote Desktop
(1)
SDA
(1)
SQL 2k5 installation
(1)
SQL Blocks
(1)
SQL Logshipping
(1)
SQL Performance
(1)
SQL SHRINKFILE
(1)
SQL Service Broker
(1)
SQL Transaction logs
(1)
SQL backup
(1)
SQL install
(1)
SQL install failed
(1)
SQL maintenance
(1)
SQL mirroring
(1)
SQL monitor
(1)
SQL network backup Mapped drive net use
(1)
SQL ophan account
(1)
SQL suspect marklar emergency
(1)
SSB
(1)
SSH
(1)
SSL
(1)
Schema compare
(1)
Schema compare batch script
(1)
Server
(1)
SugarCRM
(1)
Svsan
(1)
Temporary ASP.NET Files
(1)
VM
(1)
VSTSDB
(1)
WinSCP
(1)
bakupset
(1)
batch
(1)
com
(1)
database_mirroring
(1)
dell optiplex 330
(1)
dns
(1)
dos
(1)
drbd
(1)
extplorer
(1)
ghetto
(1)
google speadsheets
(1)
gov
(1)
graph
(1)
hyperbac
(1)
import data
(1)
internet connection sharing
(1)
monitoring
(1)
motivation
(1)
msdb
(1)
mssqltips
(1)
mssqltips SQL DBA
(1)
nagious
(1)
netsh
(1)
nutz
(1)
openfire
(1)
positve
(1)
psexec
(1)
red-gate
(1)
redgate scream
(1)
redgate snapper
(1)
registry
(1)
richcopy
(1)
schtask
(1)
scrub
(1)
servers
(1)
shares
(1)
sp_attach_db
(1)
sp_detach_db
(1)
sp_recompile
(1)
sp_start_job
(1)
sql sp_recompile
(1)
sql timeout expired
(1)
sql2005
(1)
staging
(1)
stapler
(1)
syslnklgns
(1)
sysprep
(1)
transaction log full
(1)
triggers
(1)
trixbox
(1)
uptime
(1)
video editing
(1)
virtual restore
(1)
vs2010
(1)
wow
(1)
xcopy
(1)
xp_msver
(1)
xxcopy
(1)
My Blog List
B O B M I H A D A
- Bob Mihada
- Make It Happen
© Copyright by Bob Mihada | Template by Blogspot tutorial(slightly modified)
