How can we help you today? How can we help you today?
James R
Activity overview Badges (0) Posts (1) Comments (103)

Comments

Sort by recent activity
Hmm, strange. I''ll have a go and see if I can reproduce it here and get back to you. Sorry for the inconvenience! Thanks, James / comments
  1. Community
  2. SQL Prompt
  3. Using SQL Prompt with two SSMS instances
Hmm, strange. I''ll have a go and see if I can reproduce it here and get back to you. Sorry for the inconvenience! Thanks, James
0 votes
Hey @ogrishman, thanks for the post. If possible, can you give me some more information on this issue? Do you have a custom snippets folder? Where do the snippets not appear? In the snippets manager or just the suggestions box? Thanks for the help! James / comments
  1. Community
  2. SQL Prompt
  3. Using SQL Prompt with two SSMS instances
Hey @ogrishman, thanks for the post. If possible, can you give me some more information on this issue? Do you have a custom snippets folder? Where do the snippets not appear? In the snippets manage...
0 votes
Hi Hugo, thanks for your post. From what I can tell on my end the first issue is fixed on the latest version as well as the issue with the alias qualification. I could use a bit of clarification to help us understand the second issue, as from what I can tell the produced SQL is valid (if you remove the incorrect p.Class column). If you don't want to remove square brackets on format you can turn it off by going to SQL Prompt > Options > Format > Styles > Add / Remove square brackets. Hope this helps, and I would recommend upgrading to the latest version if you can! Thanks, James / comments
  1. Community
  2. SQL Prompt
  3. Issues with PIVOT
Hi Hugo, thanks for your post. From what I can tell on my end the first issue is fixed on the latest version as well as the issue with the alias qualification. I could use a bit of clarification to...
0 votes
Hey Hugo, Is the necessity of those square brackets an option set on your SQL Server instance or something similar? Because I can run that query fine locally against my local database. Forgive me if I'm missing anything obvious! Regards, James / comments
  1. Community
  2. SQL Prompt
  3. Issues with PIVOT
Hey Hugo, Is the necessity of those square brackets an option set on your SQL Server instance or something similar? Because I can run that query fine locally against my local database. Forgive me i...
0 votes
Strange. What do you mean when you are unable to get any suggestions to work? Are there any errors in the logs? James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 8 and SSMS 2017 issue
Strange. What do you mean when you are unable to get any suggestions to work? Are there any errors in the logs? James
0 votes
That's very strange. Can you try downgrading to the latest release and see if that fixes it? / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 8 and SSMS 2017 issue
That's very strange. Can you try downgrading to the latest release and see if that fixes it?
0 votes
Hey all, I've been trying out a fix for this issue, can you please download this build and see if it's resolved? Sorry for the inconvenience! James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 8 and SSMS 2017 issue
Hey all, I've been trying out a fix for this issue, can you please download this build and see if it's resolved? Sorry for the inconvenience! James
0 votes
Hi guys, thanks for the information. I can't seem to reproduce this easily on my end, could you let me know what versions of SQL Prompt you are using and what versions of SQL Server you are trying to connect to? Older versions of SQL Prompt 8 don't have SQL Server 2017 support. Thanks again! James / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 8 and SSMS 2017 issue
Hi guys, thanks for the information. I can't seem to reproduce this easily on my end, could you let me know what versions of SQL Prompt you are using and what versions of SQL Server you are trying ...
0 votes
Hi all, I'm looking into this now and just want to double check a few things. Do you have the SQL Prompt > Options > Connections > Load referenced databases option selected? What type of remote servers are you referencing in your synonyms. Are they linked servers to the current server? Thanks for the help! James / comments
  1. Community
  2. SQL Prompt
  3. Synonyms and SQL Prompt not working as expected
Hi all, I'm looking into this now and just want to double check a few things. Do you have the SQL Prompt > Options > Connections > Load referenced databases option selected? What type of remote ser...
0 votes
Hi @AndrewJacksonZA , Thanks for your post! I think the option you're looking for is under Expressions > Operators > Comparison and arithmetic > Align comparison operators. I think it would make a lot of sense for a search for "equals" or "=" to highlight this, so we'll try to get that working soon. Please let us know if that works for you. Regards, James / comments
  1. Community
  2. SQL Prompt
  3. Formatting Issue - Alignment of Equals Signs "=" on JOINs
Hi @AndrewJacksonZA , Thanks for your post! I think the option you're looking for is under Expressions > Operators > Comparison and arithmetic > Align comparison operators. I think it would make a ...
0 votes
Total activity
179
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
75