jim.rasmussen (8/14/2009)

---

Here is my proc

DECLARE

@HMY AS INT,

@STARTDATE AS DATETIME

SELECT

@HMY = HMY,

@STARTDATE = DTSTART

FROM

MM2WODET

WHERE

DTFINISH IS NULL AND

DTSTART IS NOT NULL AND

HPERSON = @USERHMY

IF @HMY > 0

UPDATE MM2WODET SET

DTFINISH =...

Deleted -- Gus's answer was more accurate.

Jeff Moden (8/14/2009)

---

From WikiPedia.com...

A crore (Hindi: ?????) (often abbreviated cr) is a...

Integer math. change the 60 to...

You need to lookup SAVE TRANSACTION in BOL (Books Online) You need to create a TRANSACTION SAVE point in the nested transactions if you want to be able to...

Not sure what is going on with your system either. i just started up a job on my system that has multiple data flow tasks running in parallel, and...

Interesting, I just checked on my x64 development server and there is an x64 version of DTExec and an x86 version of DTExec on the system.

Looks like you may need to implement a sliding window on the table and write a few maintenace routines to implement what you are looking to accomplish. Not sure...

jrw39 (8/14/2009)

---

I'm having problems with this query which should set a flag based on if then then else from access 07. I've converted it to CASE WHEN but I'm...

Here is some code to help you get started. Hopefully the article I had published on sswug.org will be republished here on SSC sometime in September.

brij (8/14/2009)

---

Thanks for reply but I guess u didn't understand my question

I can create partition based on Month or day of the year. But I want partition based on...

You can actually find this in BOL (Books Online, the SQL Server Help System). You can access it from SSMS by pressing the {f1} function key.

here is the relevant...

Actually, in SQL Server 2005 this may work faster:

select

t.[name] TableName,

t.create_date,

t.modify_date,

sum(p.[rows]) RowCnt

from

...

hi_abhay78 (8/14/2009)

---

Give me time till Monday (as its weekend) and your email address as I am on a location where there is no SQL Server (preparing documents to travel to...

Not too hard, here is the code I came up:

select

Account,

sum(case when Type = 'A' then Amount else 0 end) as TypeA,

...