Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlhelp14
Yak Posting Veteran
55 Posts |
 Posted - 2008-05-08 : 13:30:04
|
| i have function:can anybody help me to figure this issue? how can i get that.Thank you. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-08 : 14:02:26
|
| Where did you get the records in red that you wrote up above?Without a schema and sample records handy I'd have to say you need to create a table with the missing values and include them into your table either with a union or a join.In other words, write a query that has records with all the values you need but also with 0.00 in the quantity column. Once you can do that, then you union that select statement IN your inner derived table "t" and it should work.An infinite universe is the ultimate cartesian product. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-05-09 : 04:48:22
|
quote:
Originally posted by sqlhelp14
i have function:can anybody help me to figure this issue? how can i get that.Thank you.
Did you edit the content?It seems the post is incompleteMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
function query