You might want to try something like this:

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_PLANT

(

PLANT_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT PK_DBO_PLANT_PLANT_ID PRIMARY KEY CLUSTERED

,PLANT...

Quick solution, returns the hour + time fraction (minutes and seconds / 3600)

😎

USE tempdb;

GO

DECLARE @DATE_VAL DATETIME = '2014-07-29 08:16:31.000'

SELECT @DATE_VAL

SELECT DATEPART(HOUR,@DATE_VAL) + (DATEDIFF(SECOND,'00:00:00.000',DATEADD(HOUR, - DATEPART(HOUR, CONVERT(time(3),@DATE_VAL)),CONVERT(time(3),@DATE_VAL))) / 3600.0)

Result

8.275277

Edit: Oops, feel...

Sean Pearce (8/2/2014)

---

GilaMonster (8/1/2014)

---

Sean, do you have the actual execution plan for comparison? I've seen obscene row estimations before, I suspect caused by the optimiser thinking that a one-to-many join...

Although your code works fine, it wouldn't be my first choice as if the OP could change the schema, normalizing the data...

Looking at the expected results prompts few questions:

😎

1. Is this dataset for...

Just a quick thought on the problem, why not use the ROWLOCK hint?

To try it out, run the create script first and then the Update and the Select code...

Unfortunately I do not have BIDS 2K8 at hand so I'm going by my gay cell...

No option to do dynamic file config from within the package then, either dynamically modified/created package or database configuration are your best bets. If you...

Quick thought, what are the security properties of the package? Have you tried initiating the download from the application server using the package runtime credentials?

😎

Using a trigger is probably the most straight forward approach, if you add a table holding the primary key value and a date, then you can use the output clause...

windows_mss (8/1/2014)

---

Hi,

I have done with the SSIS Package and it's working as expected in my local machine, I have one problem is that how I can give my XML configuration...

As Lynn said, give us something to work with! My guess is that Grant is dead on, just in case, check free space on all relative volumes, auto growth limits/settings,...

This adds an incremental number to the output, by stating (SELECT NULL), one indicates that...

The code below demonstrates how to use output parameters in a stored procedure

😎

CREATE PROCEDURE dbo.WasInsertSuccessfulQuestionMark

(

@ValueToInsert INT

,@ThisTellsMeIfSuccessful INT OUTPUT

)

AS

/*

usage

...

Quick question, do you need assistance providing the necessary information.

😎