To create the table -

/****** Object: Table [dbo].[test] Script Date: 25/02/2016 16:01:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[test](

[CalendarPeriodId] [int] NOT NULL,

[CalendarId] [int] NULL,

[CalendarYearId] [int]...

ALTER PROCEDURE [dbo].[usp_test_Arrears_BrokenArrangement]

@PolicyId INT, @AccountId INT, @PolicyNodeId INT, @output BIT OUT

AS

BEGIN

SET NOCOUNT ON;

SET @AccountId = 1

DECLARE @CurrentArrangement as bit

DECLARE @LastSystemActionId as int

DECLARE @ActionDate as date

DECLARE @NoOfBrokenArrangements...

Yes I did try but kept getting errors as I'm obviously using the SET in the wrong place.

Just worked it out -

As the ASSET table is now populated - I can use the following

-- Populate the AssetAddress Table with the relevant data. Only if the AddressID...

Thanks everyone - between you all you got me to where I want to be.

Hi Dave,

That's what I did - basically in my flat file Destination, when I double click it - in the big white space under Header, I have placed -...

Yeah tried to convert to varchar and it didn't do anything different.

The following -

CONCAT('"',DATEPART(d,ra.StartDate),'-',DATEPART(m,ra.StartDate),'-',DATEPART(year,ra.startdate),'"' ) as test,

Just goes - "11-9-2015" I need it to be "11-SEP-2015"

I don't have the skills in that though, so was just wondering if there was anything in TQL that could do it.

If not, not to worry, I'll see what I...

/****** Object: Table [dbo].[Contact] Script Date: 13/11/2015 11:38:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[Contact](

[ContactId] [varchar](100) NULL,

[ContactGroupRef] [varchar](100) NULL,

[RelationshipToLead] [varchar](100) NULL,

[id] [int] IDENTITY(1,1) NOT...

Thanks for your reply but sorry I don't know how to achieve that.

Hi,

Thanks for both responses.

1. Jeff Moden you mention placing a WHERE clause. How do you do that when it is referencing a worksheet from Excel like below?

SELECT *

FROM [Sheet1$B2:Q2]

UNION

SELECT...

Hi There,

Yes there is a primary key called "id". And the row is all fields null. Which becomes id 1.

Thanks

Appreciate your help with.

As I have the above UNION and the Excel Connection has "First Row has Column Names", so that the first select statement picks up the actual header...

Thanks for that.

That gives me the data that I require.

However it does not list the headers of the columns. How would I achieve that in the SQL statement?

The columns (as...