Click here to Skip to main content
14,843,944 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Controversial: SQL Pin
Brian Battles1-Dec-20 2:38
MemberBrian Battles1-Dec-20 2:38 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 2:51
mvaraddevus1-Dec-20 2:51 
GeneralRe: Controversial: SQL Pin
ElectronProgrammer1-Dec-20 2:40
MemberElectronProgrammer1-Dec-20 2:40 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 2:53
mvaraddevus1-Dec-20 2:53 
GeneralRe: Controversial: SQL Pin
ElectronProgrammer1-Dec-20 4:03
MemberElectronProgrammer1-Dec-20 4:03 
GeneralRe: Controversial: SQL Pin
Rusty Bullet1-Dec-20 3:19
MemberRusty Bullet1-Dec-20 3:19 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 3:35
mvaraddevus1-Dec-20 3:35 
GeneralRe: Controversial: SQL Pin
rnbergren1-Dec-20 3:14
Memberrnbergren1-Dec-20 3:14 
I am always late to the party. HAHAHA. But then I get to read everyone elses comments before I make my own.

What I use is a blend of notepad++ or SSMS and multiple fairly large what I call scratch files. For differing companies and projects I create a scratch SQL project which is mostly commented out sql that includes databases, SPs, Views etc... and then one or 15 differing select statements/kewl sql statements that work for this database scheme.

Then I use Agent Ransack when I am searching for something esoteric that I need for a new client/project.

It works for me and I usually end up cobbling something together from inside the scratch file then copying and pasting into a new SQL for the new SP or View and away I go.

What works for you I guess. PS I do love Agent Ransack.
To err is human to really mess up you need a computer

GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 3:37
mvaraddevus1-Dec-20 3:37 
GeneralRe: Controversial: SQL Pin
obermd1-Dec-20 3:31
Memberobermd1-Dec-20 3:31 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 3:54
mvaraddevus1-Dec-20 3:54 
GeneralRe: Controversial: SQL Pin
AndrewGT1-Dec-20 3:36
MemberAndrewGT1-Dec-20 3:36 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 3:55
mvaraddevus1-Dec-20 3:55 
GeneralRe: Controversial: SQL Pin
Marc Clifton1-Dec-20 4:11
mvaMarc Clifton1-Dec-20 4:11 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 8:53
mvaraddevus1-Dec-20 8:53 
GeneralRe: Controversial: SQL Pin
Matt McGuire1-Dec-20 4:44
professionalMatt McGuire1-Dec-20 4:44 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 8:56
mvaraddevus1-Dec-20 8:56 
GeneralRe: Controversial: SQL Pin
Matt McGuire2-Dec-20 4:47
professionalMatt McGuire2-Dec-20 4:47 
GeneralRe: Controversial: SQL Pin
raddevus2-Dec-20 5:19
mvaraddevus2-Dec-20 5:19 
GeneralRe: Controversial: SQL Pin
MSBassSinger1-Dec-20 6:20
professionalMSBassSinger1-Dec-20 6:20 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 8:58
mvaraddevus1-Dec-20 8:58 
GeneralRe: Controversial: SQL Pin
Member 82341391-Dec-20 6:32
MemberMember 82341391-Dec-20 6:32 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 9:00
mvaraddevus1-Dec-20 9:00 
GeneralRe: Controversial: SQL Pin
Member 82341391-Dec-20 16:55
MemberMember 82341391-Dec-20 16:55 
GeneralRe: Controversial: SQL Pin
raddevus1-Dec-20 17:41
mvaraddevus1-Dec-20 17:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.