Bhovious

I am not entirely sure what you are trying to say.

By my definition, Iteration does NOT imply "non-set based" or RBAR (as Jeff would call it)

My solution employs a loop,...

I seem to have problems loading code with create table scripts

CREATE TABLE SSCData

(

RowID int identity(1,1 ) PRIMARY KEY CLUSTERED,

...

Here you go.....I am sure I do not have to explain the logic and how I biased the results to get duplicates.....

Set NoCount on

Declare @Cnt int

,@RowKey varchar(1000)

,@Locale varchar(10)

, @Code char(1)

Set...

I tested the Solutions against the Test dat set that I created. The Table Contained 1 Million records with sequences ranging from 1-35 rows.

My Solution returned 670000+ Rows in...

First , My apologies for the late response...

The only thing I could suggest is to Add a case statement to your Select i.e

Case IsNumeric( Colname) When 1 Then Cast( colName...

hi Steve (SMunson)

To Test your Solution, I ran mine again as I made some changes. Execution time was 5 min 36 sec

I added a print statement after each...

hi

The simplest answer would be to use SSIS.....

There are ways in SSIS to dynamically create the file names etc.

Then create a job with the execution schedule you require

HI

As I mentioned in my first post, I tested the code against a table with 1 million records and it completed in under 3 minutes, so let me know if...

The above change produces the following results

RowIDRowKeyLocaleCode

11enA

21enA

51enC

71enA

101enA

121zhA

131zhA

141zhA

201enD

Note

the first row in the table is removed RowId= 0

Rows 12, 13, 14 are all in the result set as required

Am I still...

This is a little open ended...

I would advise you to get a some Work Load data by running the profiler while the procedure is execuing and using that in the...

Hi Dan

If you Check my last post your should be getting the correct results But need to change the last query before viewing results to below

INSERT #TempTable

SELECT 0,'1','en','C' UNION ALL

SELECT...

It looks like you are swaping the Variable and the columns

Based on your parameter and expected result.....

Declare

@DatumOd SmallDateTime

,@DatumDo SmallDateTime

Select

@DatumOd='20021201'

,@DatumDo='20021231'

Select *

From #T1

Where

( @DatumOD >= Datod And @DatumOD <=...

Okay so, finding the system and code was easier than I thought.

To solve the problem, I used a derived table in my view that limits the result set, And then...

I had this problem before when pulling data from another system

If I remember correctly..

This is a Nuance of how the view is executed when you call it in a from...

Interesting article. even there it seems one can calculate it with different functions ...