Something like this?

WITH Digits(D) AS -- Digits 0 to 9

(

SELECT

D

FROM

(

VALUES (0), (1), (2), (3),...

I guess Paul will tell you...

I agree with Sean that there is no bullet-proof solution for an arbitrary input set. However, if the number of dates in the input is large enough and distributed, one...

Just prefix the id's in the TreeOrder column with an appropriate number of zeros's.

Test setup

Declare @table table(SModuleId Int, ModuleId Int, SMName Varchar(100), LinkOrder Int, ParentId int, Level int, Root int,...

Another one.

select

d,

cast(stuff(stuff(replace(d, ' ', ' ' + replicate('0', 15 - len(d))), 14, 0, ':'), 12, 0, ':') as datetime) dt

from

(

values('20100228 124556'), ('20101231 52834'),...

Great. To make it a little bit more elegant you could replace the CASE expression with a COALESCE function:

SELECT

ID,

COALESCE(NULLIF(LExecuted, ''), NULLIF(LB_Submitted, ''), MAX(CAST(AnyDate AS DATETIME))) AnyDate

FROM

...

You posted in a SQL 2008 forum, so I gave you a SQL 2008 solution. CROSS APPLY works in SQL 2005, it´s the row constructor VALUES which causes the syntax...

One way to go:

DECLARE @T TABLE (ID INT PRIMARY KEY, SentDate VARCHAR(10), ReceivedDate VARCHAR(10), CreatedDate VARCHAR(10))

INSERT INTO

@T

VALUES

(1, NULL, '2-11-2012', NULL),

(2, '22-10-2012', NULL, '2-12-2012'),

...

You can try something like this (requires only a single table scan):

SELECT

@abc = COUNT(CASE WHEN ColumnName LIKE '%abc%' THEN 1 END),

@def = COUNT(CASE WHEN ColumnName LIKE '%def%'...

Take a look at this thread http://www.sqlservercentral.com/Forums/FindPost1313092.aspx. Paul White gives a very reasonable explanation (and solution) about this error.

Too...

ScottPletcher (9/14/2012)

---

I never stated, or implied, that the comments would affect the execution time (I said "procedure cache", not "plan cache"; I know some people use them interchangeably, but I...

Looking at the syntax definition of the FROM clause the binding error makes perfect sense.

[ FROM { <table_source> } [ ,...n ] ]

<table_source> ::=

{

...

To do it in a single load, you can use a query like

;WITH OrderedALog AS

(

SELECT

Aid, ACode, ATimestamp,

ROW_NUMBER() OVER (PARTITION...

Assuming that the TradeID column is unique (primary key?), why not use a UNION ALL instead of UNION. This avoids a (expensive) distinct sort to filter out nonexisting duplicates. Still,...