DANIWEB saved me a few months ago, and I'm hoping the community can save me again :)
I've found myself in the position of needing to extract a very small portion of data from a vast SQL database.
I've got the specific table in question, and have isolated what was needed out of the query itself.
However, my problem is this:
When I run the query
SELECT TOP 100000 [typeID] ,[groupID] ,[typeName] ,[description] ,[graphicID] ,[radius] ,[mass] ,[volume] ,[capacity] ,[portionSize] ,[raceID] ,[basePrice] ,[published] ,[marketGroupID] ,[chanceOfDuplicating] ,[iconID] FROM [ebs_DATADUMP].[dbo].[invTypes]
I get a whole host of entries in some fields that have a NULL entry, specifically the marketgroupID column. I need an amendment to the script that would behave like:
if [marketGroupID]=NULL then Ignore_Row
And (yes, and) if [typeName] has the word "Blueprint" in it, to also ignore that row.
I realise this might be a bit much to ask, but any help or guidance will be massively appreciated.