isames
asked on
SQl Query
Can you modify the length of a column for a view?
It seems that the view is inheriting the column parameters from the table it's querying, which it should.
It seems that the view is inheriting the column parameters from the table it's querying, which it should.
>It seems that the view is inheriting the column parameters from the table it's querying
Correct.
>Can you modify the length of a column for a view?
Tell us why you want to, as the column data type is already sufficient for the data that's in it.
Correct.
>Can you modify the length of a column for a view?
Tell us why you want to, as the column data type is already sufficient for the data that's in it.
I you are looking to pad the results to a predetermined length you could cast it from say varchar to char.
But as Jim points out it would be easier to understand what you are trying to achieve in order to give you a more precise answer.
But as Jim points out it would be easier to understand what you are trying to achieve in order to give you a more precise answer.
ASKER
In my BI software I have linked a two views by a column called Group_Number. When I run the BI worksheet that uses these views, I get an error "Invalid Length Parameters passed to the left"
Please post the T-SQL of your view, then run, then when the error displays double-click on the error message and watch the cursor jump to the offending line, and tell us what line that is.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window