Cast and Convert Functions are found here.

CTE examples are found here.

Also, to save you the trouble of future attempts along similar lines, it is important to understand that SQL queries reference specific objects and create execution plans based on the...

I'd use CASE and STUFF to replace a leading '-' when one exists.

declare @input table (ID int identity(1,1) primary key, Country varchar(20));

insert into @input

values ('-UK'),('-US'),('SW'), ('DE'),('FR-CA')

select ID, CASE WHEN...

You can pass multiple CEPs to your procedure using a table-valued parameter. If your lookup to Google doesn't accept multiple values, you will have to use a...

Odd problem. Was this a test or interview question?

Here is the format for nearest neighbor code in MSDN.

https://msdn.microsoft.com/en-us/library/ff929109.aspx

I agree with Eirikur, get rid of your hints.

On a small scale, say within a city, you...

Second thought: Do your tables have indexes on ODGUID,ProvGuid, and UserGuid (where those are the first columns in the index) ?

FROM [SAC].[dbo].[SO] observ

INNER JOIN [SS].[dbo].[WCD] cd on cd.ODGUID= observ.ODGUID

AND Observ.EDtm >= 'Aug 6 2013 3:55PM' AND Observ.EDtm <= 'Aug 1 2016 12:00AM'

INNER JOIN [SAC].[dbo].[SPDim] prov ON prov.ProvGUID = cd.UserGUID

AND...

A good indicator of parameter sniffing can be found from looking at the actual execution plan. If estimated numbers of rows differ wildly from the actual number...

Here is a two-pass approach to get you the values you want. The first pass gets the maximum date within ID for which each column has a (non-null)...

I agree with Jeff, that if you have company name (or a company number integer) as part of the table, then you can just use one table and identify the...

While I loathe to place a solution for what you are asking for the very reasons explained before my post.....Based on your small dataset and given the constraint of NOT...

This should work for you, but your table design is incorrect. In the long term are much better off breaking the various component ID numbers down into...

Another example, that simply uses a CASE expression to test whether a 1 appears before a 2 in the string.

with ExampleData (AlphaNum) as (select...

You can also look at the query plan and see how many threads are running from the outputs of parallel operations.