polkadot (4/26/2012)

---

Ok I understand what you are saying and why my query isn't working.

I need to isolate what isn't found in the result set. What comparison operator...

To avoid the invalid length error, you'll need to wrap it in a Case statement that checks if the string contains a carriage-return.

case when Addr like '%' + char(10) +...

I've been to it once. The company I worked for...

Something like this, perhaps:

SELECT Addr,

CHARINDEX(CHAR(10), Addr, 1),

LEFT(Addr, CHARINDEX(CHAR(10), Addr, 1) - 1)

FROM ...

Can your presentation layer cope with a dataset that returns different columns each time it's run? That's usually pretty complex to set up.

The easier way to do this kind...

I'll go along with everyone else here and just reiterate that there are places where a loop of one sort or another is necessary, and in those cases a cursor...

SQLKnowItAll (4/25/2012)

---

For my own understanding... We are talking about select1 and select2 being in the same transaction. Am I wrong? I would assume different results otherwise in a highly...

riya_dave (4/25/2012)

---

need a suggestion

i am putting my select statement in temp table.

if i remove this temp and only keep select ,i am not getting this error.

Is there any limitation...

Check the stored procedure or user-defined function the report is calling. There is probably a "raiserror" statement in it that tests those two parameters.

What you will need to do...

Any particular reason to move the clustered index from an identity column to a datetime column? Usually, both of those just indicate insert-sequence, and accomplish the same thing structurally.

Unless...

Peter Maloof (4/25/2012)

---

If I could get the thread back on topic for a minute: I think requiring access to your credit report is just as bad as requesting social media...

And, of course, having first read it in about 2000, I never bothered to update my definition.

Thanks.

GilaMonster (4/25/2012)

---

6...

Unrepeatable example: Update Joe's last name from Smith to Smithe between reads. Different data, same rows.

Phantom Rows: 5 rows one time, 4 or 6 the next time.

One set of...

Check this: http://msdn.microsoft.com/en-us/library/aa213029(v=SQL.80).aspx

See if that helps.