Hi all,
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.
Regards
Rob.