1
  • Need urgent help

    What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And I have one more table...

    sanketkolge1010 pointsBadges:
  • Mulitple Selects

    Trying to isolate specific entries from a table based on Production Code: (Select (P.EntryDate) From Production P Full JOIN ProductionJobNumber PJ on P.Code = PJ.ProductionCode Where P.ProcessCode = 1080 and PJ.JobNumber = OH.JobNumber) as OkToPlate, (Select (P.EntryDate) From Production P FULL...

    jsmithuni0110 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following