Search results for query: *

I have two queries that have data that I need in one report. Query a1: Select fname, lname,state from contact where state = 'TN' Ouput data: fname lname state Kim Smith TN Jim Jones TN Sarah Lewis FL Joe Wills TN Query a2: Select fname, lname, state from...

I have created two queries in Microsoft sql server. I have two select statements that I have joined together and that works. The issue I have is I need the data in description to match shakeweight or armweight. If description = 'ARM SHANK' then shakeweight if description = 'ARM SHANK' then...

I have a query that I created in IBM DB2 database that display all report that are within the parameter 202010201 to 20210228 which is the Promise Date. I need to convert this code to Microsoft server. Here is the IBM DB2 code: (select a.* from ( select...

I have created a program where the user enters a release number and retrieve the data to a DatagridView connecting to a IBM db2 database. The options the users currently have is: Clear, Retrieve, Validate, and Update. The issue I am having is if the record is not in the database it doesn't...

I have a Crystal Report and I need to have the backcolor changed for every week within the month. Week one Aqua Week two Orange etc. I have a formula field that have the date in mm/dd/yyyy format but I'm not sure how to find the week starting at Monday ending at Friday and putting a color to it.

I have a report in Crystal report that has a promise date and a shipped day, both data types are number. The data is stored as yyyymmdd in the database (DB2) so I created two formula fields to change the date format to display mm/dd/yyyy. I have two parameter "StartDate and EndDate" and the type...