This is simple, run the query with "Results to Grid", right click on the results and select Save Results As..

😎

Just to further on the explanation with a quick example:

😎

USE tempdb;

GO

CREATE TABLE dbo.MY_IDENTIY

(

MY_IDENTITY_ID INT IDENTITY(1,1) NOT NULL CONSTRAINT...

Did you look at Greg's Robidoux article Using SQL Server DMVs to Identify Missing Indexes[/url]?

😎

Would have thought it would be in the sys schema in the master database, that is master.sys.sp_MSdistribution_cleanup

😎

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...