My tank levels are high

[Snakeheadred]

Tested all levels pH is 8.2 nitrates are hight every thing is to high help

 

[twentyleagues]

Oh boy. This is going to need a back story of the tank, your knowledge, and testing procedures. Would love to help but can't with current info.
Substrate?
Decor?
Water parameters before going in the tank?
Length of time tank has been up?
Waterchange schedule and amount?
Fish?
Plants?
There is a section that addresses this type of question with a preset set of questions we need to know to help facilitate helping you.

 

[TwoHedWlf]

Tested all levels pH is 8.2 nitrates are hight every thing is to high help

Going to need more info but the fix is usually pretty simple...

Do a water change.
Still high?
Do water change.
Still high?
Do a water change.
Still high?
Do a water change.

 

[B1GC0UNTRY]

Going to need more info but the fix is usually pretty simple...

Do a water change.
Still high?
Do water change.
Still high?
Do a water change.
Still high?
Do a water change.

I literally L O L ‘d. Solid advice actually.

 

[Ruturaj]

Going to need more info but the fix is usually pretty simple...

Do a water change.
Still high?
Do water change.
Still high?
Do a water change.
Still high?
Do a water change.

I put it as a loop
1. Do a water change
2. Still high go to 1

I am not sure why OPs pH is high. Shouldn't it drop with lack of water changes.

 

[TwoHedWlf]

I put it as a loop
1. Do a water change
2. Still high go to 1

I am not sure why OPs pH is high. Shouldn't it drop with lack of water changes.

Here...

Declare @maxNitrate int = '30',
Declare @maxAmmonia int = '0',
Declare @maxPH decimal = '7.5',
Declare @minPH decimal = '6.5'

select Nitrate, Ammonia, PH into #Tests from TestingKit

While(#Tests.Nitrate>@MaxNitrate or #Tests.Ammonia > @maxAmmonia or #Tests.PH>@maxPH or #Test.PH<minPH)
Begin
Drop table #Tests,
Set Tank.CurrentVolume = Tank.MaxVolume*.5,
Set Tank.CurrentVolume = Tank.MaxVolume,
Select Nitrate, Ammonia, PH into #Tests from TestingKit
End

(It feels like I spend all day every day writing SQL queries and it still takes me 70 tries to get the syntax right...)

 

[Dalfrey86]

Here...

Declare @maxNitrate int = '30',
Declare @maxAmmonia int = '0',
Declare @maxPH decimal = '7.5',
Declare @minPH decimal = '6.5'

select Nitrate, Ammonia, PH into #Tests from TestingKit

While(#Tests.Nitrate>@MaxNitrate or #Tests.Ammonia > @maxAmmonia or #Tests.PH>@maxPH or #Test.PH<minPH)
Begin
Drop table #Tests,
Set Tank.CurrentVolume = Tank.MaxVolume*.5,
Set Tank.CurrentVolume = Tank.MaxVolume,
Select Nitrate, Ammonia, PH into #Tests from TestingKit
End

(It feels like I spend all day every day writing SQL queries and it still takes me 70 tries to get the syntax right...)

Between SQL, SAS, and R the struggle for syntax is very real.

 

[Ruturaj]

Here...

Declare @maxNitrate int = '30',
Declare @maxAmmonia int = '0',
Declare @maxPH decimal = '7.5',
Declare @minPH decimal = '6.5'

select Nitrate, Ammonia, PH into #Tests from TestingKit

While(#Tests.Nitrate>@MaxNitrate or #Tests.Ammonia > @maxAmmonia or #Tests.PH>@maxPH or #Test.PH<minPH)
Begin
Drop table #Tests,
Set Tank.CurrentVolume = Tank.MaxVolume*.5,
Set Tank.CurrentVolume = Tank.MaxVolume,
Select Nitrate, Ammonia, PH into #Tests from TestingKit
End

(It feels like I spend all day every day writing SQL queries and it still takes me 70 tries to get the syntax right...)

I gotta learn SQL, I have 4 years of experience and still don't know any.

 

[Ruturaj]

Between SQL, SAS, and R the struggle for syntax is very real.

You should see mine between python, C++, Java, C# during interviews. Interviewer struggles too. ?

 

[Snakeheadred]

I literally L O L ‘d. Solid advice actually.

Do won't to hear the funny part my water nuts we normally use for ro water all need cleaning out there bad condition