This is my Query

with t as

(

SELECT --COUNT(*)

j.NameIDRef

--, 0 AS SEQNUM

...

http://www.sqlservercentral.com/Forums/Topic1273640-391-1.aspx

Please post your suggestion over here...i started a separate thread...

SQLKnowItAll (3/27/2012)

---

Charmer (3/27/2012)

---

Hi Friends,

I am having kinda same problem...

I have more than 7 million records in a table.. i was wondering to see how much time to execute and :ermm:...

Hi Friends,

I am having kinda same problem...

I have more than 7 million records in a table.. i was wondering to see how much time to execute and :ermm: it takes...

but Lynn,

With out loop how can i avoid duplicate random string....

i took the cursor out of the stored procedure...so if i have 6 rows to...

Lynn Pettis (3/23/2012)

---

Charmer,

Let me guess, this code will generate a random string of characters from 1 to 6 characters in length, correct?

Have I got something for you if that is...

Lynn Pettis (3/23/2012)

---

Found a problem with your code already, as far as trying to work with it. You use a variable @MaxLength, but it is not defined anywhere...

Elutin, i could not find any link..

Lynn Pettis (3/23/2012)

---

Now, we will need the DDL for the table(s) (CREATE TABLE statement(s)), sample data (series of INSERT INTO statements) for the table(s), and the expected...

Lynn Pettis (3/16/2012)

---

Hi Lynn,

this is a part of my stored procedure, i use cursor here...you all say cursor is not good to be used.

Then what is the best solution instead...

Koen Verbeeck (3/23/2012)

---

Charmer (3/23/2012)

---

SQLRNNR (3/22/2012)

---

Lynn Pettis (3/22/2012)

---

What do you test your code on during development? You don't have a development or test database to work with?

DDL = data definition...

SQLRNNR (3/22/2012)

---

Even taking the DDL from the dev/test...

they make a copy of their Live database...

Lynn Pettis (3/22/2012)

---

I made a minor change to the code, not sure how it will affect performance as I have nothing to test it against.

with t as

(

SELECT --COUNT(*)

...

wendy elizabeth (3/22/2012)

---

Is ignoring errors in an SSIS package ok? If I chose to ignore the errors in a production load, are there some problems I should be aware of?

...