I am extremely confused on what you want to do here. Initially I thought what you wanted was ROW_NUMBER with partition but you posted the query that will do that....

I second reading the article by Gail. Also, why all the NOLOCK hints? Are you aware of the possible risks using that?

harri.reddy (11/9/2012)

---

but when you insert record from ssis and in table i have identity column.

the first record should be like this

1 ...

I would agree bterraberry about using cross apply here.

To directly answer your question I think you need something like this...

select Main.*,

(Select TOP 1

case when f.objectName 'Anesthesia_Type!Anesthesia_Post_Note' = 'TRUE'...

harri.reddy (11/9/2012)

---

hi,

in my data viewer i am seeing correct data,but when i see in the table,its not ordered.

i have identity column so it should start by 1.

but when do something...

You can't have an order by in a subquery like that. You need to include the ID column in your subquery and then use the Order by on the main...

LANdango.com (11/9/2012)

---

The anwers above are pretty good; however, there's a short cut. use XML. In just a few lines you can get what you want and the performance is...

dedicatedtosql (11/8/2012)

---

Hi All,

Recently some one deleted some rows from a table. I was asked to find out who did it. Since the log has not been backed up since the...

My apologies for not providing you the answer you were looking for in your other thread. I thought that this was an extension of your previous issue. I didn't realize...

IF the column in varchar you could do something like this.

;with data (SomeVal) as

(

select '480.90' union all

select '480.91' union all

select '48090' union all

select '48091'

)

select case charindex('.', SomeVal, 0) when 0...

So you have already loaded this data into a table and some of the rows contain decimal places and other do not? And you want to add the decimal place...

dj1202 (11/8/2012)

---

Hello everyone, I have 3 fields, all text strings but all supposed to represent dates.

Field 1: varchar in the format of '20121108'.

Field 2 and 3: varchar string...

michielbijnen (11/8/2012)

---

I would like to have a number of kpi's in my organisation per costcenter into a html-table to be mailed to the manager of that costcenter.

I know how to...

That worked. Now of course all of this is because you don't seem to be able to test this. I am still confused how you think the trigger I posted...

Again I will assume you did NOT test what you posted. It is full of issues.

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near 'BOA'.

Msg 102, Level 15, State...