Sean Lange (11/2/2012)

---

That seems like a horrible way to name your columns but in order to do that you will have to use dynamic sql. Make you sure you wrap...

Yoou really shouldn't be dealing with T-SQL if you don't know what UPDATE or EXEC are and what are they capable of doing.

Here's the script with the correction that I'm...

Try changing the EXEC (@SQLCmd) before the update.

You have your @SCLCmd Declaration in a different batch that ended at GO.

What are you trying to do?

The dynamic part is just changing the database you're on but your not...

Michael Valentine Jones (11/1/2012)

---

There is a good chance that all the space is being used by the transaction log. If the database is in full recovery mode and you...

Out of curiosity, have you tried the import/export wizard?

It's a simple tool, just be sure to read all the options available.

mickyT (11/1/2012)

---

True :Whistling:

Not knowing what the data is for, I...

Micky,

Your first query is not sargable and that would make it pretty inefficient compared to the second one. 😉

Be careful methexis, because both queries aren't the same. One uses MAX and the other uses SUM. In this case the show the same results but it won't be like...

Would you buy it? Or would you play it?

EDIT:...

It's hard to be sure about what you need to do, but as I uderstood, you have a Sites table that is referenced by the OrderHeader table.

I'm thinking of 2...

Why? Because I get paid by line...

I knew it was doable, but I believe is better to have an explicit CREATE TABLE statement for this situations.

There's a small confusion.

INSERT INTO, won't create a table, SELECT INTO will. Example:

--This will create a table

SELECT column1, column2, column3

INTO #TempTable

FROM MyTable

--This won't

INSERT INTO #TempTable

SELECT column1, column2, column3

FROM MyTable

Now, to...

I believe there's a way to do it much simpler. But you'll need to test.

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @StartDate = '1/1/2012'

SET @EndDate = '1/31/2012'

SELECT ER.EngEquipID

,ER.Location

,ER.Cycles

,ER.DateTimeStamp

,'Labor' AS Labor

,ISNULL( A.TRANS_tambase_amt, 0)...