Viewing 15 posts - 1 through 15 (of 18 total)
Sounds like you may want an insert/update trigger that sets or nulls out the date depending on the Amount value.
April 10, 2019 at 6:34 pm
Could create an exclusion table containing the project IDs (id/name/etc.) to ignore and use a NOT EXISTS clause on the project ID.
February 28, 2019 at 2:39 pm
Sometimes you just have to deal with entity-attribute-value tables that were created over a decade ago with dozens of filtered indexes... 🙁
I've used something similar to the following...
February 27, 2019 at 2:23 pm
Sorry - don't have a much time to explain further at the moment; but hope the examples may show revisions/use of LTRIM & RTRIM if/when needed.
DECLARE...
February 1, 2019 at 8:37 am
Just realized you may be having troubles with the ELSE clause where it may need to be another WHEN statement i.e.: WHEN (LEN(([Col1]))) = 6 AND LEFT([Col1],1) <>...
February 1, 2019 at 7:08 am
It appears to be some sort of string manipulation to standardize a date.
In the final case:
- missing a bracket: WHEN (LEN(([Col1])))
- Appears to make the...
February 1, 2019 at 7:01 am
Could step through a statement at a time or insert some logging steps to help identify which statements that are taking the most time and tune them as needed.
January 10, 2019 at 1:54 pm
Sounded like you wanted to know the inter column value of the second set, regardless of value.
SELECT jms.main, jms.sub, jms.inter, jms2.main, jms2.sub, jms2.inter
FROM jec_main_sub AS jms
INNER...
January 8, 2019 at 2:42 pm
Just some pseudo-code here:
DECLARE curEmail CURSOR FOR
SELECT DISTINCT manager_email FROM table
OPEN & FETCH into @email
-- create body
SET @body = 'please see enclosed accounts <br><html><table>'
January 3, 2019 at 7:20 am
It looks like you may need to refine the query to something like:
SELECT DISTINCT manager_email FROM table
Then the body of the email may need an addition...
January 3, 2019 at 6:59 am
Jeffery, thanks for the reply and check on my logic.
Through some iterations I lost track and conflated NOT NULL and DEFAULT value that was in the original iteration.
The...
January 3, 2019 at 6:35 am
This is actually looking like some type of AOG issue at least loosely.
Others working on this issue have found that by removing the AOG the queries work fine. Recreate...
August 9, 2018 at 11:40 am
A few quick questions to consider:
April 26, 2017 at 10:09 am
Are you connecting the computer 1 instance? Or are you attempting to use the same .mdf file as on multiple instances (2, 3, 4, and 5)?
Each SQL Server instance...
March 10, 2017 at 8:31 am
What user mode is the database in?SELECT d.name
, d.user_access_desc
FROM sys.databases AS d
;
March 10, 2017 at 8:23 am
Viewing 15 posts - 1 through 15 (of 18 total)