Search results

I want to know how can I turn a row into a column. I want my data to display in a horizontal way. Let me show you an example Yourdate-------YourNumber------ Cash4Table ------YourTable----GaFiveTable 5/16/2016 312 Cash4Table Currently, this is my SQL statement below...

Hi I want my sql database to operate like this below. I just want to use MoonPhase Number. The table below works I just want to use Moonphase Number when the box pops open PARAMETERS [Enter Date:] DateTime; SELECT "YourTable" AS SourceTable, YourDate, YourNumber FROM YourTable WHERE YourDate...

Hi I need some help She wants me to figure out how to translate the above grid into rows in your table that will convert scope and severity values into letters values. Please see attachment Thank you Erika

SELECT T1.YourNumber, T1.YourDate, MoonPhaseTable.YourNumber AS MoonPhaseNumber FROM YourTable AS T1 INNER JOIN MoonPhaseTable ON T1.YourDate = MoonPhaseTable.YourDate WHERE T1.YourDate IN SELECT YourDate FROM YourTable AS T2 WHERE T2.YourNumber = [Enter Number] UNION ALL...