@luis,

I like your idea and infact I practice using BIT in my projects.

Try this syntax:

ALTER TABLE {TABLENAME}

ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}

CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}

[WITH VALUES]

You can do it using CHECK Constraint.

text datatype is supported in SQL 2012 but will be deprecated in future versions.

alternative is to use varchar(max) and if you need multilingual support use nvarchar(max) datatype.

Thanks,

Durga

wow thats great, I didn't expect it to be that straight forward approach.

Thank you, that's what exactly I am looking for and its helped me a lot.

I will focus on XML schredding further and learn about it deeper.

@jeff,

I know shredding XML but not an expert, that's why posted here so that I can get some inputs.

I am not expecting spoon feeding but a basic approach...

Any idea how to resolve my XML requirement?

How to do that pointing?

Useful tips.

very useful, I too learned something new today.

I think you would like to save the complete result set i.e. 35 rows into variable.

follow this:

DECLARE @tblV Table

(

v varchar(max)

)

INSERT INTO @tblV(v)

SELECT ProductName

FROM tblProducts

Alternatively, if you would like...

That's a good step indeed.

XML is platform independent technology and very powerful.

To start with refer to this URL: https://www.mssqltips.com/sqlservertip/3141/importing-xml-documents-using-sql-server-integration-services/

XML data processing involves shredding, parsing, transformations using XSD stylesheets.

Also the multilevel...

your rows per page expression is good enough.

check if this works: put the subtotal before the rows per page expression and put the grand total after the rows per page...

Have to tried with this:

download the service pack 1 (https://www.microsoft.com/en-us/download/confirmation.aspx?id=46694) and install it.

also check the solutions provided in the following URL:

http://www.networksteve.com/forum/topic.php/SSMS_2014_-_Unable_to_See_Stored_Procedures_-_Get_IsNativelyComp/?TopicId=65551&Posts=2