It's not exactly what they name "on vacation". 😉

"On vacation" means "gone fishing", "being on tour", "hiking over incredible range", getting pissed end in the...

This is exactly what should be done in UI code.

What's the point of populating drop-down box with values which you cannot match back to values in table?

After a user selected...

Steve Jones - Editor (3/15/2009)

---

I'll give you a few hints here. The explanation above is correct.

Look at charindex/patindex to find the "marla" in your string. http://www.sqlservercentral.com/articles/Advanced+Querying/tamestrings2.asp/97/

Then use substring to grab...

Patrick,

actually Excel can get data by running a query against SQL Server.

Did you consider this option?

- no identites;

- no collations;

- "DEFAULT" is...

Kartik,

with a little bit of effort from your side you could easily transform "string concatenation" function (which you already copied from this forum) to "float multiplication" one.

Whatever rant it's started from it ends up in a pub...

:Whistling:

Easiest way is to use ODBC driver for test files.

Look in BOL for topics about Linked servers, OPENQUERY, OPENROWSET for details and examples.

I can imagine how it suffers.

:pinch:

My condolences to poor T-SQL.

:crying:

😛

foxjazz,

Are Matt's and Lynn's code examples shorter than you C# code?

Definitely.

Do they do the task?

Absolutely.

What about performance?

Try it and see - C# won't see the dust tail after TSQL.

Does it...

J (3/12/2009)

---

Sergyi

Good point on the constraints.

However, since I am working on a specific table, I have to look no further than the table itself to find out about constraints. Also,...

J (3/12/2009)

---

Sergiy

Triggers ! :w00t:

I have this deep-rooted prejudice against "hidden" code that executes from somewhere else. Say I am trying to debug a stored proc and I forget that there...

JacekO (3/12/2009)

---

1. Calling SPs from another SP is not a big deal and has nothing to do with set based or RBAR programming. I use it quite extensively because it...

My English...

Sorry if it sounded as a personal attack.

It was not one.

There's nothing wrong in being unexperienced in database development.

I just tried to make a point that something what you're ready...