bteraberry (11/9/2012)

---

Eugene,

I've never had any issue with you whatsoever, but you seem condescendingly rude about some things I don't think you understand. That's not the kind of conversation I...

Yep, ISNULL or COALESCE, but...

In order to mix string "No Data" with numerics in the same columns, you will need to convert all of them into varchar. This sort of...

Given XML sample is a bit strange.

Having <Payees> parent node kind of suggest that it may contain multiple <Payee> nodes, but <DueDates> are outside of <Payee>. So it does look...

It's really...

bteraberry (11/8/2012)

---

Eugene Elutin (11/6/2012)

---

I don't think SEQUENCE feature will help you, as it's going to be a nightmare if you will create a sequence per customer... Also, you will be...

DECLARE @Fromdate DATE = '01 Jan 2012'

,@Todate DATE = '30 Dec 2012'

...

DECLARE @xml XML =

'<ROOT>

<SPECIALNEEDS>

INCLUDE

<NEED>

BLIND

</NEED>

<NEED>

...

What does this mean?

Is your database designed specifically for reporting, so you need to store formatted numeric Id's?

How business can...

You will need to develop this function in .NET (c# or vb.net).

If you don't know...

Your best friend here will be CLR function with RegEx.Replace.

I think that one could be slightly faster:

select t1.id

from @t1 t1

inner join @t2 t2 on t2.Id = t1.Id and t2.X > 0

cross apply (select top (t2.X) 1 from sys.columns) n(n)

google:

T-SQL concatenate string FOR XML PATH

It was not easy to find the difference in the code "noodles" you have, I could not even copy it from browser to my SSMS as it's too wide at...

If you need to split value in multiple rows (eg. in SELECT query), You better to use [DelimitedSplit8K] or some CLR splitter.

For single value split (let say you pass the...

sanket kokane (11/7/2012)

---

I'm testing on some part of the application .

My Table structure is like

create table test (id char (8))

I want , whenever user insert value ,lets say 1

it...