Viewing 15 posts - 1 through 15 (of 117 total)
The view is working now!! regardless of where its being used from. Sorry if I wasted your time
I never run queries from systemdbs, this was just laziness on my...
July 9, 2020 at 5:45 pm
Pls ignore if I've misunderstood (the grid output doesn't seem to match the query)
CAST(DATA as Date)
into your group by clause solve it. Assuming DATA is datetime...
September 19, 2019 at 9:10 am
Hi Ken - you're right - couldn't agree more.
I've contacted the vendor, I would never do this without checking first.
In this case It was more for my understanding, I've found...
September 19, 2019 at 9:04 am
No problem Phil - thank you for looking at my post
I jumped the gun somewhat, had chat with colleague. It stores next available CustID on the Application server in a...
September 13, 2019 at 6:47 pm
It’s a 3rd Party DB/App, I cannot change the tables.
September 13, 2019 at 7:28 am
Could you use an Indexed view to maintain the balance?
September 12, 2019 at 11:29 pm
Grant good question so far testing has been on Server with DBs all in SIMPLE recovery mode. It does have the option for Point in time recovery, but I'd have...
November 27, 2018 at 1:57 pm
Hi Thanks for replying.The tool (I believe is called UniTrends) is being used for file backups. It has a SQL plugin (windows service/agent) which I've installed on an SQL...
November 26, 2018 at 4:14 pm
ThanksYes the SP is in the same DB as the tables.
I wonder if somehow "delete from tbl" could find its way in the table. I would hope...
June 1, 2018 at 11:55 am
Hi The table does store SQL in one column. third party software cannot be changed. The...
June 1, 2018 at 8:33 am
First thank you v.much, without your suggestion of type conversions I wouldn't have found it.
The main view joined to a customer orders view
January 26, 2018 at 7:15 pm
Thanks A quick look indicates in the view no implicit type conversions on join criteria or where clause - however there are many in case statements e.g. [code...
January 26, 2018 at 6:12 pm
Is formatIDX_Providers a table, if it were a view you could look at it's defintion
July 19, 2016 at 2:34 am
Admin was the trick for me on 32 bit.
Have a look at
Posted by Lowell.
Do not like the idea of inprocess though
July 19, 2016 at 1:54 am
I believe that to connect to Office documents you need to use a password (even if the doc doesn't have a password)
Linked server properties --> Security tab
"Be made with...
July 18, 2016 at 12:48 am