Activity overview
Latest activity by tshad
I don't know if it matters but I am on SQL Server 2008 R2. / comments
I don't know if it matters but I am on SQL Server 2008 R2.
I just loaded the newest version of SQL Prompt and I still get nothing back. It is not working at all. / comments
I just loaded the newest version of SQL Prompt and I still get nothing back. It is not working at all.
I am running SQL Search 3.2.7.2379 and SQL Prompt 9.5.8.10521. I also search on "SELECT" and that doesn't work. I also reindexed and that doesn't seem to help. / comments
I am running SQL Search 3.2.7.2379 and SQL Prompt 9.5.8.10521. I also search on "SELECT" and that doesn't work. I also reindexed and that doesn't seem to help.
Not working well
I cannot typically get results using this anymore. It used to work real well. For example, I have "PATH" as my search and no matter what object types I choose or whole words or wildcards, I get n...
Not returning results when they are there.
I am trying to find any results on a value iMenuItem_id.I know that exists. I do a select on a table that has it - and it is there. But SQLSearch is showing nothing.I have it set for all object t...
Sql Prompt not showing format sql on right click
I just set up Sql Prompt 6 on my new machine and when I right click the query page, I am not seeing the sql prompt stuff such as format sql.
I now have to go to the menu to format which I didn't ha...
After a certain amount of characters it quits formatting
Here is part of a faily long nested CTE. The whole query formats fine except for this section which starts at character 63. FeeType ,
FeeSubType ,
...
CTE not formatting correctly.
There are actually 3 issues for this example
If you have the following:
CREATE PROC test
@Var1 int,
@Var2 varbinary(50)
AS
-- read Dealer table
;WITH MyDealerCTE
AS
(
SELECT * FROM db...
Also, I did try to delete all the projects and recreate them but that didn't seem to work.
Thanks,
Tom / comments
Also, I did try to delete all the projects and recreate them but that didn't seem to work.
Thanks,
Tom