error from Powershell when try to rename with sequential prefix *recursively*

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 Order By GroupID Random but asc ID in each GroupID

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 ,...