substring fuction expects a string to work with you column BLLG_END_DT is of datetime type   to get the desired result try the following:

SELECT TOP 10...

User input : Distance range, interval . Need a t-sql which can navigate a set of data based upon the inpur range and returns the sum of value at...

You cant use a constraint or index to determine your flow.

This article will help you with the insert/update logic

http://source.entelect.co.za/why-is-this-upsert-code-broken

You can use the FOR XML method

declare @vendor int = 5689

select vendors.vendorid, vendors.customerid
     , CustomerNames = CAST(STUFF(( SELECT ',' + customers.firstname + '...

Dark

This should be a bore performant solution

SELECT      Hyperlink = w.value( '(ActionInfo/Actions/Action/Hyperlink/text())[1]', 'varchar(100)' )
         ...

It would appear that I have selected the correct answer, yet it says that I have not

Average

You may want to wrap the space in the ISNULL as well,...

• This reply was modified 6 years, 7 months ago by DesNorton.

bowling

In the top menu bar, select Forums > Most active. This seems to give a...

I note that once a topic has been read, it does not appear change in any form in order to indicate that it has been read.

Also, I cannot see how...