Unfortunately, your sample data cannot be used since there are a few tabl DDL missing. Please modify.

It looks like it's possible to replace one or two of the UNION with a CASE statement.

It also migt be a good idea to use the "divide'n'conquer" method, meaning to...

Please decide by yourself which option is easier to read....

DECLARE @tbl TABLE

(

id INT, name VARCHAR(30)

)

INSERT INTO @tbl SELECT 1 ,'x'

-- option a

SELECT 'id' AS col1,CAST(id AS...

duplicate post.

please continue at http://www.sqlservercentral.com/Forums/FindPost1006219.aspx

What is the message you're trying to bring across with that statement? Sounds incomplete...

The question was not about the order...

Unfortunately, it seems like you didn't read the article yet.

I tried to import the xls data you provided but the time columns will remain empty even if it seems like...

ashkan siroos (10/17/2010)

---

Dear Lutz,

I didn't mean that , and i know you help me and all people because of your kindness.

I will attache those immediately, and if i said...

Ashkan,

did you read the article I pointed you at?

The purpose of posting table def and sample data in a ready to use format is to help us help you.

We are...

It depends.

Sounds like an interview question (at least in combination with your other question at the very same time)

It depends.

Sounds like an interview question (at least in combination with your other question at the very same time)

It depends.

Sounds like an interview question (at least in combination with your other question at the very same time)

I don't think there is a c.u.r.s.o.r *cough* needed...

But in order to show a set based solution I'd like to see table def for cardtime.dbo.inout and cardtime.dbo.WatchBuilding including some sample...

Sounds like a homework question.

If you use the answer from above without quoting the source (therewith stating it's not your solution) it'll be considered as plagiarism. It's cheating anyway.

Another story...

How about this?

;WITH cte AS

-- split each string by character and decide UPPER or lower based on previous character or being the first char

(

SELECT

N,

Id,

CASE

WHEN N=1...

Due to the table and column names I'd guess we're talking about a database that needs to be compliant with...