jonathan.crawford

Forum Replies Created

Viewing 15 posts - 466 through 480 (of 607 total)

RE: Issues with matching pattern using LIKE

J Livingston SQL - Friday, December 15, 2017 8:06 AM
DECLARE @searchString VARCHAR(1500);
SET @searchString = '03/09/2017 07:52 AM | Lastname, Firstname...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 18, 2017 at 8:19 pm

#1972615
RE: Issues with matching pattern using LIKE

Luis Cazares - Friday, December 15, 2017 7:40 AM
Why would you try to escape the pipe? It's not a wildcard in t-sql.
isn't...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 18, 2017 at 8:17 pm

#1972614
RE: Issues with matching pattern using LIKE

Luis Cazares - Friday, December 15, 2017 8:09 AM
What about avoiding the pattern match and check for valid date values?

DECLARE...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 18, 2017 at 8:14 pm

#1972613
RE: Issues with matching pattern using LIKE

ScottPletcher - Friday, December 15, 2017 8:00 AM
jonathan.crawford - Friday, December 15, 2017 6:54 AM
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 18, 2017 at 8:08 pm

#1972612
RE: Issues with matching pattern using LIKE

The spaces are not the issue, it's <date><space><time><space><[AP]M><space><pipe>, but declaring the escape character seems to be the issue. Thank you!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 15, 2017 at 6:54 am

#1972292
RE: Are the posted questions getting worse?

Luis Cazares - Thursday, December 14, 2017 12:14 PM
My opinion is that you need to make healthcare and higher education affordable...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 14, 2017 at 8:44 pm

#1972234
RE: Are the posted questions getting worse?

Thom A - Tuesday, December 12, 2017 7:09 AM
https://blogs.technet.microsoft.com/dataplatforminsider/2017/12/11/whats-new-in-ssms-17-4-sql-vulnerability-assessment/
I'm actually a little concerned what our VA report is going to look...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 13, 2017 at 6:25 am

#1971939
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Friday, December 1, 2017 11:30 AM
Grant Fritchey - Friday, December 1,...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 5, 2017 at 8:44 am

#1970731
RE: Are the posted questions getting worse?

Sean Lange - Friday, December 1, 2017 9:05 AM
Brandie Tarvin - Friday, December 1, 2017 8:28 AM
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

December 5, 2017 at 8:42 am

#1970730
RE: Are the posted questions getting worse?

Luis Cazares - Monday, November 13, 2017 2:24 PM
Jeff Moden - Monday, November 13, 2017 12:58 PM
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 14, 2017 at 5:50 am

#1967936
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, November 10, 2017 5:49 AM
Sean Lange - Thursday, November 9, 2017 2:42 PM
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 10, 2017 at 5:54 am

#1967510
RE: Are the posted questions getting worse?

jasona.work - Tuesday, November 7, 2017 1:28 PM
I...
I'm speechless...
Joe C has a sense of humor about his forum persona: https://www.sqlservercentral.com/Forums/FindPost1906603.aspx
:blink:
I...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 8, 2017 at 10:25 am

#1967209
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, November 8, 2017 8:54 AM
I'm a speed reader. The way I read items, things have to be bunched...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 8, 2017 at 10:21 am

#1967208
RE: Dynamic variables in SQL server for HTML

70712 - Tuesday, November 7, 2017 5:04 AM
jonathan.crawford - Tuesday, November 7, 2017 4:59 AM
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 8, 2017 at 10:14 am

#1967206
RE: Dynamic variables in SQL server for HTML

Why do you need to know how many columns though? If you just add the tags for the row at the beginning and end of your SELECT, and add tags...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

November 7, 2017 at 4:59 am

#1966964

Viewing 15 posts - 466 through 480 (of 607 total)