Lynn Pettis

Forum Replies Created

Viewing 15 posts - 796 through 810 (of 26,490 total)

RE: Split comma delimited field?

sgmunson - Thursday, October 25, 2018 12:45 PM
Lynn Pettis - Wednesday, October 24, 2018 3:23 PM

October 25, 2018 at 1:36 pm

#2011234
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Thursday, October 25, 2018 12:11 PM
People literally do use gui's on SQL server in real world environments. Once you...

October 25, 2018 at 1:33 pm

#2011233
RE: seperate data in 1 row

Krasavita - Thursday, October 25, 2018 11:33 AM
it is not working for me and I am asking for help
(LEFT([Person Email],(CHARINDEX(' ',[Person Email])-1),REPLACE([Person...

October 25, 2018 at 12:05 pm

#2011208
RE: seperate data in 1 row

Krasavita - Thursday, October 25, 2018 10:57 AM
there is also there at the beginning and end email ", after this code they...

October 25, 2018 at 11:23 am

#2011202
RE: How to build an app with GUI that works with SQL Server?

ZZartin - Thursday, October 25, 2018 11:16 AM
sgmunson - Thursday, October 25, 2018 10:49 AM

October 25, 2018 at 11:21 am

#2011201
RE: How to build an app with GUI that works with SQL Server?

patrickmcginnis59 10839 - Thursday, October 25, 2018 10:59 AM
Jeff Moden - Thursday, October 25, 2018 10:42 AM

October 25, 2018 at 11:16 am

#2011198
RE: I need to change the value of two fields as I insert the rows into a table

Actually, I would do it like this:

insert into [Tdataseg](
[DATAKEY]
, [Partitionkey]
, [Catkey]
, [PERIODKEY]

October 25, 2018 at 10:24 am

#2011184
RE: Item category details

sgmunson - Thursday, October 25, 2018 7:49 AM
Waqar571 - Wednesday, October 24, 2018 10:25 PM

October 25, 2018 at 9:21 am

#2011172
RE: I need to change the value of two fields as I insert the rows into a table

randyetheridge - Thursday, October 25, 2018 8:44 AM
ok got it now. So I cannot use wild card Select. must declare each column. ...

October 25, 2018 at 9:05 am

#2011167
RE: increment months for two dates combination as a new label column

Jeff Moden - Thursday, October 25, 2018 7:54 AM
David Burrows - Thursday, October 25, 2018 2:02 AM

October 25, 2018 at 8:30 am

#2011152
RE: Are the posted questions getting worse?

Brandie Tarvin - Thursday, October 25, 2018 4:40 AM
Lynn Pettis - Wednesday, October 24, 2018 2:17 PM

October 25, 2018 at 7:56 am

#2011139
RE: Find average of child records within date range

jcelko212 32090 - Wednesday, October 24, 2018 1:59 PM
Why did you fail to post DDL? Now we have to guess from what...

October 24, 2018 at 3:37 pm

#2011027
RE: How to build an app with GUI that works with SQL Server?

sgmunson - Wednesday, October 24, 2018 2:46 PM
patrickmcginnis59 10839 - Wednesday, October 24, 2018 1:54 PM

October 24, 2018 at 3:33 pm

#2011026
RE: increment months for two dates combination as a new label column

jcelko212 32090 - Wednesday, October 24, 2018 2:07 PM
Jonathan AC Roberts - Monday, October 22, 2018 5:07...

October 24, 2018 at 3:27 pm

#2011023
RE: Split comma delimited field?

ScottPletcher - Wednesday, October 24, 2018 2:48 PM
I'd use a cross tab within the CROSS APPLY to reduce overhead (I would think).

October 24, 2018 at 3:23 pm

#2011022

Viewing 15 posts - 796 through 810 (of 26,490 total)