Ysaias Portes-QUI Group (8/10/2011)

---

If you are using an SQLDatareader Class to read the data, you need must pass either the name of the column or the column order index.

DECLARE @result...

You can't write the value of...

You seem to be missing the important part of the new datatype....your table doesn't have a HIERARCHYID column.

Try this article as a good start to understanding how this works.

select * from sysobjects where xtype = 'p'

Will return the same list. What I don't quite understand is what exactly are you looking for?

I'm trying to work out how to...

I would be surprised if that would be faster than the tally table. That many converts has a lot of probability of being horrendously slow. Given a million+ records you...

Of course varchar(max) is not 8,000 characters. It is up to 2GB. Here is the reference in BOL.

varchar [ ( n | max ) ]

Variable-length, non-Unicode...

Well a quick search through google should provide you some answers...

Try this: Microsoft

or even

This one

My guess anyway is that the OP is trying to write a trigger because what they are trying to capture. This of course makes me believe that the trigger is...

It is totally unclear what you are trying to do. Just taking a stab in the dark. You could modify your query to get the results you want in one...

Can you change your description field to nvarchar(max) instead of text? text is a deprecated datatype and nvarchar(max) can hold an enormous amount of data. As for the value of...

Something like this get you pointed in the right direction?

create table #MyVals

(

val varchar(10)

)

insert #MyVals select '0123456'

insert #MyVals select '2342356'

insert #MyVals select '1234116'

insert #MyVals select '5017456'

select val, (10 - (sum((((N +...

I knew somebody with more active brain cells than I can put together today would hop in. Thanks!! Definitely use the tally approach. It is WAY better than the garbage...

WOW! That is a crazy thing to deal with. Just for the record you can't have "nulls" inside of a string. You are talking about spaces and not nulls. VERY...

Sometimes it is just the act of looking the data and structure to explain it to somebody else that reveals the answer. Glad you figured it and thanks for letting...

Well really what SSMS is doing is using IE as the browser inside of a windows form. Yes in fact you can display a website inside of a window in...