Search results for query: *

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.

...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 NOT NULL AND ID = #ID# </cfquery> Table: KidsData...

...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.FruitData = K.ID WHERE FruitData IS NOT NULL AND ID = #ID# </cfquery> Table: KidsData ID...

...Fruitdescription ID FruitName 1 apple 2 orange 3 kiwi 4 banana 5 pineapple 6 grape <cfquery name="kidsData"> SELECT * FROM KidsData WHERE FruitData IS NOT NULL AND ID = #ID# </cfquery> <cfoutput query="kidsData"> <cfif #left(#FruitData#, 1)# EQ '1'>...

...,PlacingOrder ,ProductType ,'Multiple PRODUCE orders' as ProductDescription (so here for the following input there are 2 inserts to output) ,getdate() as Today_Date from #Table1 Group by ProductID ,PlacingOrder HAVING COUNT(*) > 1 Any help is appreciated. thanks.

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.

Hi, I had the following query to join on 2 tables kwhich worked perfectly fine. SELECT Customer.Customer.FName, Supplier.* FROM Customer INNER JOIN Supplier ON Customer.ID = Supplier.ID WHERE Supplier.process=True AND Supplier.processDate Is Not Null Now I want to Join another table Product...

I have the follwoing query that is updating the data in table SupplierTable1 UPDATE SupplierTable1 SET TodayDate = '#DATEFORMAT(Now(), "mm/dd/yyyy")#', Suppliermail = '#form.Supplieremail#', SupplierStreet = '#form.SupplierStreet#', SupplierCity =...

does anyone have a solution for the above issue. Help me with this please. Thanks in advance.

sorry i misses adding the where condition in update query <cfquery name="updatedata" datasource="MainDB"> UPDATE newUsersTable SET UserAddress = #session.UserAddress# where UserID=#form.UserID# </cfquery> <cfquery name="insertdata" datasource="MainDB"> INSERT INTO newUsersTable...

phil - I changed my query to the following: <cfquery name="updatedata" datasource="MainDB"> UPDATE newUsersTable SET UserAddress = #session.UserAddress# </cfquery> <cfquery name="insertdata" datasource="MainDB"> INSERT INTO newUsersTable (NewUserTodayDate, UserID, UserFirstName...