SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Audit Table - Indexes

  I am looking at optimising the table below. The database instance is  SQL server,  hosted  in AWS. …

  vamshi.sql

  7 replies

  6 years ago

  By: Jeff Moden

• SQL SEREVR QUERY

  I HAVE A TABLE called TBLGENDER LIKE BELOW IN THIS TABLE 2 people getting 8000,2 people getting 550…

  shiva996

  9 replies

  6 years ago

  By: shiva996

• SQL Server Partial Unpivot for defined days columns, repeat rows by column

  Hello, I need to process stock information by day, but the database stores the info per week, using…

  MatiOli

  13 replies

  6 years ago

  By: David Burrows

• SSIS - Adding Columns to existing table and load data

  I am working in SSIS (Sql server version 2012) , I have a requirement to add two new columns to a d…

  sunshine

  4 replies

  6 years ago

  By: latkinson

• Selecting non-overlapping Date Ranges

  I want to select non-overlapping date ranges, which share a common value.  I have prepared the foll…

  tom 69406

  3 replies

  6 years ago

  By: Steve Jones - SSC Editor

• Team Members (recursion)

  Hi, I'm stuck with a recursion query. Consider a stuff/employee table like this: drop table if exis…

  rotcha99

  3 replies

  6 years ago

  By: rotcha99

• Oracle Data Access, but which installer?

  Hello! I'm trying to get the ODAC tools installed in two different types of environments. I managed…

  ben.kentzer

  1 replies

  6 years ago

  By: ben.kentzer

• Sql server Date conversion

    Here is dob data type is date select name,salary,dob from person where dob>='2019-08-30'-…

  shiva996

  8 replies

  6 years ago

  By: shiva996

• How to make a non-unique row unique again

  First of all I don't have code to provide but imagine the following scenario: You are manufacturing…

  DinoRS

  2 replies

  6 years ago

  By: DinoRS

• Reset the total to zero when ItemCount is >= 6

  Here's my SQL query: I want to have a sum of the item count reset to 0 when the sum >= 6. Please…

  ziangij

  7 replies

  6 years ago

  By: Eirikur Eiriksson

• Error with IDENTITY property on primary key column

  I just can't figure out what is wrong with this code: CREATE TABLE SubEmployee ( LineNo …

  michael.leach2015

  7 replies

  6 years ago

  By: Jeff Moden

• System tables, System base tables and base tables

  I cannot find a good explanation about how these 3 things differ from each other. Can anybody expla…

  michael.leach2015

  4 replies

  6 years ago

  By: Jeff Moden

• New login doesn't appear in Security > Logins folder

  I think my original login was DESKTOP-8J18OSS\micha which appears in the folder Security > Login…

  michael.leach2015

  4 replies

  6 years ago

  By: michael.leach2015

• Strange Severe Error Occurred Scenario

  We ran into a very strange error earlier this week that I wanted to share (and see if anyone might …

  DB_Newbie2007

  1 replies

  6 years ago

  By: DB_Newbie2007

• Linked Teradata Server Query Problems

  Hi - I'm a little bit of a novice with SQL and typically only use management studio for analysis - …

  ryan_d

  1 replies

  6 years ago

  By: Steve Collins