Recent content by RosieGp

tempDate is going to have 12/01/2018 onward dates so just month helper would have incorrect data, so I need month and year as well. Thanks.

Hello - I'm trying to count distinct ids per month. but it is not working for me. worksheet1 A B C 1 ID tempDate DateValidation 2 12 11/12/2017 11/01/2017 3 14 12/23/2017 12/01/2017 4 16 11/17/2017...

i have table with column that have duplicates with different start and end date. Table1: Product startDate endDate Desc A0987 05/01/2017 05/05/2017 Traiging A0987 05/01/2017 05/05/2017 Traiging A1234 05/02/2017 05/03/2017 Driver Mag A1234...

Thanks I figured out what I was doing wrong in the query. Thanks for all of your help.

Thanks Dave. yes i made a copy/paste error. my first 3 queries seems to work but 4th query is not returning any data.

Table1 ColoraddedJan Red Yellow Green Table2 ColoraddedFeb Purple Orange Table3 ColoraddedMar White Black ComparingTable Coloradded dateadded dateused Red 1/1/2017 3/1/2017 White 2/4/2017 4/4/2017 Purple 1/1/2017 5/1/2017 Pink 2/3/2017 4/3/2017...

Thanks Andy. i guess i was too tired and not thinking straight. thanks again.

Hello - i have following 3 tables: tbl_Rating ID ProductNumber Rating 1 C_10, C_11 5 1 C_10, C_11 4.5 3 F_12 2 4 CH_3 3 tbl_Sold ID ProductName Dealer ProductSOld 1 Chevy Cruise Sam 2 3 Fiat Compact Darcy 1 4 Chysler Van Donny 1 tbl_Product ID Brand 1 Chevy 2 GM 3 Fiat 4 Chysler SO far i...

Thanks Andrzejek I understand and have corrected this. I guess i just needed someone to point that out. sorry and thanks.

How can I Join on KidsData and Fruitdescription table to get Fruit Name from Fruitdescription table rather than hard coding it. this is what I can get to this far. <cfquery name="kidsData"> SELECT * FROM KidsData K LEFT JOIN Fruitdescription F ON F.ID = K.FruitData WHERE FruitData IS...

Thanks Lyndon. that did help me. I have one more question, might be incorrect for CF thread since it is SQL query question. How can I Join on KidsData and Fruitdescription table to get Fruit Name from Fruitdescription table rather than hard coding it. this is what I can get to this far...

I have a table of kids(5) and which of the 6 fruits they bring: Table: KidsData ID Name FruitData 1 Candy 100000 2 Andy 001000 3 Sarah 001010 4 Gabby NULL 5 Jack 000110 Table: Fruitdescription ID FruitName 1 apple 2 orange 3 kiwi 4 banana 5...

I'm sorry the entire logic needs to change based on different data input. SO i have to write a different query Input data : tempTable Table1 ProductID ProductNumber ProductType PlacingOrder 13 12B ProduceApple 1 13 16D Deli...

I need a query which writes to a table (if data is missing) and then based on the logic return a value (TRUE/FALSE) if the procedure needs to be executed. I have following (not functional) query: Declare @MissingData varchar(6) = 'TRUE' Insert INTO MissingInfoTable (CustomerID, NoOfEntries...

Thanks Denimined. How can i do the following: ISNULL(Product.ProductDateSold, '1900-01-01') as ProductDateSold within the query. Thanks.