Inserting Data

Question

Inserting Data

Data Rat

SSC Eights!

Points: 943
More actions
October 22, 2019 at 2:35 pm
Go to Answer
#3691000
Hi Friends,
I was wondering what would be the best way to insert O's into the field number of items sold for products that have no sales using a temporary table or iTVF to use in a Report or application. Thanks !
- This topic was modified 5 years ago by Data Rat .
Phil Parkin

SSC Guru

Points: 246959
More actions
October 22, 2019 at 2:44 pm
Answer
#3691005

Use
SELECT ItemNo = ISNULL(ItemNo,0)
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101091 More actions · Answer 1

Is the report not able to do a LEFT JOIN instead of an INNER JOIN? That would be the standard way to do that, without having to create a dummy table(s).

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 2

Just use an outer join to the Products table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)