You should not be using the arithmetic subtraction operator to calculate differences between date or time expressions. Subtract will only work with the old DATETIME and SMALLDATETIME data types....

What he's trying to do is set up a key code to run a procedure, so that he can highlight a section of text in a query and hit the...

First, this is an SSIS issue, not a T-SQL question, so it should really be posted in the SSIS forum.

The problem is that Excel determines the field lengths/types by sampling...

Fuel type is stored in an attribute of the Fuel element, so you need to give the path to that attribute rather than referencing the element itself.

c3.value('@type', 'varchar(30)') AS [Fuel...

Slightly shorter

DECLARE @Sort1 varchar(10)='val3'; --NOTE: @Sort2 ommitted from this example because I am still stuck on @sort1

--DECLARE @Sort1 varchar(10)='val3';

DECLARE @x TABLE (val1 varchar(10) not null, val2 varchar(10) not null,val3 int);

INSERT...

WITH ROLLUP is being deprecated in favor of the ROLLUP() function. Here is the query rewritten using the ROLLUP() function.

;WITH CTE0 AS

(

SELECT Section

,NAME

,RowOrdering = ROW_NUMBER() OVER (ORDER BY Section,...

First, your XML is not valid. You can only assign values to attributes and you are trying to assign them to the tag.

<TOP_LEVEL_ITEM= "TOP LEVEL TYPE A" TOP_LEVEL_ID="294">

This needs...

Jeff Moden (2/15/2013)

---

I've found that to be a wee bit more difficult than you would think unless you have an alternate...

The solution provided in your link is likely to be the fastest. (It essentially the same as what Paul is suggesting, but limiting the buckets to only the specific...

No, but the syntax was changed...

MyDoggieJessie (2/8/2013)

---

Yes, good catch. Based upon Lynn's suggestion I changed the code to store the data from the CTE's locally...so now I do use both CTE's as I insert...

You're not using the Txn CTE anywhere in your UPDATE statement, so you can drop it without changing the results of your query. I believe that is the worktable...

ScottPletcher (1/21/2013)

---

Huh? I don't see anywhere a "datetime" data type is specified, only varchar. I don't see why the code couldn't run fine as is.

I guess your...

Especially since WITH CUBE and WITH...

Your attached query has a similar problem. The optional FROM clause in a SELECT statement is the same as in a DELETE statement.

1) The FROM keyword...