Another way... also cool because it's the hardcore way

Run the code in the procedure section-wise, if possible, and use print or select statements to...

Yeah, well... I know.. just didn't bother to paste all that stuff from BOL

float [ ( n ) ]

Is a floating point number...

bcp shouldn't treat a view any different than a table. Are you sure you had problems just because a view was involved?

/Kenneth

Well, I can't answer for if it's odd or not - but decimal and numeric are synonyms, as are float and real.

I know that floats are desirable in cases that...

You're on the right track, almost. But you can't use ID here, you have to group by mygroup to find the max of mydata - then you can use those...

Also see the SELECT topic in BOL.

(note that the full syntax of select is FROM server.database.owner.object)

Yet another option is to use remote procedure calls - there's many ways to...

Basically, this is how to do it. I just want to plug for date formats...

Don't use anything else than ISO format (yyyymmdd) -...

In all cases, the actual raiserror will be sent to the calling client.

Can you expand a bit (some simple example maybe) on what you want to do ?

/Kenneth

It seems very common among 3rd party app vendors to use float as an fits-all-backends number-with-decimal type datatype. (this is my own belief)

I've even seen this in financial systems, which yet again...

Agreed.

This is one area where SET can't be used, but you must use SELECT in order to catch both variables at once.

There is simply no other way

/Kenneth

set datefirst 1   -- start weeks on mondays

select  datecolumn

from myTable

where datepart(dw, datecolumn) = 5

Have a look in BOL at DATEPART for further info on datefunctions.

/Kenneth

Haven't seen this one before, and the only reference I could find was at the bottom of this kb http://support.microsoft.com/kb/328937/EN-US/ where they say that it can be ignored.. In the...

Just be aware that MAX(column) + 1 isn't a very scalable method. If the number of employees gets to large, the function will degrade in performance significantly. Also, if the...

Here's a bunch of ways to find different start- endings regarding weeks, months and such..

-- The example shows how to find out on which dates a week

-- starts...

The percentages within a plan is only valid in the context of that particular plan. You can't compare 'order by 75%' from one plan to 'min 25%' from another plan...