Please refer this post that can work for any table

https://exploresql.com/2019/12/14/how-to-find-fill-rate-in-a-table/

Very nice and informative Dwain Camps 🙂

Are you using SQL Server?

select M.*,t.TypeOfAnimal from #Master as m inner join #test1 as t on ', '+t.Animal +', ' like '%, '+m.TypeOfAnimal+', %'

If you use versions prior to 2005, you need to use dbcc updateusage to get accurate count

http://beyondrelational.com/blogs/madhivanan/archive/2007/11/02/different-ways-to-count-rows-from-a-table.aspx

More methods are available here

http://beyondrelational.com/blogs/madhivanan/archive/2008/09/12/return-top-n-rows.aspx

Make sure to read this

http://www.sqlservercentral.com/articles/IsNumeric/71512/

Why are you worrying about GAPs when using identity column?

What is this? 😉

Gordon Barclay (9/8/2010)

---

Thanks for all the help, but i have done is something like

SELECT *

FROM tablea a

WHERE a.value ='xxx'

OR a.EndDate < '24/08/2010'

AND a.EndDate = '24/08/2010'

...

Is the cell formatted? If so, remove any formation and try again

Jeff Moden (9/7/2010)

---

Heh... ya...

Make sure to read this fully

www.sommarksog.se/dynamic_sql.html

Another method

select * from #GermanURLs

where charindex('%',SourceURL)>0

Test it

select stuff('test',1,1,SPACE(0))