gail always provides perfect solution

Jackal (10/24/2008)

---

Hi all,

Need your advice on something, I have some four tables, for this question lets say that they are;

Customer - stores the basic information on the customer (customer id,...

amalin_chatterjee (10/24/2008)

---

Hi,

this is my first query to the forum.

one of our applications (.net web app) throws the following error frequently

"Timeout expired. The timeout period elapsed prior to obtaining a...

nailosuper (10/24/2008)

---

Hi,

I have a table which has some null values in "name" and "surname" columns. I use a function ti uppercase the first letter. But as i...

yisaaacs (10/24/2008)

---

I have a log table, that contains a Detail column which looks like this...

auth=2 ms,xslt=110 ms,wallet=531 ms,resp=136 ms,total=0.823 sec,meta-data=3 ms

i need to extract each integer with the corresponding name,...

Thanks for the updation. This is worthful

dastagirid (10/22/2008)

---

Hello,

I have a table that contain 10 lakhs of data.

when i tried to...

Janos Horanszky (10/23/2008)

---

Hi,

Is it possible to parametrize a remote procedure through a linked server or a query through a linked server?

I am trying to parametrize the name of the linked...

seenu_61281 (10/23/2008)

---

I would like to be a DBA in sql server.i am little bit stronger in sql queries,sp,views...

i know basic import/export thru DTS wizard.

What are the other things i should...

siddalingaswamyd (10/23/2008)

---

I need to get the difference between two dates existing in the column and put the result into a new column. this change should be permanent to the table...

You are most welcome

yes except to the name: name1 and age: 25 all records will list

Chandru (10/23/2008)

---

Hi all,

I have a problem with the folllowing scenario that i have inserted the different password into my table but when i try to...

sudhakara (10/23/2008)

---

Query should show the recored which name <> 'name1' and age <> 25 .but there is one more record in the table name3 and age 25 its not...

aveerabadran (10/23/2008)

---

Hi All,

I have a requirement where i need to execute a query (daily) ,and put its output into Excel or HTML file before sending it as a mail ....