Hi

I have to ask this: What are you trying to do?

Data should be stored top down, not left to right 😀

Greets

Flo

Hi

I'm a C# and I have no problem with VB.NET. I just don't understand why features like "Option Explicit Off" or "On Error Resume Next" are still supported. I've started...

Hi

First, to pay my bill for entering this thread 😀

SELECT

CONVERT(CHAR(6), DATEADD(MONTH, -1, CONVERT(DATETIME, @yyyymm + '01', 112)), 112)

,CONVERT(CHAR(6), DATEADD(MONTH, 1, CONVERT(DATETIME, @yyyymm + '01',...

Hi Joe

In my opinion, that's...

@Gunjan: Sorry, I've no answer to your post.

@becklery: SSC is a forum, not a place to do your commercials...

Greets

Flo

Hi

What you have to do is to define the new tables and add the columns to your trucks table. The data migration can be done automatically.

Here is a little sample...

Hi

This table appears to reflect a whole database. I have no real clue about your business and trucks 😛 but there are some tables I see:

* Companies: Id, Name

* Makes:...

GSquared (11/13/2009)

---

void ValidateColumn(object sender, DataColumnChangeEventArgs e)

{if(e.Column.Equals(this.UnitPriceColumn))

{if(!Convert.IsDBNull(e.ProposedValue) &&

(decimal)e.ProposedValue < 0)

{throw new ArgumentException(

"UnitPrice cannot be less than zero", "UnitPrice");}}

else if (e.Column.Equals(this.UnitsInStockColumn) ||

e.Column.Equals(this.UnitsOnOrderColumn) ||

e.Column.Equals(this.ReorderLevelColumn))

{if (!Convert.IsDBNull(e.ProposedValue) &&

(short)e.ProposedValue < 0)

{throw new ArgumentException(string.Format(

"{0} cannot be less...

Hi

Sorry, but I...

Generally there is no functional difference between C# and VB.NET. Everything you can do in one language can be done in the other, too.

I've started with VB5/VB6 but now I'm...

I completely confirm Jeff! Some random values are really important to ensure some fine tests.

I prefer this method:

😀

Hi

Lamprey13 (11/12/2009)

---

Flo, do you know what BOL page says that? Or do you have a link? I cannot seem to find that in my local BOL.

I'll have to go...

Hi

To ensure a correct execution plan you should split your procedure into two different procedures. One which works with @location_id and one which doesn't. You can use your entry procedure...

Hi

If you always query data equal to all three columns you can add a computed column as BINARY_CHECKSUM over all three columns. Put an index only on this column and...

Your statement looks a bit strange to me. You...