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...

Fiesta

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(

...

Not sure how to do it either if you don't give sample data and expected results.

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...

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...

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...

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

...

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...

djj (8/24/2015)

---

GilaMonster (8/24/2015)

---

I think it's in anticipation of my Star Wars RPG tonight. The puny resistance movement will be crushed under the might of the Imperial Army. The Emperor has...

Mickey

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...

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...

Does this mean that you don't have foreign key constraints in place?

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...