Forum Replies Created
Viewing 15 posts - 586 through 600 (of 1,464 total)
-
Reply To: Is there a way to walk "up" from current XML node
This should be a bore performant solution
SELECT Hyperlink = w.value( '(ActionInfo/Actions/Action/Hyperlink/text())[1]', 'varchar(100)' )
... -
Reply To: dput()
It would appear that I have selected the correct answer, yet it says that I have not
-
Reply To: Issue with +LEFT(xx) if a value IS NULL
@Taps wrote:You can use ISNULL to replace NULL with blank - eg
SELECT (LEFT(ISNULL( middlename, '') , 1) )
You may want to wrap the space in the ISNULL as well,...
-
Reply To: Today's Random Word!
bowling
-
Reply To: Latest Topic not sorted from newest to oldest based on last post.
Lynn Pettis wrote:Topic says it all. This is worthless when not sorting the newest first.
In the top menu bar, select Forums > Most active. This seems to give a...
-
Reply To: Are the posted questions getting worse?
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...
-
RE: Difference in value from yesterday
Syed_SQLDBA - Friday, March 29, 2019 10:51 AM -
RE: Today's Random Word!
ZZartin - Thursday, March 28, 2019 3:16 PM -
RE: Very complex SQL Server logic to return multiple rows in a query even if there is only a single row of data, based on report date---will explain in post
matter2003 - Wednesday, March 27, 2019 4:19 PM -
RE: Problem using CTE
wegrob - Monday, March 25, 2019 1:45 PM -
RE: Today's Random Word!
Ed Wagner - Thursday, March 21, 2019 7:21 AM -
RE: Convert xml column data from x and shred the elements into a tabular structure.
Feivel - Tuesday, March 19, 2019 10:22 AM -
RE: Deleting rows in SQL 2014
If you test for existence first, you effectively have to access the table twice to achieve your end goal.
You could always use a transaction, and only commit the transaction...
Viewing 15 posts - 586 through 600 (of 1,464 total)