declare @string varchar(50) = 'ABC Property Management Inc.'

SELECT string_agg(x.value,' ') FROM (
select top 2 * from string_split(@string,' ') y)x

all these jobs should only take a couple of minutes to run, and usually run on a schedule of every 5 minutes, but sometimes they get stuck on something and...

is it considered a currency symbol somewhere?
all these return 0.00

select \
select £
select $
select ¥
select €

i found this. never heard of it before, though.

https://stackoverflow.com/questions/6529053/when-should-i-use-an-inner-loop-join-instead-of-an-inner-join

james.brown 6144 (11/21/2014)

---

@david.Andrews.

Not that this really helps but..

The MSDN entry for the TRY_CONVERT function (http://technet.microsoft.com/en-us/library/hh230993(v=sql.110).aspx) has the remarks "TRY_CONVERT is a new keyword in compatibility level 110"...

i've been trying to get TRY_CONVERT to work but it states its an unrecognized built in function for sql server 2012 (even though sql server *does* recognises it because i...

briiiiiliant!!

i shall hold you to that. 🙂

i see. thought so, but was still hoping!

do you have any good articles you can point me to, about proper partitioning?

;WITH cte_Client AS (SELECT 1 AS ClientID ,'bob' AS NAME UNION SELECT 2,'john')

,cte_Services AS (SELECT 1 AS ServicesID, 1 AS ClientID, GETDATE() AS ServiceDate UNION select 2,1,DATEADD(DAY,-82,GETDATE()) UNION SELECT 1,2,DATEADD(DAY,-81,GETDATE()))

SELECT...

have you tried this?

DECLARE @5YearsAgo SMALLDATETIME = dateadd(yy, -5, GETDATE())

DECLARE @SetVal INT = (select settingvalue from ApplicationSettings_tbl where appsettingid = 1136)

select pd.companyId, asOfDate as scoreDate, Convert(numeric(38,10),pd.PDValue) * 100...

i'm presuming that the code in your EXISTS statement always brings back at least one row?

it looks like, because it always brings back data, the EXISTS statement will always come...

i always felt that if the ID column was in a Table called 'State', then its self explanatory that its the 'StateID'.

so it was unecessary to call the column 'StateID'.

It...

SELECT CONVERT(INT,ROUND(10.50,0))

SELECT CONVERT(INT,ROUND(10.49,0))

good advice. i'll certainly get in the habit and also update Procedures as-and-when i get to them so that, come day zero, it wont be such a big problem.