Viewing 15 posts - 1 through 15 (of 23 total)
When Agile is used for rapid feedback with responsive customers it can be an effective way to flush out system requirements. I've more often seen Agile used as cover for...
July 1, 2024 at 8:45 pm
Tons of gold in there about integrity, commitment, and building trust.
Environments that punish mistakes are usually miserable and have high turn-over rates. I saw this in the Air Force and...
March 11, 2024 at 1:46 pm
Any chance of restoring to another server and copying the data?
March 30, 2023 at 7:10 pm
If you suspect that it contains a special character you could try a numbers table and cross join.
The query would look something like this:
SELECTn.num, ASCII(SUBSTRING(t.charFld, n.num, 1))...
March 29, 2023 at 4:33 pm
The biggest problem in this decision is when are technology companies allowed to promote or suppress content? It starts getting very sticky when employees of these technology companies start promoting...
March 29, 2023 at 4:10 pm
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
Viewing 15 posts - 1 through 15 (of 23 total)