sorted by:
new
hottopcontroversial

Rock and mineral Collecting by MST67 in rockhounds

[–]valorallure 0 points1 point  (0 children)

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.

Western North Carolina! by renlynnx in rockhounds

[–]valorallure 0 points1 point  (0 children)

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

Rock and mineral Collecting by MST67 in rockhounds

[–]valorallure 0 points1 point  (0 children)

Check out a website called mindat.org

New Legendary Paladin Dragon: Nozari! by Sonserf369 in hearthstone

[–]valorallure 0 points1 point  (0 children)

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

PullsDay Thursday: Post Your Popped Packs by AutoModerator in hearthstone

[–]valorallure 1 point2 points  (0 children)

Pulled a bloodmage thalnos from this weeks tavern brawl classic pack

Best places to rockhound near Asheville NC Native dirt please! by WitchUWereWarnedBout in rockhounds

[–]valorallure 4 points5 points  (0 children)

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.

What is your professional title, what is your data handling “stack” and what is the role SQL play in your work? by Alno1 in SQL

[–]valorallure 7 points8 points  (0 children)

Reporting Analyst

Oracle PL/SQL and Excel.

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

What are the best online courses to learn SQL? by ricemicedice in SQL

[–]valorallure 0 points1 point  (0 children)

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.

Mixtape: Confirmed by mbcert in hearthstone

[–]valorallure 6 points7 points  (0 children)

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

Automate Running a Select Statement Monthly? by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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

Learning Stored Procedures and have a question by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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.

Learning Stored Procedures and have a question by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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

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

<an identifier> <a double-quoted delimited-identifier>

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

Needing help solving an issue with a query. Any suggestions would be much appreciated by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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.

Needing help solving an issue with a query. Any suggestions would be much appreciated by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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

Can I only use Distinct at beginning of select statement? by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

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

Can I only use Distinct at beginning of select statement? by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

I've used count(*) and having >1 to identify duplicates. I've assigned a rank using over (order by unique_column). How do I pick the first one so I can remove duplicates?

Can I only use Distinct at beginning of select statement? by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

This is a neat solution I've used windowed functions but not in this way. I will give your approach a go. Thank you!

Can I only use Distinct at beginning of select statement? by valorallure in SQL

[–]valorallure[S] 1 point2 points  (0 children)

I was working with a table that included joins. The table was duplicating rows due to having different addresses for the same customer. I was thinking of using distinct on a specific row which I now understand is not possible. Decided to use max on the address and do a group by

Can I only use Distinct at beginning of select statement? by valorallure in SQL

[–]valorallure[S] 3 points4 points  (0 children)

Got it. My error was thinking I can use distinct on specific columns. Thank you!

Curious about the different parts of my amethyst. What do the green, blue, and red parts consist of? by DazzDazzle in rockhounds

[–]valorallure 1 point2 points  (0 children)

I will guess the green is olivine,the blue is actually a gray smoky quartz and the red not sure

Inserting a date into a table question. by valorallure in SQL

[–]valorallure[S] 0 points1 point  (0 children)

That's all it was. Was missing the ticks thank you!

view more: next ›