Lynn Pettis

Forum Replies Created

Viewing 15 posts - 436 through 450 (of 26,488 total)

RE: Like operator with additional conditions

sql_2005_fan - Friday, March 22, 2019 10:21 AM
Hi,
I have the following values in a column.
TT,FF,RR,GG,MM,NN
LL,PP,TT,NN
RR,NN,MM,LL
If the value had RR ,MM and NN ...

March 22, 2019 at 10:51 am

#2025233
RE: Looping through a table-valued function

RacerX330 - Friday, March 22, 2019 10:27 AM
Lynn Pettis - Friday, March 22, 2019 10:13 AM

March 22, 2019 at 10:36 am

#2025229
RE: Looping through a table-valued function

RacerX330 - Friday, March 22, 2019 9:50 AM
fair enough. the table-valued function returns investment returns for each portfolio for the specified time...

March 22, 2019 at 10:13 am

#2025221
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 - Thursday, March 21, 2019 10:37 PM
Lynn Pettis - Thursday, March 21, 2019 10:25 PM

March 22, 2019 at 8:14 am

#2025207
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 - Thursday, March 21, 2019 5:16 PM
I have a very complex scenario I am trying to work out in SQL server...

March 21, 2019 at 10:25 pm

#2025182
RE: trimming SSNs

Lynn Pettis - Friday, March 15, 2019 4:14 PM
briancampbellmcad - Friday, March 15, 2019 1:42 PM

March 15, 2019 at 5:02 pm

#2024672
RE: trimming SSNs

briancampbellmcad - Friday, March 15, 2019 1:42 PM
Lynn Pettis - Friday, March 15, 2019 1:36 PM

March 15, 2019 at 4:14 pm

#2024669
RE: trimming SSNs

briancampbellmcad - Friday, March 15, 2019 12:19 PM
pietlinden - Wednesday, March 13, 2019 9:58 AM

March 15, 2019 at 1:36 pm

#2024645
RE: Sql Query to find invalid SSN Numbers

jcelko212 32090 - Friday, March 15, 2019 11:46 AM
Lynn Pettis - Friday, March 15, 2019 8:32 AM

March 15, 2019 at 11:55 am

#2024632
RE: Sql Query to find invalid SSN Numbers

roger.plowman - Friday, March 15, 2019 6:50 AM
Jeff Moden - Thursday, March 14, 2019 9:29 PM

March 15, 2019 at 8:32 am

#2024580
RE: Query a dynamic date range based off current month

Jeff.tobin 71274 - Monday, March 11, 2019 8:26 AM
Perhaps you could utilize this:
Select * from [provider].[tbl_msow_practitioner_id_numbers] where Month(Expiration_date) = Month(DateAdd(m,-1,GetDate())) and...

March 11, 2019 at 10:24 am

#2024114
RE: Baffling results

Robert Frasca - Friday, March 8, 2019 12:36 PM
Robert Frasca - Friday, March 8, 2019 12:35 PM

March 8, 2019 at 12:40 pm

#2023976
RE: Baffling results

Robert Frasca - Friday, March 8, 2019 8:46 AM
I have two stored procedures that are functionally identical. I won't bother to post...

March 8, 2019 at 12:18 pm

#2023971
RE: Creating a Stored Procedure

Used to be, iirc, that SQL Server would warn you when the object was created that there was a missing dependency.

March 7, 2019 at 7:19 am

#2023812
RE: Filtering by date crashes report\query

Shabbaranks - Thursday, March 7, 2019 4:57 AM
Hi,
I have the following sql query
SELECT DISTINCT
scheme.ABC.users_text_field, scheme.efg.PAL_efg, scheme.efg.PAL_oqty, scheme.efg.PAL_product,...

March 7, 2019 at 7:02 am

#2023803

Viewing 15 posts - 436 through 450 (of 26,488 total)