query not pulling in ID column correctly on query
Posted on 2016-09-23
sql server 2008 r2
I have an id_column that is varchar(50)
I have this query where I'm trying to pullout data in sequence piece by piece. into a text file.
where FuncExt.[Id_Column] <= '2000000'
--where FuncExt.[ID_COLUMN] between '2000000' and '5000000'
--where FuncExt.[ID_COLUMN] between '5000000' and '8000000'
--where FuncExt.[ID_COLUMN] between '8000000' and '10000000'
--where FuncExt.[ID_COLUMN] > '10000000'
The query is pulling out records not in sequence ???