Sfrgttk

Redirecting CellPrint output

Why did the Cray-1 have 8 parity bits per word?

How can I handle a player who pre-plans arguments about my rulings on RAW?

It doesn't matter the side you see it

Formatting a table to look nice

If there are any 3nion, 5nion, 7nion, 9nion, 10nion, etc.

Being asked to review a paper in conference one has submitted to

Where is the fallacy here?

When do _WA_Sys_ statistics Get Updated?

Why do phishing e-mails use faked e-mail addresses instead of the real one?

Is there a full canon version of Tyrion's jackass/honeycomb joke?

Create chunks from an array

Ahoy, Ye Traveler!

Has Wakanda ever accepted refugees?

How to merge row in the first column in LaTeX

How to kill a localhost:8080

GPL code private and stolen

School performs periodic password audits. Is my password compromised?

Should we avoid writing fiction about historical events without extensive research?

How do I deal with being envious of my own players?

How do we objectively assess if a dialogue sounds unnatural or cringy?

Why are special aircraft used for the carriers in the United States Navy?

Is there a limit on the maximum number of future jobs queued in an org?

Why would the IRS ask for birth certificates or even audit a small tax return?

Left join SQL Select Statement

ora-01410 invalid RowID sporadically in a select statementOptimization of a select statementHow can I make a select statement get blocked?How to create implicit select statementsThe cost of left out join versus a selectHow to insert multiple returns of the select statement?Replacement for Nested SELECT statements for every row in SELECT clauseProgress of SELECT INTO statementSSRS - select where parameter and fixed valueSelecting only when specific values exist in another select query

0

Good day,
Im trying to find a good way on my select statement

Table1

AccountID      AccountName    Rate  OldRate

01             Smith          X     X2

02             Providence     X     X2

03             Jones          X     X3

04             Charity        X2    X

05             Smith          X3    X

06             Providence     X     X2

07             SMith          X     X3

08             Charity        X     X3





Table 2

Rate          Amount 

X             500.00 

X2            200.00     

X3            30.00   







Result 



AccountID      AccountName    Rate  Amount  OldRate Amount

01             Smith          X     500.00  X2      200.00

02             Providence     X     500.00  X2      200.00

03             Jones          X     500.00  X3       30.00

sql-server select table

share

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

Jesun Bicar 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

Good day,
Im trying to find a good way on my select statement

Table1

AccountID      AccountName    Rate  OldRate

01             Smith          X     X2

02             Providence     X     X2

03             Jones          X     X3

04             Charity        X2    X

05             Smith          X3    X

06             Providence     X     X2

07             SMith          X     X3

08             Charity        X     X3





Table 2

Rate          Amount 

X             500.00 

X2            200.00     

X3            30.00   







Result 



AccountID      AccountName    Rate  Amount  OldRate Amount

01             Smith          X     500.00  X2      200.00

02             Providence     X     500.00  X2      200.00

03             Jones          X     500.00  X3       30.00

sql-server select table

share

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

Jesun Bicar 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 | 

Good day,
Im trying to find a good way on my select statement

Table1

AccountID      AccountName    Rate  OldRate

01             Smith          X     X2

02             Providence     X     X2

03             Jones          X     X3

04             Charity        X2    X

05             Smith          X3    X

06             Providence     X     X2

07             SMith          X     X3

08             Charity        X     X3





Table 2

Rate          Amount 

X             500.00 

X2            200.00     

X3            30.00   







Result 



AccountID      AccountName    Rate  Amount  OldRate Amount

01             Smith          X     500.00  X2      200.00

02             Providence     X     500.00  X2      200.00

03             Jones          X     500.00  X3       30.00

sql-server select table

share

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

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

Table1

AccountID      AccountName    Rate  OldRate

01             Smith          X     X2

02             Providence     X     X2

03             Jones          X     X3

04             Charity        X2    X

05             Smith          X3    X

06             Providence     X     X2

07             SMith          X     X3

08             Charity        X     X3





Table 2

Rate          Amount 

X             500.00 

X2            200.00     

X3            30.00   







Result 



AccountID      AccountName    Rate  Amount  OldRate Amount

01             Smith          X     500.00  X2      200.00

02             Providence     X     500.00  X2      200.00

03             Jones          X     500.00  X3       30.00

share

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

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

share

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

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

asked 9 mins ago

Jesun BicarJesun Bicar

1

New contributor

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

asked 9 mins ago

Jesun BicarJesun Bicar

1