Try using this instead of print, which is buffered:

raiserror ('My Print Statement', 10,1) with nowait

Your inserts may be uncommitted until the cursor loop has completed, in which case you could...

It's difficult to find a question in your post. What are you observing now, and what would you like to see? Or are you looking for an explanation for an...

-- and the ddl for the table.

Can you post the script for the index?

You're...

You have a BEGIN at the top of the sproc - does it have a corresponding END?

geert.de.vylder (3/6/2013)

---

Hi all,

I adjusted the TestTables file. I included the complete Tussen_Tickets data which is actualy in our table. And I adjusted some other things.

Hope this helps.

You will find it...

--4. Find Transaction Counter

IF @Return_Message <> ''

SELECT @Transaction_Counter = [Transaction Counter] FROM Accounts

WHERE [transaction date] = '@Date_Last_Payment' AND [policy number] = @policy_number AND [transaction type] IN ('new business',...

It works for me:

declare @table table (mMonth smallint);

insert into @table values (1),(9),(11),(12);

SELECT

mMonth,

LEN(mMonth) Length,

case LEN(mMonth) when 1 then ('0'+CAST(mMonth AS VARCHAR(6))) else mMonth end formattedMMonth,

RIGHT('0'+CAST(mMonth AS...

Plateau (3/6/2013)

---

Hi Chris,

I have temporarily changed it to a varchar - in the input parameters bit however I...

You have single quoted a variable, making it a string-type constant: '@Date_Last_Payment'

Try this article[/url] by Dwain Camps.

alan_lynch (3/5/2013)

---

hi guys sorry for the confusion, all i want to do is concentrate on the first 3 columns

so if the data shows this

Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,bla

Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,different bla

Sun Microsystems,...

What results do you get, and what results are you expecting?

Try this:

RIGHT('0'+CAST(mMonth AS VARCHAR(2)),2)