[font="Verdana"]

Does your problem get solved by Amol’s suggestion or still you are facing any?

Do let us know the exact scene.

Mahesh

[/font]

[font="Verdana"]

dhanuhere (4/10/2008)

---

Hi all,

I am not great in sqlserver i am bascicaly asp.net professional.

I want to set a column as flag for indicating user edit data time .somAeone suggest me set...

[font="Verdana"]

I would like to thank you all for such a kind support. I get a better idea, what kind of questions (technical and non-technical as well) can be asked in...

[font="Verdana"]

patel mayur m (4/10/2008)

---

Hello Mahesh

Thanks for a prompt reply

But the problem is that we have more than one user. Invoice saving process will not take more than 3 to 4...

[font="Verdana"]

patel mayur m (4/9/2008)

---

Hello

I have one scenario for that i don't know how to fulfill.

Let take example. User-A is reading row now at the same time if user B is...

[font="Verdana"]

Gant, I am not getting you?

Mahesh[/font]

[font="Verdana"]

For more details check out the attached file here. I got this information online, 3-4 months ago. I just saved the information regarding to the difference between Delete and Truncate....

[font="Verdana"]

Mitchel T (4/8/2008)

---

Hi:

I have the following query that may return null if certain dates are selected, I want to display 0 instead of a blank but cannot figure it out:

*...

[font="Verdana"]

If this is so, I would suggest do it at...

[font="Verdana"]

Then whats the problem dude? Tell the DTS comma is the delimeter in the file, so it will separate the fields and will treat them...

[font="Verdana"]

karthikeyan (4/8/2008)

---

Andras,

I already did what you have mentioned.

TableName: Imp_Text

Remarks

50,Karthik,1982,+91-044-994012345,5000.00

60,Vijay,1974,+91-044-998012345,8000.00

70,Arun,1992,+91-044-992012345,6500.00

Now i want to split it in the below format.

50 Karthik 1982 +91-044-994012345 5000.00

60 Vijay 1974...

[font="Verdana"]

fyi ...

http://www.sqlservercentral.com/articles/Administration/2987/

Thanks,

Mahesh

[/font]

[font="Verdana"]

Bob Crowley (4/7/2008)

---

Check out the Microsoft Patterns and Practices Enterprise Library.

http://msdn2.microsoft.com/en-us/library/aa480453.aspx

The Data Access Application Block is what you want to look at.

I used it once in an earlier version...

[font="Verdana"]In what context you need help from us? Does the query is taking much time to execute? What exact the problem you are facing? Does it throwing any error? Please...

[font="Verdana"]

karthikeyan (4/7/2008)

---

My Team is using SQL2000 and Sybase12.5.3.

It is not working in Sybase12.5.3.

But the thing is, Sybase and Sqlserver are almost same in some generic query execution.

if we take our...