Activity overview
Latest activity by broye
How do I get rid of informatory message of missing Schema in Query
I want to eliminate the informatory message of missing schema when I am writing a query. I don't want it or need it.
Thank Dan_J. By making me sit down and replicate my problem I found the answer. There is an 'Add Commas' and 'Add Commas and Quotes" in the SQL Prompt software.
First I started a basic SELECT FROM TABLE WHERE FIELD IN (,
I then cut and pasted a column from a previous SELECT
I won't post those steps but the next two images show how I get the Commas added: [image] I first click on the red comic book dialog bubble on the let; I scroll past first set of options and lo and behold; I selected the add commas option.[image] There is my answer. It a time saver. An aside I wonder why don't more companies license your software. It is a real productivity tool. My last two employers refused to get me a license. So I invested in myself and purchased the software. / comments
Thank Dan_J. By making me sit down and replicate my problem I found the answer. There is an 'Add Commas' and 'Add Commas and Quotes" in the SQL Prompt software.
First I started a basic SELECT FR...
How do you 'fast path' inputting a column of data and formatting with comma separators and quotes ?
I am doing a SELECT; the WHERE IN has many entries. if I cut and paste the column of arguments from an excel spreadsheet or a SQL query how can I cut, paste them in parenthesis then highlight them...
James I will give this a try and report my findings. Thanks. / comments
James I will give this a try and report my findings. Thanks.