SQLTeam.com | Weblogs | Forums

Problem WITH RESULT SETS


#1

Hi Experts,

I am using sql 2012 and I m trying to execute STP

When I execute stp like : EXEC LOAD_DATA 'Jan','year' then it returns all rows ,

But When I execute stp like :

EXEC LOAD_DATA 'Jan','year'

WITH RESULT SETS
(
(
[Year] varchar ,
[month] varchar NOT NULL,
[Amount] [float] NULL
)
)

it returns incomplete rows ,

Please help .


#2

Can you provide the data output from both?

Where you say "incomplete" results, are you talking about a value being trimmed or converted? The RESULTS SETS forces a specific mask for returned data. If you had your years in a format longer than 4 characters (unlikely) for example, it would potentially trim it to 4. If you had a discrepancy in your nulls, you'd get an error back and no results set.