jcelko212 32090

Forum Replies Created

Viewing 15 posts - 871 through 885 (of 910 total)

RE: Remove all leading zeros from a column of data in SQL?

chef423 - Wednesday, March 15, 2017 11:39 AM
I have a data table called 'ItemNum'
The column is a SKU, which is all numbers...the...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 23, 2017 at 1:11 pm

#1934640
RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

jcelko212 32090 - Wednesday, March 22, 2017 11:04 AM
amirmir - Wednesday, March 15, 2017 12:10 PM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 22, 2017 at 11:05 am

#1934335
RE: SELECT @local_variable '=' Versus SELECT @local_variable '+='

amirmir - Wednesday, March 15, 2017 12:10 PM
Hello, I am trying to find out what is the purpose of using += when...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 22, 2017 at 11:04 am

#1934333
RE: Encapsulating complex logic without using a scalar UDF

Lynn Pettis - Wednesday, March 15, 2017 9:38 AM
jcelko212 32090 - Tuesday, March 14, 2017 2:04 PM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 15, 2017 at 7:40 pm

#1933389
RE: Encapsulating complex logic without using a scalar UDF

Jeff Moden - Tuesday, March 14, 2017 11:25 AM
Yep, agreed. I've actually done similar to what Joe suggests for the work day...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 14, 2017 at 2:04 pm

#1933140
RE: Encapsulating complex logic without using a scalar UDF

ScottPletcher - Monday, March 13, 2017 11:45 AM
jcelko212 32090 - Monday, March 13, 2017 11:17 AM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 14, 2017 at 11:31 am

#1933102
RE: Encapsulating complex logic without using a scalar UDF

Jeff Moden - Saturday, March 11, 2017 8:42 PM
jcelko212 32090 - Thursday, March 9, 2017 3:35 PM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 13, 2017 at 11:17 am

#1932921
RE: Find out consecutive date difference by comparing with master table

shagil.a.gopinath - Sunday, March 12, 2017 10:17 PM
>>I have report table where the fault report date and complete date is inserted and I...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 13, 2017 at 10:25 am

#1932907
RE: Use date and time in sql statement for join, but not required in the output

Jeff Moden - Monday, March 6, 2017 8:46 PM
jcelko212 32090 - Monday, March 6, 2017 8:00 PM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 10, 2017 at 2:26 pm

#1932794
RE: Encapsulating complex logic without using a scalar UDF

sgmunson - Friday, March 10, 2017 12:14 PM
patrickmcginnis59 10839 - Friday, March 10, 2017 9:22 AM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 10, 2017 at 12:40 pm

#1932783
RE: Encapsulating complex logic without using a scalar UDF

>> As the complex CASE statement [sic] is executed in multiple places, the natural thing to do is to place this into a user-defined function. However, we all know...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 9, 2017 at 3:35 pm

#1932622
RE: Use date and time in sql statement for join, but not required in the output

Jeff Moden - Monday, March 6, 2017 6:51 PM
jcelko212 32090 - Monday, March 6, 2017 12:34 PM
Please post DDL and follow ANSI/ISO standards when asking for help.

March 6, 2017 at 8:00 pm

#1931966
RE: Cursor Insert into table with IDENTITY crisis

TriggerMan - Friday, March 3, 2017 3:00 PM
>> 3. The insert requires that you generate a new unique identity (checkpoint_id) in the...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 6, 2017 at 12:51 pm

#1931914
RE: Use date and time in sql statement for join, but not required in the output

>>I am using the date / time from a view to join on the date / time from another part of the view, but do not require the date...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 6, 2017 at 12:34 pm

#1931906
RE: Format Date but Keep as Date Type

walter.dziuba - Sunday, March 5, 2017 9:16 AM
I have a date field of type datetime in a table.
But while I'm creating a...
Please post DDL and follow ANSI/ISO standards when asking for help.

March 6, 2017 at 12:02 pm

#1931895

Viewing 15 posts - 871 through 885 (of 910 total)