Sorry, I'm being an idiot.

I'm getting the following error

Msg 15151, Level 16, State 1, Line 1 Cannot alter the schema 'Config', because it does not exist or you do...

Your code is merely returning results. If you want to run the code, you need to paste those results into SSMS and hit F5 ... very carefully and having backed...

This is a good start, but there's more that I suggest you do.

1. Create INSERT statements for some sample data to populate your Football_Matches table.
2. Provide two or three alternative...

How about providing some data in the form of CREATE TABLE / INSERT statements, so that people here have something to work with?

I can't see your data, so it's hard to tell. Can you post some sample data... CREATE TABLE script, INSERTS... so we have some idea what your data looks...

With >2,000 points, you should know how to submit formatted SQL by now.

CREATE VIEW dbo.vwTEST --
AS

WITH t
AS (
   SELECT er.Ece_ID
     ...

• This reply was modified 5 years, 6 months ago by Phil Parkin.

Hi Phil,

That's exactly what I was looking for!

I did find the Profiling Node in SSIS which gave me similar stats to what you extracted in Python.

I also like the...

As far as I know, there is no fixed way of doing this.

I used to have a series of files which were loaded every month and we had to be...

I don't know the answer, but may have an alternative solution.

Use a Conditional Split to redirect rows which you do not want, by sending them to an unused output.

Your Script...

Thank you.

But i would like to use the function "len".

if the len(id) = 14 then it should be in ID1 otherwise it should be in ID2.

Can we achieve it...

SELECT e.Firstname
      ,e.Lastname
      ,ID1 = MAX(e.ID)
      ,ID2 = MIN(e.ID)
FROM dbo.Emptable e
GROUP BY...

• This reply was modified 5 years, 6 months ago by Phil Parkin.

I would like to display the result in single row  like below based on len(id) column.

What does 'based on' mean here?

Where are your sample DDL and INSERT statements?

SOX requirement, by any chance?

What is your data source?

Are they logged in using Windows auth? SSIS does not like SQL Server auth very much.

Are you talking about INSERTS only, or also UPDATES and (maybe) DELETES?

SSIS can probably do it (depending on your answer to the above and the existence of columns such as...