Yes I agree with you , when u say its going to be incredibly inefficient. ...

Like wise, assuming you are looking at the first 6 characters.

SELECT ID FROM

(SELECT SUBSTRING(ID,1,6) ID,COUNT(1)x FROM #T

GROUP BY SUBSTRING(ID,1,6))D WHERE D.x>1

saputra.budi (12/9/2012)

---

its working using numeric conversion. thanks for the help.

but just want to know more about my problem.

well actually i dont need the decimal value, because in my code have...

saputra.budi (12/9/2012)

---

i have a query :

select c.kode,cast(Right(c.kode,5) as integer) as NOSKM from cachekomponen c, barang b

where c.kode=b.kode and b.proses='CBC' and c.owner='1A.0001'

order by cast(Right(c.kode,5) as integer)

the sql server give me: Msg...

Ok Found out there is recordset destination-never used that one.Anything to add?

I really appreciate the way how most of the frequent SQL gurus at SQL central try to feed the concept instead of just providing the answers.

balasach82 (6/16/2012)

---

is it possible to give an SELECT statement ...ORDER BY but the field in ORDER BY clause would not be in SELECT list.

Like ...

SELECT F1, F2, F3 from...

Thomas Striinger (5/18/2012)

---

It all depends on exactly what the jobs are doing. You're basically seeing maximum concurrency (or close to it at least). We need to know a...

seth delconte (5/15/2012)

---

Yes - when you use the 'WHEN NOT MATCHED BY' clause, you have to use the keywords 'SOURCE' or 'TARGET'. However, it's ok to alias your actual...

(' select ?= replace((cast(convert(date,min(lastrundate))as varchar)),'-','') from TableA

I can't figure out what is wrong with this code? I am using above code in Excute Sql Task to get the minimum date...

Raja Suman (5/11/2012)

---

You can use a EXEC SQL Task, fetch the column value from a table and pass it to a parameter. Attached images might help you.

Here, I am fetching...

Well honestly, i thought of it too...

vinu512 (5/9/2012)

---

I haven't worked with SAP enough to tell you about Joining tables from SQL server with SAP tables. But you can import data from SAP into SQL Server USING...

Daniel Bowlin (5/8/2012)

---

Why can't you use a derived column, or a data conversion transform to change the data to like formats and types and then use your lookup or merge...

Jayanth_Kurup (5/8/2012)

---

if you have a column other than the date time which can be used to identify the deltas that would be your best bet, Mainly becuase datetimes have problems...