And here as an inline table-valued function

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS') IS NOT NULL DROP FUNCTION dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS;

GO

CREATE FUNCTION dbo.ITVFN_GET_LAST_THREE_BUSINESS_DAYS

(

@TODAY DATE

)

RETURNS TABLE

WITH SCHEMABINDING

AS

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

-- 2016-01-11 Eirikur Eiriksson

--...

fara (1/11/2016)

---

Hi Guys, I need your help, I'm trying to create a script that will get Current 3 Business days data, what's the best approach please?

Today is 11/01/2016- Monday

I need...

RIP Major Tom

😎

That would be me, the OP doesn't help, so far your responses have been calmer than mine;-)

😎

Cannot help it when seeing the ads for the Surface to think of "scratch the ..."

😎

Now it's time for you to post the full requirements and all...

Quick thought, 3Gb for a W2K12 Server is pretty meagre especially if there is any other activity than the SQL Server Service active, RDP should be a no-no and SSIS...

Quick suggestion, switch to Ola Hallengren's maintenance scripts[/url]

😎

{thundering voice in the background}CALM DOWN

😎

Rankerg (1/10/2016)

---

That is the requirement, any changes to any column means that is a CHANGED / MODIFIED record and these CHANGED/ MODIFIED files I want ? duplicates to be...

Grant, the link to your article doesn't work, copy...

harikumar.mindi (1/8/2016)

---

Hi Geeks,

I have a situation where our customers are planning to migrate their application from one Datacenter to another. We are currently performing a test to understand any performance...

Rankerg (1/10/2016)

---

Thank you but please explain, I could not understand the answer ?

Meanwhile let me rephrase my question

So let me rephrase the question

We would take the full file (Dec...

Thanks Gail, I totally missed that fact

😎

Thought the question was kind of odd but at that point there wasn't enough caffeine in the system.

Steve Jones - SSC Editor (1/10/2016)

---

Apologies, misread the piece. I thought it was everything before Edge, and not sure why I saw that, but I'm incorrect. It's all versions prior...