Cursors are not Really Good or Really Bad!

They designed and should be used for relevant tasks.

However your example is not one of them...

Try to drop and recreate destination table with SET ANSI_PADDING OFF, it's still supported in SQL 2012

It's nothing to do with T-SQL or a query as query itself cannot direct its output.

You can do it in your application by handling ADO InfoMessage event.

....

Please note the importance of good code formatting - it making the code much easier to read.

Also, I would classify your query as "noodles" and suggest refactoring your inner selects...

itskanchanhere (4/19/2012)

---

Please do not use print statement in your Sp. If some one trys to execute that sp from any other client apart from SSMS it will fail since Print...

DECLARE @sql NVARCHAR(4000)

DECLARE iCursor as CURSOR FOR

SELECT MeasureID, MeasureName FROM ControlTable

OPEN iCursor

FETCH NEXT from iCursor into @MeasureID, @MeasureName

WHILE (@@FETCH_STATUS = 0)

BEGIN

--This is where I am having problem

SET @sql = 'select...

Ten Centuries rated!

Please provide DDL for both sides of REFERENCE constraint and SQL your are running.

I guess you just missing something in your order...

Build Dynamic SQL inside of cursor and execute it.

hbtkp (4/17/2012)

---

ok. i already posted my formula for cumulative.

i hv another prov

i have delcare variable

declare @abd datetime

now i need to get 1 date from function

like

select @abd = fromdate from item2(@rdfd)

fromdate...

SOURCE: [MAS90ID] [varchar](50) to DESTINATION: [MAS90ID] [nvarchar](10)

SOURCE: [SLXID] [varchar](50) to DESTINATION: [SLXID] [nvarchar](10)

Run the following:

SELECT * FROM [dbo].[Channels2] WHERE LEN(MAS90ID) > 10 OR LEN(SLXID) > 10

> So I can have different fillfactor for indexes on the same table depending on the columns they use...

Yes you can

> Should I also consider the indexes' INCLUDE columns?

Yes you...

Some of records in source table have string values larger than allowed by definition of column at destination.

DDL for [Test].[dbo].[Channels2]?

Can you tell please which rows of provided samples do...

Looks like OP need just a running total.

My be sample provide is not very exact 🙂

Not good option for SQL Server as there is no direct equivalent to autonomous transactions like...