Chris,

I keep forgetting that the LEAD/LAG window functions have the 'default' value field, and have been using ISNULL (as per my previous example!!!) :w00t:

Just as a side bar, I worked in a travel company with a rather aggressive profanity filter on the mail server, and bounce legitimate emails that contained the word Bastardise(d),...

As with all things speak to anyone from the various camps and they will tell you their option is better, I remember being told by an Ingres developer that it...

I believe that you have to remove the SSISDB and start from scratch as there is no way that I know of to recover the password after the setup has...

Theres a big logic flaw in yourscript, you add the Time to a DATETIME that already has a time component, which is why my results look a little weird.

as...

This might help you get started

NOTE : Tables changed to TEMP tables for ease, also using my own String splitter

Reporting.SplitParam_Test (Effectively Jeff Modens).

;WITH CTE_GetAudit

AS

(

select

CONCAT([Forename],' ' ,[Surname]) AS...

Final script you provided seems to work fine, I just cant see the connect between that and the CRM table.

What is the data set you are looking to return.

As you...

I was just about to send a response, its the ai/bi columns that...

For a start you insert is completely malformed, replace the * with a comma, and you are missing single quotes around the bi/ai columns in the selects.

Just taking the...

There are a couple of possible issues, have you tried just putting one of those fields into a variable and passing it through the Splitter

I did a simple test using...

SQL is linear, so it wont start a statement until the previous has completed, there could be an issue with transactions, overlapping, or not completing in time for the next...

Why do you need to create a function for this. simply do this for text fields

ISNULL(NULLIF(@column,'NULL'),'No Data'))

or this for Numeric fields

ISNULL(NULLIF(@column,'NULL'),0))

Its also likely to be more efficient than calling a...

hi,

Sorry I didn't get back to you yesterday, work got hectic.

I didn't realise this was for a DW, had it been a OLTP system I would have used the structure...

Nevyn (3/2/2015)

---

Try

SELECT 'SELECT '

+ COALESCE(QUOTENAME(user_name,''''),NULL)+','

+ COALESCE(QUOTENAME(date_of_change,''''),NULL)+','

+ COALESCE(QUOTENAME(time_of_change,''''),NULL)+','

...

cs_source (3/1/2015)

---

Thank you very much! i didn't think to use a function, i do already have a date dimension table.

the solution worked using the following code for those who need...