SQL Server 15 – Development

• Topics

  Started by

  Posts

  Last post

• Using recursive CTE

  I have two queries Query 1 : Retrieves last two end of month date from Date Dimension output as Act…

  Sachy123

  7 replies

  3 weeks, 5 days ago

  By: drew.allen

• insert with output clause

  I have an insert with an output clause where one of the outputted columns is not in the inserted li…

  N_Muller

  6 replies

  2 months ago

  By: sgmunson

• How to calculate income tax based on tax slab?

  Hi guys, I am stuck with a task with not getting there? I want to calculate income tax based on a …

  sqlguru1day

  1 replies

  2 months, 2 weeks ago

  By: HappyGeek

• Converting a varchar to int

  I am running the query below but I am getting an error “Conversion failed when converting the…

  spyfly

  2 replies

  1 year, 4 months ago

  By: ChrisM@Work

• Use a select for 1 column and another select for all others

  Basically I am trying to use a select for 1 column and another select for all others. I want the CO…

  spyfly

  4 replies

  1 year, 5 months ago

  By: spyfly

• Where query time between 6am and 6pm

  I am trying to modify my query so that it will only look at the data between 6am and 6pm instead of…

  spyfly

  9 replies

  1 year, 5 months ago

  By: ThomasRushton

• Creating a percentage column based on 2 know column values

  I am trying to create a query that will create a percentage based on 2 know column values I want to…

  spyfly

  4 replies

  1 year, 6 months ago

  By: Steve Jones – SSC Editor

• Graph Tables – Thoughts?

  Just wondered how much anyone has played with the new Graph Tables (Graph processing with SQL Serve…

  Thom A

  5 replies

  1 year, 6 months ago

  By: Jo Pattyn

• DateTime Field Hide time if it is midnight

  I need a query to hide the time from a datetime field if the time is midnight. I tried a case state…

  gtjr92

  6 replies

  1 year, 7 months ago

  By: gtjr92

• EXCEPT returning matching rows

  Hi, I made a change to a query to return data quicker.  I used the EXCEPT operator to make sur…

  cpeck

  4 replies

  1 year, 9 months ago

  By: cpeck

• Old Value

  I’m using this trigger to update specific columns.I want to get old values for some columns, …

  hrvoje.voda

  4 replies

  1 year, 10 months ago

  By: hrvoje.voda

• BEFORE TRIGGER Idea Posted to Microsoft Connect

  I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (…

  JediSQL

  16 replies

  1 year, 10 months ago

  By: TomThomson

• DBA Challenge! I’ve spent 4 hours trying to figure how to extract data from XML in a hierarchical form.

  I’ve searched the web to no avail.  So PLEASE help out!I have a table:CREATE TABLE [Cour…

  mrdba128

  4 replies

  1 year, 11 months ago

  By: Jeff Moden

• OpenDataSource query

  INSERT INTO OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0′,’Data Source=D:\Book1.xls;E…

  RAKSHITHA

  1 replies

  2 years, 1 month ago

  By: sgmunson

• Query tuning – Help needed

  Hi all, I’ve been looking into this query and trying to see if there is any better way to wri…

  Feivel

  11 replies

  2 years, 3 months ago

  By: jbwa