antonela (4/21/2012)

---

I want to calculate ratio to parent for a table named Level1Level2 with this values:

Level1Level2Quantity

A A1 ...

brubin 51691 (4/20/2012)

---

To concretely answer your question about the End Time - each entry "ends" the time spent on the previous entry; for example, 8:15am - 8:30am, (8:30am ends the...

SQLKnowItAll (4/19/2012)

---

stevro (4/19/2012)

---

I really don’t blame you. Transactions and isolation can be a very difficult and confusing, and...

Agreed.;-)

Fitz

cfradenburg (4/19/2012)

---

itskanchanhere (4/19/2012)

---

The more I read on Isolation levels the more I get confused

Connection 1:

BEGIN TRANSACTION; 

SELECT * FROM T; 

WAITFOR DELAY '00:01:00' 

-- Start Connection 2

SELECT * FROM T; 

COMMIT; 

----------------------------------

Connection 2:

Update table T...

SQLKnowItAll (4/19/2012)

---

No. Read committed will read the committed transactions, read uncommitted will read uncommitted...

GilaMonster (4/19/2012)

---

pwallis (4/19/2012)

---

The developer is indicating that it is in executing the CREATE VIEW using the SQL statement that takes the time, if we run just the SQL statement without...

riya_dave (4/18/2012)

---

declare @P1 nvarchar(32)

declare @mtd2 float

declare c1 CURSOR FOR

select account, MTD from #temp2

open c1

FETCH NEXT FROM c1

INTO @P1,@mtd2

WHILE @@FETCH_STATUS = 0

begin

if(@mtd2 IS NULL )

BEGIN

declare @IRR2 float

EXEC pdashboard

select...

charles-1011021 (4/18/2012)

---

I am trying to save a timestamp to a Binary(8) column and converting it to Binary(8), with no luck updating the table where I am tring to save it....

pwallis (4/18/2012)

---

Mark Fitzgerald-331224 (4/18/2012)

---

What exactly is the process here? The users are selecting tables at random ( from a combo box?) apart from the Primary table, this is then...

Mark Fitzgerald-331224 (4/18/2012)

---

"We have an application that enables our users to run adhoc selections over tables and display the results in SSRS reports. In simple terms it creates a temporary...

"We have an application that enables our users to run adhoc selections over tables and display the results in SSRS reports. In simple terms it creates a temporary SQL view...

Using the idea of a directory / folder being passed into SQLCMD I have done this in the past. The reason I try to use a local declared variable...

I think that the table that is causing the doubling is the SOP_CUST_SERVICE_HEADER. Due to there being 2 damage codes then each damage code is matching to each of...

Create a table in the main report showing each row (server) as the details. Add a column (or an additional row within details) that holds the subreport with the...