powershell,recursion,sequential-number
Try it like so: Get-ChildItem $path -recurse -file | Where Name -NotMatch '^\d{4}\s+' | Rename-Item -NewName {"{0} $($_.name)" -f $count++} -whatif When you supply $_ as an argument (not a pipeline object), that gets assigned to the Path parameter which is of type string. PowerShell tries to convert that FileInfo...
sql-server,group-by,sql-update,sequential-number
SAMPLE TABLE CREATE TABLE #TEMP(Num INT, Grp INT, ID INT) INSERT INTO #TEMP SELECT 0 , 1 , 1 UNION ALL SELECT 0 , 1 , 2 UNION ALL SELECT 0 , 1 , 3 UNION ALL SELECT 0 , 2 , 4 UNION ALL SELECT 0 , 2 ,...