Great start. Based on the sample data, what would your desired results look like?

Duplicate post, answers here, please: https://www.sqlservercentral.com/forums/topic/xabse-convert-varchar-to-numeric

You're in a SQL Server forum, not XBase. There may be people here who can help you, but you may be better off finding a forum dedicated to XBase.

'16:00' is not a valid numeric value, so you cannot do this. What are you trying to do?

Are you going to provide DDL & sample data for this?

Thanks, Phil.  I really appreciate your feedback on these types of things.

As a bit of a side bar, how do you like that new Azure ETL tool?  Does it...

Hi Jeff, I'm still fairly new to Azure (six months and counting ... slowly!) and have been spending a lot of time on the DevOps side rather than doing 'proper'...

Azure Blob Source does not supports multiple-character delimiter.

Nit-picking a little, but the delimiter is only a single comma. The double quotes are text qualifiers.

As it's coming out of a text file, it has no...

try
{
OneLineOfCode;
try
{
AnotherLineOfCode;
try
{
ThirdLineOfCode;
}
catch(Exception ex) {}
}
catch(Exception ex) {}
}
catch(Exception ex) {}

This code was "generated by a tool" 🙂

If you can live with the quotes on the column names, it would be easy enough to use derived columns to remove the quotes from the data itself.

Instead of

SELECT cols

...

Try

SELECT DISTINCT cols

...

Does that help?

Use @@SERVERNAME?

Use

SELECT ItemNo = ISNULL(ItemNo,0)

Here is the general pattern for a MERGE...

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