Lynn Pettis

Forum Replies Created

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

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
RE: Split comma delimited field?

Think dynamic pivot of the delimited values. You will need to determine the maximum number of values in the column being split. Really looks like something for dynamic SQL, but...

October 24, 2018 at 2:22 pm

#2011018
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, October 24, 2018 2:16 PM
Ed Wagner - Wednesday, October 24, 2018 2:04 PM

October 24, 2018 at 2:17 pm

#2011015
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, October 24, 2018 2:04 PM
Lynn Pettis - Wednesday, October 24, 2018 1:54 PM

October 24, 2018 at 2:16 pm

#2011013

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