Which 1 record you want to see in result in case if multiple are found for the same ID?

If you also want to return records where Oppo_stage != 'Bus_Written' (wthout any other checks for date (closed)) then try this:

Select

oppo_opportunityref

,oppo_stage

...

Just in case if you will need to pass string without any space:

SELECT LEFT(val,ISNULL(NULLIF(CHARINDEX('...

SQLKnowItAll (5/10/2013)

---

Eugene Elutin (5/10/2013)

---

NOLOCK is kind of dice - it may turn any side.

It can read some data which...

NOLOCK is kind of dice - it may turn any side.

It can read some data which not yet committed,...

Check DDL of your DIM_TEMPS table. Some varchar values you are inserting fail to convert into datetime, so it will be related to datetime columns of this table.

El_Mou (5/10/2013)

---

yes i set the language i did it but still having the same message error

its supposed work fine ( of course with setting the language in conversion...

cyberdaemon (5/10/2013)

---

Good day,

Sad to say that i dont have the previledges to view the DDL of spQuery_GetSequenceNo that given to me.

@chrism-2@Work

is set the value of the DPNUmber,amounttobepaid,paymentdate once the user...

Ok, please see how the same thing can be done wihtou using any loop:

CREATE PROCEDURE [dbo].[PS_DIM_TEMPS] /*(@Date_debut varchar(10), @Date_fin varchar(10))*/

AS

truncate table DWProd.dbo.DIM_TEMPS

declare @D_DEBUT datetime

declare @D_FIN datetime

BEGIN

/*set @D_DEBUT = @Date_debut

set @D_FIN...

could you please post DDL for spQuery_GetSequenceNo. I have a suspicion that is not returning number as a result. It may be doing it through output parameter...

kimreyj (5/9/2013)

---

Just curious - what are the various options available for testing t-sql code in stored procedures?

Specifically how can one step through code as would be done with a .net...

I wonder, if you could discuss questions with interviewer or it was just written test?

Not long ago I was on the interview, where the interviewer asked me to do...

aslamshaik6 (5/9/2013)

---

i have a table where i need to populate child table in parents table i have a column which is a surrogate key and this same column is PK...

Lynn Pettis (5/9/2013)

---

Eugene Elutin (5/9/2013)

---

Lynn Pettis (5/8/2013)

---

Eugene Elutin (5/8/2013)

---

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you...

http://www.sqlservercentral.com/Forums/Topic599611-149-3.aspx#bm602471