This is exactly how the data is stored, that is why I am having so much trouble pulling the correct data. This data comes from a Unix system and is...

There's 499 I believe in the excel file, but this is including the credits. But I just want the open accounts payable, not the (-) ones. If those...

There's 499 I believe in the excel file, but this is including the credits. But I just want the open accounts payable, not the (-) ones. If those...

Here is the table structure and attached is the data.

USE [dsg]

GO

/****** Object: Table [dbo].[DICE_APDH] Script Date: 6/14/2015 3:44:42 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE...

andyscott you actually had it returning Thursdays, but that's cool simple change to the DayofWeek=6, both of the helpful examples run very quick, I like the formatting of your example...

The sample data does match, the fields I've indicated to insert values. The Mytable1114, MyTable1214 etc.. are tables that I pull the data for 30,60,90,120 from the date ran. I...

And Really Yeah, varchar(1) I didn't create the table I am forced to use it.

Yes it does stuff it in there, but It creates one long string, As I stated in my original post, need to concat where number is the same and date...

;WITH ARNOTES

as (

select * from [myTable0914]

UNION ALL

select * from [myTable1014]

UNION ALL

select * from [myTable1114]

UNION ALL

select * from [myTable1214])

Select ARNOTES.AR_NUMBER,HD_DATE_TIMEX,ARNOTES.TRANS_NO,ARNOTES.MESSAGE_COUNTER,

...

I've tried using this and didn't really do the job. Could you provide an example with the data I provided.

Thanks, now just have to remove the dups.

So I get an error that is pointing to the semicolon, but when I remove it, I get an error stating that Incorrect syntax near the keyword 'with'. If this...

I did a search and found similar using xml path()..Thank You! Now I have to figure out how to incorporate in sp_executesql, because I am joining monthly tables and they...

Can you provide an example?

I get this error...

Connection manager "Excel Connection Manager": The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode.

So...