hi Babe, I ended up getting it working by creating a scalar function, since it was only returning one number anyway, thanks for the reference to iEnumerable. Definitely going...

Hi OldHand, you set me on the correct path, precision was set; however, Scale wasn't. Fixed now, thanks

Hi, turns out, I need to modify the 'Scale' property. I was trying to modify the length property and couldn't. ~thank you!

Hi BWFC, yes I could and use a coalesce in a select, this question came to mind when I was creating the table, and thought it would be possible, thanks...

So in the table below, I would like the appKey value to = riKey value as a default value ...

CREATE TABLE [dbo].[riKeySchema](

[keyID] [int] IDENTITY(1,1) NOT NULL,

[riKey] [varchar](250) NOT NULL,

[appKey] [varchar](250)...

Hi jphillips, it will be one row at a time. Each row will...

Thank you!!!

Ok, I came across this script below, but I am getting the following error, is there any way to resolve this?

Query generated:

SELECT *

FROM dbo.t_OutlierCalc_BM

UNPIVOT (

value FOR...

Hi Old Hand, I'm probably not explaining this as well as I could ...

I need the bottom 25% of the 'Value' grouped by 'MainGroup'

Loyaltyexternal12875

Loyaltyexternal1946

Loyaltyexternal487

Operation's SupportInternal1864

Technicalexternal1405

Technicalexternal606

Technicalexternal467

Temporary AssignmentsInternal1184

Ok, I want the bottom 25% value of the 'Value' column, broken up by MainGroup ideally broken into 4 quarters.

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

Thank you all for your valuable comments and information.

Hi Erik, I would like to create a function that would give me a 'weighted average' total number * .weighting ie, silver is worth 40% of gold so silver =...

my stored proc was producing an error based on the parameters I was sending it, I was able to instantiate the object using: rv_SalesSC.LocalReport.DataSources.Add(new ReportDataSource("dsTotalOrdersCalls", odsSalesSC)); which is the name...

The following code behind resolved this for me:

if (!Page.IsPostBack)

{

...

Thank you to both, I selected Luis as the answer because of the direction to the Ceiling function, was a learning curve for me.