Hi,

The function in the table definition is a calculated column (you can google it 🙂

the function returns 1 if the P_DATE for the Propnum is minimum .. the first inserted...

Hi,

Maybe you can try with a computed column

REF: https://msdn.microsoft.com/en-AU/library/ms188300.aspx

CREATE FUNCTION dbo.getFirstP_DatePropnum(@date date, @Propnum INT)

RETURNS BIT

AS

BEGIN

RETURN

CASE

...

Hi Stephanie,

The scope of the transaction isolation levels is Session.

This means that all transactions within the session (explicit, implicit or auto-commit) will follow, in this example the optimistic locking methodology...

Hi naidzionik,

It might have something to do with the linked server provider (not sure) and how SUM handles NULLs (should just ignore it)

eg. this worked for me:

SELECT

[Dim1]

,[Dim2]

,[Dim3]

,SUM(ISNULL([Metric],0)) Sum_Metric

,GROUPING(Dim1) Grouping_Dim1

,GROUPING(Dim2) Grouping_Dim2

,GROUPING(Dim3)...

christophe.bernard 47659 (10/14/2015)

---

Hello Eirikur Eiriksson and Dean Mincic,

thanks for your time that's exactly what i want ..and now that's work ..

I don't know why the property of this object is...

Hi Christophe,

The problem with the query you provided is related with the datetime datatype.

The datetime can store dates from January 1, 1753 ...

In the example the query tries to cast...

Hi Sean,

I didn't have enough time to go through the query and to understand the query logic to be able to "assume" what's that all about. The two things caught...

Hi cthorn112,

I think that's ok to set the isolation level to READ UNCOMMITTED if you know what to expect.. dirty reads and all other side effects (personally I've never been...

Hi

One of the possible solutions could be

--create some test data

USE tempdb

GO

CREATE TABLE test1 (sessionId int, MRN int, ChartStartTime date ,DeliveryTime date)

GO

INSERT INTO dbo.test1(sessionId,MRN,ChartStartTime,DeliveryTime)

SELECT...

Hi,

you can use grouping to find sum of Prices over the required set of columns (all except OI.Price)

..maybe something like...

SELECT --without DISTINCT ...

...

DATENAME(ww,o.OrderDate) as 'Week',

o.Pieces,

SUM(OI.Price) AS '$',

ct.CustType,

'Everything Else' as 'Code...

You can format the output like

....sqlcmd ...

1> SELECT FORMAT(Column_Name,'0') FROM table

2> GO

...

1

1

1

Hi shamshad.ali

I think there's noting wrong with the isolation level. (READ_COMMITTED I believe).

If I understand, you described two situations:

Situation 1

1. You started an explicit transaction in SESSION1 with the multiple...

-

Hi,

If I got it right, the requirement is to pick a node from hierarchy and go in both directions, reverse to the root and down to the leaf level.

I set...

Hi,

I thought that the query was generated by a report tool or something.

..DISTINCT and Grouping,,... predicate 1 =1 and so on.

The logic of the query is not clear. Do you...