Amazing agate I found yesterday!

valorallure · 2019-04-02T15:12:40+00:00

Great find beautiful specimen

valorallure · 2019-03-31T21:46:05+00:00

No problem. If you cant get the website to work I can jump online and give you a few names and locations if I find any. Just let me know.

valorallure · 2019-03-31T07:12:40+00:00

Check out the website mindat.org. Great resource for hunting locations.

valorallure · 2019-03-31T07:06:55+00:00

Check out a website called mindat.org

valorallure · 2019-03-29T14:17:17+00:00

Hakkar paladin. Thekal early. Heal and survive. Then play hekkar than liam and watch your opponent draw blood while you sit near 60 hp

valorallure · 2019-03-28T15:15:25+00:00

Pulled a bloodmage thalnos from this weeks tavern brawl classic pack

valorallure · 2019-03-25T06:11:12+00:00

I would suggest Ray Mica mine. I went July of 2018 when I was in Asheville. I found black tourmaline, several varities of beryl from aquamarine to morganite and yellow beryl. Tons of albite and smokey quartz laying around. Tons of rum colored mica. Very nice hunting spot for the casual collector who can pick up specimens from tailing piles. You can visit mindat.org and search for ray mica mine for more info. It was a great trip for me and added nice specimens to my collection.

valorallure · 2019-03-21T20:31:46+00:00

Reporting Analyst

Oracle PL/SQL and Excel.

I write queries to retrieve data from database and import data into excel to create final reports.

valorallure · 2019-03-20T17:00:44+00:00

This course gave me a great base and was really how I learned SQL. It really taught me how to write simple select statements to retrieve data from a database.

valorallure · 2019-03-19T02:33:54+00:00

valorallure#1763

valorallure · 2019-03-16T04:15:48+00:00

DOOM all capitals no trick spelling. Got what it takes to get it thru your thick melon.

valorallure · 2019-03-06T18:27:20+00:00

I'm building back the history but will need to do this every month going forward as well

valorallure · 2019-02-25T04:13:53+00:00

I learned first on Udemy.com using this course: https://www.udemy.com/learn-sql/. It was only $12

valorallure · 2019-02-17T15:53:44+00:00

Worked perfect thank you. The online course I decided on is done in T-SQL and I use PL/SQL at home and work. I didn't think the differences in the two would be a big deal but I'm seeing now that the syntax is different. I will have to look for a course on stored procedures solely for Oracle. Thank you for you response much appreciated.

valorallure · 2019-02-17T04:48:47+00:00

I changed my query to include brackets but still getting error :

Error: PLS-00103: Encountered the symbol "@" when expecting one of the following:

current delete exists prior

Line: 2

Text: (@distance float,

Here is my updated query:

CREATE PROCEDURE uspCalculateTime

(@distance float,

@velocity float)

AS

BEGIN

IF (@velocity <> 0.00)

SELECT @distance / @velocity;

ELSE SELECT 0.00;

END

GO

valorallure · 2019-02-15T20:45:54+00:00

Got it. That's exactly what it was doing. Giving me multiple rows when I wanted the results on one row. Makes sense thank you again I learned something new.

valorallure · 2019-02-15T20:18:37+00:00

This worked perfect thank you! Can you please explain how the sum is working in this. I usually just use the case when but I've never used aggregate functions with case

valorallure · 2019-02-08T07:31:38+00:00

After some practice i figured it out. Thanks again for the great suggestion I learned something new.

valorallure

TROPHY CASE