george_at_sql

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 81 total)

RE: Best option to insert data from Staging table to main table

KGNH - Wednesday, July 4, 2018 3:37 AM
Hello every one,
I have a requirement when I have to load the data from staging...

July 5, 2018 at 11:11 am

#1996439
RE: How to use functions to update columns?

patelxx - Saturday, June 30, 2018 2:00 AM
I am a beginner with using functions, I need to update only one column (which...

July 1, 2018 at 9:45 am

#1995943
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

BONITO - Saturday, June 30, 2018 1:50 AM
george_at_sql - Friday, June 29, 2018 10:15 PM

June 30, 2018 at 10:39 pm

#1995929
RE: Conditional join on multiple columns or huge CASE?

Vegeta7 - Friday, June 29, 2018 7:03 PM
Luis Cazares - Friday, June 29, 2018 12:06 PM

June 30, 2018 at 1:49 am

#1995912
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Friday, June 29, 2018 8:10 PM
what is the criteria to check if its a "duplicate". How did you arrive at...

June 29, 2018 at 10:15 pm

#1995908
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Friday, June 29, 2018 2:31 AM
Hi Sir,
Can i change my query to count how many duplicate records in my col1...

June 29, 2018 at 12:58 pm

#1995873
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Friday, June 29, 2018 12:53 AM
Hi Sir,
I don't understand the code below, 'Join data b' ????
I am only working...

June 29, 2018 at 1:18 am

#1995750
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Friday, June 29, 2018 12:02 AM
george_at_sql - Thursday, June 28, 2018 11:48 PM

June 29, 2018 at 12:51 am

#1995748
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Friday, June 29, 2018 12:02 AM
george_at_sql - Thursday, June 28, 2018 11:48 PM

June 29, 2018 at 12:25 am

#1995747
RE: how to count col1 and col2 as One, where col1 is not duplicate and col2 = fail

Ladia_emil - Thursday, June 28, 2018 10:25 PM
I can't use where because i have another data to query,
Total_input | Total_Ok | Total_Fail...

June 28, 2018 at 11:48 pm

#1995745
RE: Help in writing query for update

Thom A - Tuesday, June 26, 2018 5:48 AM
This is one solution, however, I'm not a fan of it. A calendar table...

June 26, 2018 at 6:00 am

#1995258
RE: Please help - complete missing data with latest recorded

romina - Monday, June 25, 2018 8:28 AM
Thank you

June 25, 2018 at 12:36 pm

#1995203
RE: Logging options while running stored procedure

Jeff Moden - Tuesday, June 19, 2018 3:03 PM
Heh.... "Updated_By". One of the most commonly overlooked reasons for massive fragmentation both physical...

June 19, 2018 at 9:15 pm

#1994564
RE: Logging options while running stored procedure

Grant Fritchey - Tuesday, June 19, 2018 2:29 AM
Only concern I have is that looks like a big transaction. Will there be...

June 19, 2018 at 9:14 pm

#1994563
RE: Logging options while running stored procedure

BrainDonor - Tuesday, June 19, 2018 1:04 AM
I've worked in places where similar audit methods have been used and to be honest,...

June 19, 2018 at 1:26 am

#1994389

Viewing 15 posts - 16 through 30 (of 81 total)