SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Two tables but if 2nd table has one row that is to be ignored

  I cannot think of an easy way Two Tables Table 1    PROJECT            Project_ID , Client ID Data …

  TRACEY-320982

  6 replies

  6 years ago

  By: jcelko212 32090

• Totals of left Join on right table are off

  Morning, Hope you can set me straight. on this left join problem I'm having. I have a left Join to …

  gjoelson 29755

  4 replies

  6 years ago

  By: gjoelson 29755

• Datediff between dates, but exclude extra leap year day

  I'm trying to figure out what the best way to calculate the number of days between two dates, but I…

  below86

  11 replies

  6 years ago

  By: ScottPletcher

• Ugly left join

  not looking for solution just maybe some ideas.  This is from 3rd party vendor (i helped some with …

  tcroninlifepoint

  4 replies

  6 years ago

  By: tcroninlifepoint

• Grant exec permission but prevent DML operations in proc

  Hi I have got a business need where a user can execute a proc but if there are any DML commands in …

  S_Kumar_S

  9 replies

  6 years ago

  By: Michael L John

• Updating a column value without intermediate column

  My post is bit long. Please bear with me. Thanks. I have requirement where I need to transfer data …

  VSSGeorge

  2 replies

  6 years ago

  By: VSSGeorge

• Indexed Coalesce to get nth non-NULL value?

  I have four parameters, any of which may or may not contain a value (they may also all be NULL). Th…

  zoggling

  5 replies

  6 years ago

  By: DesNorton

• Convert date time stamp across multiple fields in case statement

  Given the availability of collected data, I'm trying to combine multiple date fields into an Inform…

  rickyschroder

  7 replies

  6 years ago

  By: rickyschroder

• func_GetInvoiceNumberByDocumentNumber

  I'd like to re-write SELECT below without using function. It returns 19544 records. SELECT dbo.Func…

  RVO

  14 replies

  6 years ago

  By: RVO

• Find Duplicate records in a table and send email notification

  Hi, In my sql server database, there is table called Ticket_NUM and there are few fields like Ticke…

  RCRock

  12 replies

  6 years ago

  By: John Mitchell-245523

• Divide two columns in different tables

  Hi all I need help with writing a SQLstatement for an Arithmetic expression (Division) by joining t…

  sql4life

  1 replies

  6 years ago

  By: nigel.

• list tables that all contain the same 3 column names

  Is there another way of getting a list of tables that all contain the same 3 column names without u…

  Budd

  4 replies

  6 years ago

  By: Budd

• import from sql tables into windows event viewer

  Dears, I need  some ideas about how to export   from 2-3  sql server tables ( filled with app  mess…

  aureliu

  5 replies

  6 years ago

  By: aureliu

• Get data on specific time interval

  Hi All, Happy new year 2020. It been long time I am here. There is a job running for me daily @ 4 A…

  yuvipoy

  1 replies

  6 years ago

  By: Mr. Brian Gale

• Comparing to Columns from the same table

  I am subtracting two columns (_REG_READING- START_REG_READING) and want to match the output (Actual…

  aznabeel

  2 replies

  6 years ago

  By: ScottPletcher