I would go with something simple like:

CREATE TABLE #Invoice

(

Invoice_Number int,

Invoice_Date date,

Item_Name varchar(40)

)

INSERT INTO #Invoice(Invoice_Number, Invoice_Date, Item_Name)

SELECT 10001,...

Could you post a sample of the file? Without real data and just enough rows to understand the different formats.

I believe that the formula to calculate the date is a little bit wrong.

Here's an example according to what I understood:

DECLARE @Date datetime= GETDATE()

SELECT DATEADD(MM, DATEDIFF(MM, '19010101', @Date), '19000101'), --Using...

Eirikur Eiriksson (6/3/2015)

SQLRNNR (6/3/2015)

Ed Wagner (6/3/2015)

SQLRNNR (6/3/2015)

Actually, these days it should...

Eirikur Eiriksson (6/3/2015)

SQLRNNR (6/3/2015)

Just tell...

Hopefully, you did understand why were you getting an error and how the syntax works. CTEs and UNION (ALL) are part of a single statement and can't be divided by,...

I'm including the code to retrieve the text between [] and avoid rows that won't contain a proper format. Feel free to modify it as needed and ask any questions...

You have your syntax wrong. Additionally, CTEs won't work on SQL Server 2000 and previous.

For 2005+ this syntax would work.

Select columns

into #tableA

from SometableA

where SomeCondition

--order by --unnecessary

;

Select columns

into #tableB

from SomeTableB

where...

I assume that you mean a single statement when you mention "no stored procedure".

Here's a possibility and I'm sure that there are many other ways to do it.

DECLARE @TierId int...

Is a well known fact,...

Why are you trying to reinvent the wheel? There are numerous password generators that will be able to follow different rules according to necessities (ensuring the use of upper and...

This might probably won't help if you want something free, but the manga guide to databases explains databases in a great way for non-technical people and you could get ideas...

Jason A. Long (6/1/2015)

No problem. Thanks for kicking me in the back side to get it done... With the data partition and the select output. 😀

When...

I'm not sure if it's an improvement, just a fun way to save some keystrokes.

SELECT

SD.Id

,ABS(SUM(SD.Value*SIGN(Type-1.5))) AS Value

FROM dbo.TBL_SAMPLE_DATA_012 SD

GROUP BY...

This makes no sense for me, but using the sample data previously posted, I can get the expected results with 2 options (none of them use SUM function).

SELECT a.UserID,

...