Hello all,

many thanks again for the responses.

The error was indeed caused in the vendor software and now has been resolved internally - nothing related to embedded NULLs.

Thanks,

Marin

Hello all,

many thanks for the quick replies, much appreciated.

The confusing part is that it is apparently the value that replaces the placeholder is the cause... The SQL servers are on...

Hello Sean,

many thanks for the quick reply.

It is a 3rd party software (interface engine) that processes the CSV file and sets the value in the placeholders before running the...

Hello Luis and Scott,

many thanks for the replies much appreciated, both suggestions are highly welcome.

However, I forgot to specify that it is not always just one category from distinct master...

Hello Dixie Flatline and Kingston,

many thanks for your quick responses, much appreciated.

Kingston's solution is exactly what I am looking for - I did not know how to group by date...

...thanks also to Mark, will give it a try as well.

Marin

Hello Drew/Mike,

many thanks for the quick answers, much appreciated.

Drew is absolutely correct about my choice of sample date: this is because in AUS format zero is being dropped for...

Hello John,

many thanks for the quick reply.

In the meantime I found the answer in the very form I need it:

http://www.sqlservercentral.com/Forums/Topic515146-338-1.aspx

Regards,

Marin

Hello Lowell,

thanks again for your response - in the meantime I managed to solve the problem myself.

It seems as if port 1433 is not automatically set on installation for...

Hello Lowell,

thanks for the quick response. Unfortunately I can not connect via 127.0.0.1\SQLEXPRESS - this is my problem described in the issue. If I use machine name instead of 127.0.0.1...

Thanks Gopi for input!

Will give it a try as well...

Cheers,

Marin

Hello Chris,

your sugesstion is really helpful as well!

Although information in extra column might look kind of useless at first sight, I need it for further processing exactly like it is...

Hello bnordberg,

well, I'd really like to see how your queries look like after you've had your cup of coffee 🙂 , but this one just hits the nail on the...

Hello Chris,

thanks for your input.

Unfortunately it is not what I'd like to achieve. I need a way to "flag" the rows having identical values in column _VAL3 (kind of making...

Hello Lutz

this rocks! Many thanks for your hint, I was not aware of CTEs in MSSQL Server 2005.

Works perfectly!

Cheers,

Marin