armaandani (1/18/2013)

---

thanks for your rply.

can you tell me about any good article about tally table, how tally tables are created and how they are used. i don't have any about...

Use cross apply instead of cursor. The cursor approach will take forever, the cross apply approach will be much faster.

http://www.sqlservercentral.com/articles/APPLY/69953/%5B/url%5D

If you need specific coding help you will need to provide...

ncurran217 (1/18/2013)

---

That would work but I have a ton of List Codes (i.e. 103EL) and doing that for everyone would not be efficient at all. Thank you though...

No. This is incredibly easy to evaluate. Create a table and try it out.

create table IdTest

(

MyId int identity not null,

SomeValue varchar(10)

)

insert IdTest

select 'Row 1'

SET IDENTITY_INSERT IdTest on

insert IdTest(MyId, SomeValue)

select...

armaandani (1/18/2013)

---

thanks for your rply.

Actually i am working in visual studion 2010 and SQL Express server 2008. i created my database through SQL Express server 2008.

Now i have i...

Can you explain a bit more about what you are looking for?

Charmer (1/18/2013)

---

Thanks to Pete and Abu...Those scripts really works....

Friends...some times i see the date comes in different order....For Ex: instead of 20100225, it comes like 02252010..So my function get failed...Do...

Seems the OP started a new thread for this. http://www.sqlservercentral.com/Forums/Topic1408582-391-1.aspx

I provided a solution in that thread.

aprabahar 48682 (1/17/2013)

---

Hi,

I want to write a Stored procedure that takes input - Table Name, SearchString

The SP should find the output the searchstring is available in which all columns for...

Please see the first link in my signature about best practices when posting questions.

Larry Page(Ehsan.Akbar) (1/18/2013)

---

Hy guys.

i am a windows programmer and i want to ask a question .

i develop my project with ADO and store procedure ,but i heard the linq is...

Most people in the US are just getting up and around for the day.

You are welcome. The tally table has been called the "Swiss Army knife of t-sql". It can be used for so many things to avoid looping. Once you understand it...

Agreed. If you can provide more of the code we will have a better chance at an answer.

I would highly recommend you NOT use a cursor for this. You should instead use a tally table. You can read about them, how to set it up and use...