Welcome to the Lounge

raddevus2-Dec-20 5:19

2-Dec-20 5:19

Great post! Thumbs Up | :thumbsup:

Your post is exactly what I go through constantly. I may not really need to design and write a new query for 1 or more years. Then I go back and have to invent the wheel all over again.

MSBassSinger1-Dec-20 6:20

MSBassSinger

1-Dec-20 6:20

I use a private GitHub repo, and use Agent Ransack on my local laptop to find specific files by key words or phrases.

raddevus1-Dec-20 8:58

1-Dec-20 8:58

MSBassSinger wrote:
I use a private GitHub repo, and use Agent Ransack on my local laptop to find specific files by key words or phrases.

That's a good combination. Easy to get to from anywhere on the Internet and also you can search them. I'm going to have to look into this agent ransack thing, but the word "ransack" has really put me off it. Many here have mentioned agent ransack.

cwjinc1-Dec-20 6:32

cwjinc

1-Dec-20 6:32

Create views with meaningful names?
Isn't that what views are for?

raddevus1-Dec-20 9:00

1-Dec-20 9:00

That's a good thing. I'm more talking about a way to get to old SQL queries / Stored Procs (SP) I've written in past to solve problems which I can use again to solve new problems --- after slightly altering them.
I'm talking about query design and SP creation and managing these old queries I have worked through to get to the answer. I often create some cool query and then 3 years from now I totally forget how i did it.

cwjinc1-Dec-20 16:55

cwjinc

1-Dec-20 16:55

Oh, for that I create sql files and store them on servers with multiple backup avenues.
Then I forget where they are and run to the internet to look up ways to solve the problems I can't remember the solutions to. Wink | ;)

raddevus1-Dec-20 17:41

1-Dec-20 17:41

Member 8234139 wrote:
Oh, for that I create sql files and store them on servers with multiple backup avenues.
Then I forget where they are and run to the internet to look up ways to solve the problems I can't remember the solutions to.

That's exactly my method. Laugh | :laugh:

Choroid1-Dec-20 6:41

Choroid

1-Dec-20 6:41

I wrote a little program called Code Vault it lets me name the snippet of code with a date saved and the code It is searchable from experience it needs a one character field where you enter C for create or U for Update need to rewrite it as it is in VB 6 Just a suggestion

raddevus1-Dec-20 9:01

1-Dec-20 9:01

Yeah a SQL-Vault is the type of thing I'm talking about. It would be nice.

Choroid21-Dec-20 5:41

Choroid

21-Dec-20 5:41

Sorry for the late reply been working at the hospital a lot
You can find my GitHub here look for PW Keeper

https://github.com/e-d-n/A-Free-Offer

Enter this link in the ADDRESS FIELD not the SEARCH FIELD

Member 109454291-Dec-20 7:39

Member 10945429

1-Dec-20 7:39

Why use text files? A database can store strings. So if you want searchable storage of queries why not make a table?

raddevus1-Dec-20 9:02

1-Dec-20 9:02

Yes, I'll query the database for the query that I need so I can query the database. Laugh | :laugh:

You are correct though. I'm thinking more of a SQL-Manager that allows me to file away SQL queries with a good summary of what it does and keywords for finding.

Member 109454291-Dec-20 9:30

Member 10945429

1-Dec-20 9:30

So you mean a separate database of queries that hold the queries that you can query so you can query the other database? Big Grin | :-D

Maybe OneNote is what you want.

Mark Starr1-Dec-20 8:57

Mark Starr

1-Dec-20 8:57

So, it depends on which interface you're using.

If you're using Management Studio you can save frequently-used queries in 2 places (I've used both over the years):

1) Create a 'Project' (File / New / Project / SQL Server Scripts) and save .SQL files into that project. Kinda clunky for organization, but workable. I used this method as a default, and used file naming for file sorting and commented keywords for searches. Sometimes you have to open the project file and manually rearrange the file references.

2) use the Code Snippets Manager (Tools / Code Snippet Manager) You can create your own Groups and add scripts to existing or new Groups. pretty handy, a little clunky, but it works. I used this area for some very-frequently-used utility scripts.

If this info is coming to you late, well - I read your thread early this morning, but didn't get to my computer till now. Take it for what its worth.

Cheers,

Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall

Mark
Just another cog in the wheel

Mark Starr1-Dec-20 8:59

Mark Starr

1-Dec-20 8:59

Oh, by the way: if you use Option 1 (SQL files and SQL Project) you can use version control so as to not lose files or their contents.

Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall

Mark
Just another cog in the wheel

raddevus1-Dec-20 9:04

1-Dec-20 9:04

This is good stuff. I will read over this again and try it out. Thanks very much for reading and posting. Thumbs Up | :thumbsup:

Mark Starr1-Dec-20 9:17

Mark Starr

1-Dec-20 9:17

Sure. No prob. If you have any questions, please send them.

Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall

Mark
Just another cog in the wheel

Throw away your iPhone!

OriginalGriff30-Nov-20 6:41

30-Nov-20 6:41

Apple maps has competition![^]

I can see so many reasons why it never caught on ... Laugh | :laugh:

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

raddevus30-Nov-20 8:09

30-Nov-20 8:09

That's the most amazing technology and amazing thing that some GENIUS put their mind to solving.

Also, it is the utterly the stupidest thing someone has ever even thought about doing.

This is the idiot-genius at work!!! We need more products from this type of individual. Laugh | :laugh:

OriginalGriff30-Nov-20 8:57

30-Nov-20 8:57

Actually, with enough infrastructure in place it could work.
It's accurate over around twenty miles, so you'd need hubs every 20 miles. Each hub contains cassettes with direction to every location within the twenty mile range, including all the neighbouring hubs.
You drive to a hub, get the next hub cassette, drive there, hand it over and get the next, and so on until you reach your target hub and collect the "local destination" cassette.

With enough tapes and trucks to return them to the appropriate hubs, it'd work. Total Genius!

But it's spectacularly inefficient, and a bloody stupid idea! Big Grin | :-D

raddevus30-Nov-20 10:55

30-Nov-20 10:55

OriginalGriff wrote:
Total Genius!

But it's spectacularly inefficient, and a bloody stupid idea!

Just like twitter. Roll eyes | :rolleyes:

We must promote this and get everyone to use it.

OriginalGriff30-Nov-20 10:59

30-Nov-20 10:59

Well ... it'd sell well to hipsters ... :EvilGrinSmiley:

raddevus30-Nov-20 11:05

30-Nov-20 11:05

Once the "right people" used it and blathered on and on about it every day everywhere then it'd be a huge success. Then they'd say, "Well, it's Science, so of course we are using it." And then you wouldn't be allowed to ignore it, because if you did then they'd call you a flat-earther and a rube. That's when you know you have a really great product. Roll eyes | :rolleyes:

Dan Neely30-Nov-20 8:14

Dan Neely

30-Nov-20 8:14

There was an even earlier US prototype that showed sequential printed instructions; IIRC from the 20s or 30s and covering trips around NYC.

Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

Thought of the Day

OriginalGriff30-Nov-20 4:37