[font="Verdana"]Thats really nice of you all. Thank you very much.

Mahesh[/font]

[font="Verdana"]

guptaopus (5/8/2008)

---

Even if table exist now, I want to handle this situation in future any table is dropped and I dont want my SP to suffer. so any workaround on...

[font="Verdana"]

GSquared (5/7/2008)

---

Mahesh Bote (5/5/2008)

---

[font="Verdana"]

Are you handling errors at front end with Try Catch...

[font="Verdana"]Sree, as you stated earlier, your query is returning the Null though you have used Is Null in your query. Can you try and compare with Euqal To (=) /...

[font="Verdana"]

I didn't get you. It is column separator right?

Mahesh[/font]

[font="Verdana"]Do you mean...

Insert Into Test

Select 1, 'A' Union All

Select 2, 'B' Union All

Select 3, 'C' Union All

Select 4, 'D' Union All

and

Insert Into Test values (1, 'A')

Insert Into Test values (2,...

[font="Verdana"]

...SELECT @strValList2 = @strValList2 +

CASE

WHEN vColName IS NOT NULL THEN '[' + vColName +...

[font="Verdana"]

matt6749 (5/6/2008)

---

I believe:

The .Net Datagrid with custom paging WILL need to connect to the DB every time the user changes the page. In fact, with "default" paging the Datagrid...

[font="Verdana"]

Sharma, if there is...

[font="Verdana"]

This is the url where I got the stuff I posted earlier. Go through the whole article and confirm

http://www.simple-talk.com/sql/t-sql-programming/the-helper-table-workbench/#first%5B/url%5D

Mahesh[/font]

[font="Verdana"]As the previous poster asked, mention the relation between employee and rest 2 tables.

Mahesh[/font]

[font="Verdana"]I must say, you need to update the Employee table. Tell us which fields of Employee table you wants to update? By the way, how could you have same column...

[font="Verdana"]http://www.exforsys.com/tutorials/sql-server-2005/using-xml-in-sql-server-2005.html[/font]

[font="Verdana"]Refer FOR XML clause in BOL for more information.

By the way, post your complete select statement and the exact problem as well.

Mahesh[/font]

[font="Verdana"]I got some stuff on net.

Splitting Strings into table-rows, based on a specified delimiter

-----------------------------------------------------------------

Imagine you have a string which you want to break into words to make

into...