Sfrgttk

Geography in 3D perspective

Do I need to be arrogant to get ahead?

Knife as defense against stray dogs

Maths symbols and unicode-math input inside siunitx commands

Practical application of matrices and determinants

Print a physical multiplication table

Is it insecure to send a password in a `curl` command?

Why are there no stars visible in cislunar space?

Can a medieval gyroplane be built?

Do US professors/group leaders only get a salary, but no group budget?

Fewest number of steps to reach 200 using special calculator

What does "mu" mean as an interjection?

How does 取材で訪れた integrate into this sentence?

Brake pads destroying wheels

How are passwords stolen from companies if they only store hashes?

Optimising a list searching algorithm

Calculate the frequency of characters in a string

What (if any) is the reason to buy in small local stores?

Can other pieces capture a threatening piece and prevent a checkmate?

What favor did Moody owe Dumbledore?

Existence of a celestial body big enough for early civilization to be thought of as a second moon

PTIJ: Why do we blow Shofar on Rosh Hashana and use a Lulav on Sukkos?

Describing a chess game in a novel

PTIJ: Do Irish Jews have "the luck of the Irish"?

How to create stored procedure involving wildcards?

Create stored procedure to select the data?How to create a mysql stored procedure through linux terminalMySQL stored procedure create database by monthCannot create stored procedureSQL Server : create table within stored procedureHow can we create a table from stored procedure?How can I partition records vertically across machines?Innovative solution required - Remotely create stored procedureStored Procedure Processing and Error LogHow to create stored procedure that returns query result?

0

I have a question,

I want to write a stored procedure given a name in the where clause of the query, return all matching identities of the staff members who have staff name that contains the queried name.

A staff may be assigned to multiple departments and therefore possess multiple staff_ID, staff_name, and staff_email.

For example,

a staff member who has 5 staff records with (staff_ID 123 (main), staff_ID 134009, staff_ID 283904, staff_ID 321380, staff_ID 284057), having staff_name Alex Lim, Alex Lim Hong Jun.

I would like my output to return all records (with 2 column types described below)

1 - main where there will be the main_staff_id, main_staff_name, main_staff_email

2 - matched where there will be matched staff_id, matched_staff_name, matched_email

Would like to seek advice from the floor about how to create a stored procedure like this. Many thanks.

mysql stored-procedures

share

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have a question,

I want to write a stored procedure given a name in the where clause of the query, return all matching identities of the staff members who have staff name that contains the queried name.

A staff may be assigned to multiple departments and therefore possess multiple staff_ID, staff_name, and staff_email.

For example,

a staff member who has 5 staff records with (staff_ID 123 (main), staff_ID 134009, staff_ID 283904, staff_ID 321380, staff_ID 284057), having staff_name Alex Lim, Alex Lim Hong Jun.

I would like my output to return all records (with 2 column types described below)

1 - main where there will be the main_staff_id, main_staff_name, main_staff_email

2 - matched where there will be matched staff_id, matched_staff_name, matched_email

Would like to seek advice from the floor about how to create a stored procedure like this. Many thanks.

mysql stored-procedures

share

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have a question,

I want to write a stored procedure given a name in the where clause of the query, return all matching identities of the staff members who have staff name that contains the queried name.

A staff may be assigned to multiple departments and therefore possess multiple staff_ID, staff_name, and staff_email.

For example,

a staff member who has 5 staff records with (staff_ID 123 (main), staff_ID 134009, staff_ID 283904, staff_ID 321380, staff_ID 284057), having staff_name Alex Lim, Alex Lim Hong Jun.

I would like my output to return all records (with 2 column types described below)

1 - main where there will be the main_staff_id, main_staff_name, main_staff_email

2 - matched where there will be matched staff_id, matched_staff_name, matched_email

Would like to seek advice from the floor about how to create a stored procedure like this. Many thanks.

mysql stored-procedures

share

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

JlpooJlpoo

61

New contributor

Jlpoo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 8 mins ago

JlpooJlpoo

61