Viewing 15 posts - 4,321 through 4,335 (of 8,731 total)
That process will change all the text that contains your database name. So, unless you have something really unique, it might cause problems and won't be safe to execute this...
August 26, 2015 at 1:37 pm
eccentricDBA (8/26/2015)
Ed Wagner (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
crookj (8/26/2015)
whereisSQL? (8/26/2015)
Ed Wagner (8/26/2015)
FireDrill
Dentist
Shot
Tequila
Sunrise
Siesta
Fiesta
August 26, 2015 at 1:09 pm
Without knowing the data types of your table, here's an example set to help you understand what's going on and how to fix your problem.
CREATE TABLE #TestDate(
...
August 26, 2015 at 12:49 pm
lcarrethers (8/26/2015)
Not sure how I would add it to the derived subquery
Not sure how to do it either if you don't give sample data and expected results.
August 26, 2015 at 8:41 am
From a quick search on the firebird documentation, which almost made me believe that it wouldn't have a SUM() function, this seems to be close to what you need.
SELECT part.num...
August 26, 2015 at 8:35 am
The createdon column is not included in the derived table (subquery).
I'm not sure if you need to include it, or if you need to join the derived table to the...
August 26, 2015 at 8:18 am
I agree with Ed, You might only need a SUM() with GROUP BY.
It seems that you're not using your derived table "labor", so you might be able to remove it.
Do...
August 25, 2015 at 11:47 am
Try this formula:
--DATEADD( wk, DATEDIFF( dd, 0, @dt)/7,0)
SELECT dt, DATEADD( wk, DATEDIFF( dd, 0, dt)/7,0)
FROM (SELECT TOP 30
...
August 25, 2015 at 10:37 am
Maybe that's a result of using a template which included that part. Or probably it was just included to comply with code standards that only require a catch block without...
August 24, 2015 at 12:03 pm
djj (8/24/2015)
GilaMonster (8/24/2015)
August 24, 2015 at 11:30 am
whereisSQL? (8/24/2015)
Ed Wagner (8/24/2015)
TomThomson (8/24/2015)
SQLRNNR (8/24/2015)
oeufrevuelto
Pistol
Pete
Mickey
August 24, 2015 at 10:36 am
If there's a foreign key, the trigger must be on the details table as its contents will be deleted before the header. You also don't need to loop to create...
August 24, 2015 at 10:35 am
The problem is that your concatenation creates a varchar(8000) string which is then converted to be stored in a varchar(max).
In both test 2 and 3, it gets truncated in the...
August 24, 2015 at 10:02 am
Does this mean that you don't have foreign key constraints in place?
August 24, 2015 at 9:41 am
The problem of using the config table is that you might need to change the code to dynamic SQL.
That's not necessarily a bad thing, but might need a careful planning...
August 24, 2015 at 9:16 am
Viewing 15 posts - 4,321 through 4,335 (of 8,731 total)