can someone tell me why I am getting this error:

Conversion from string "INSERT INTO DATALOAD_ERROR_LOG(E" to type 'Double' is not valid.

Both columns EL_ErrorCode,EL_ErrorDescription are of datatype nvarchar(1000)

But I have to insert in sql table only...

I am getting error in my code below:

Public Sub Main()

Dim iErrorCode As Integer =...

I tried in this manner but its not working..............

Public Sub Main()

Dim iErrorCode As Integer = _

...

Koen Verbeeck (2/11/2014)

---

kapil_kk (2/11/2014)

---

Koen Verbeeck (2/11/2014)

---

You are getting performance issues because the PK is an identity?

The primary key is already unique, so adding extra columns doesn't make it more unique.

It...

Koen Verbeeck (2/11/2014)

---

You are getting performance issues because the PK is an identity?

The primary key is already unique, so adding extra columns doesn't make it more unique.

It seems you are...

Koen Verbeeck (2/11/2014)

---

kapil_kk (2/11/2014)

---

There is anthor columns also...

there is an Identity column which is currently defined as PK so I...

There is anthor columns also...

there is an Identity column which is currently defined as PK so I want to add...

ChrisM@Work (2/10/2014)

---

kapil_kk (2/10/2014)

---

ChrisM@Work (2/10/2014)

---

balu.arunkumar (2/10/2014)

---

Hi This part shows error.

/*------------------------

SELECT*, SUM( Price ) OVER( Partition BY Customer_Name ORDER BY DatePurchased) AS Total_Till_Date

FROM#sample where Customer_Name='A'

------------------------*/

Msg 102, Level 15, State 1, Line 1

Incorrect...

ChrisM@Work (2/10/2014)

---

balu.arunkumar (2/10/2014)

---

Hi This part shows error.

/*------------------------

SELECT*, SUM( Price ) OVER( Partition BY Customer_Name ORDER BY DatePurchased) AS Total_Till_Date

FROM#sample where Customer_Name='A'

------------------------*/

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near...

hi TRY THIS ONE:

;with cte as

(

select CUSTOMER_NAME, SUM(PRICE) AS TOTAL_PRICE , max(DATEPURCHASED)DATEPURCHASED, ROW_NUMBER() OVER (PARTITION BY CUSTOMER_NAME ORDER BY CUSTOMER_NAME) RN

FROM #SAMPLE

GROUP BY CUSTOMER_NAME

HAVING SUM(PRICE) > 1000

)

SELECT

DISTINCT S.CUSTOMER_NAME, C.TOTAL_PRICE,...

you can also try this:

select top 10 er.session_id, db.name as DBName,

blocking_session_id,

substring(st.text,(er.statement_start_offset/2) + 1,

((case statement_end_offset when -1 then datalength(st.text)

else er.statement_end_offset end - er.statement_start_offset)/2) + 1) as statement_text ,

cpu_time,

total_elapsed_time,

reads,writes,logical_reads,

objectid

session_id,

status

,command,

er.database_id,

wait_type,wait_time,

last_wait_type

,text

from sys.dm_exec_requests er...

ohhh I typed incorrectly here... but after make correction also its not working

I already posted a...

ChrisM@Work (1/30/2014)

---

Let's say you have a "dupe pair" of rows in your source table - dupes on the basis of a unique key on one or more columns.

Does it...

No it will not empty..