ningaraju.n (5/27/2009)

---

Thanx saurabh.dwivedy

The code is dynamic...

Occurence of CAST is not Known..... it may occur 100 times or 0 times

and the Variables inside the cast also not known...

and the code...

Hopefully I did it correctly for your databases and tables, but this is how I would have written and formatted your code. I am curious how you are using...

ningaraju.n (5/27/2009)

---

Hi Friends...

I need find the exact string pattern in an String

For Eg:

my Main String is like this

Declare @Str='I am going to have Asset table

and in that table...

Hey, I just hope they aren't using a smallint for the number of posts. If you think about it, we really aren't that far away from 32,768. :w00t:

And using dynamic configurations, you can change servers and databases as easily as modifying a configuration file. A good book is from Wrox, Professional SQL Server 200r Integration Services,...

Kris,

Glad you got you query problem solved. Now, I'd like you to carefully read the first article I have referenced in my signature block below. When you have...

9 bottles of beer on the wall, 9 bottles of beer! Take 1 down pass it around, 8 bottles of beer on the wall!!

Alvin Ramard (5/27/2009)

---

Lynn Pettis (5/27/2009)

---

There is nothing inherently wrong with this post, but I have to wonder off to my tent in the desert. What do we do as...

There is nothing inherently wrong with this post, but I have to wonder off to my tent in the desert. What do we do as DBA's that isn't technical...

Amol.Naik (5/27/2009)

---

I just edited my post which probably would have gone unnoticed, i am adding that here again:-

The Stored Procedure hangs indefinitely at the UPDATE statement.

Just to re-iterate, all i...

Larry Rebich (5/27/2009)

---

I use Google search a lot to find solutions to common programming problems. Many of the forum topics found in the search look promising. Then when you read...

RBarryYoung (5/27/2009)

---

Wow! That was some kind of response guys, thanks!

Just one thing, next time, could your blow a whistle or something first? I almost didn't get out of...

Curious, where in Germany. My daughter is over there for a week. ...

Larry Rebich (5/27/2009)

---

I use Google search a lot to find solutions to common programming problems. Many of the forum topics found in the search look promising. Then when you read...

Much there is in my Hogwarts Tent, there is. Welcome you are.

I left a "saintly" reply myself.