saravana kumar

saravana kumar

  • NA
  • 31
  • 45k

Split function using sqlserver in asp.net

Jan 4 2013 8:43 AM
Hi Friends,

I have one Table like ShownBelow...

Domain Name    Min Years    MaxYears
.com                    2               10
.net                     4               12
.co                       1               12
.buz                     1               13

But Am passing parameter to stored procedure like this way   .com,.net,.co
Now i need to split this value and check with database and again i need to return dataset like above table

Domain Name    Min Years    MaxYears
.com                   2                  10
.net                   4                   12
.co                     1                   13
.buz                   1                  13   

Need your help friends...


Answers (1)