SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Add another column with some commands

  i have a script below to find all the db fixed role db_datawriter. this is working fine, no issues.…

  lan2022nguyen

  12 replies

  1 year, 8 months ago

  By: Steve Jones - SSC Editor

• Generate a script to drop a DB user

  I have a script below to search ALL DBs for a specific user: DECLARE @DBuser_sql VARCHAR(4000) DECL…

  lan2022nguyen

  2 replies

  1 year, 8 months ago

  By: lan2022nguyen

• There is no recursion in my CTE SQL request

  I have very simple table I want to receive table with i,id and text column like 67->304->303…

  Alex1337

  2 replies

  1 year, 8 months ago

  By: Alex1337

• URGENT - Visio Diagram from SQL Server Database

  Can Someone tell me how to import database from SQL server to Microsoft Visio to create Database Di…

  Kajal

  1 replies

  1 year, 8 months ago

  By: Jeff Moden

• between is not working the way I would think?

  Can someone tell me why this does not pull any data? Data consists of fcinvoice, finvdate, fcstatus…

  bswhipp

  21 replies

  1 year, 8 months ago

  By: drew.allen

• Logic that looks at min value of one field and populates value of another field

  Hello everyone, I am trying to understand how to build a logic in SQL which will create a field "AC…

  JeremyU

  8 replies

  1 year, 8 months ago

  By: drew.allen

• Joining tables

    I'm a real beginner of SQL and have not managed to solve this. I'm trying to join all the in…

  pelusch

  1 replies

  1 year, 8 months ago

  By: Ant-Green

• SQL Break-Up

  Please help me break this code? I have my understanding, would you break it up by colour/function a…

  yrstruly

  2 replies

  1 year, 8 months ago

  By: frederico_fonseca

• Replacing a Db with another

  Please assist. I have a database on a live Production Server that is out of sync and not giving the…

  yrstruly

  5 replies

  1 year, 8 months ago

  By: frederico_fonseca

• Calculations in TSQL

  Please check if my calculation(s) are correct, in accordance to this policy: "The general fuel levy…

  yrstruly

  3 replies

  1 year, 8 months ago

  By: Eirikur Eiriksson

• percentage of total trips broken down by month

  Hi All, I have a massive data set which breaks down how many trips were taken on which days of whic…

  lin123

  11 replies

  1 year, 8 months ago

  By: Jeff Moden

• Reconcile employees with multiple IDs into Unique IDs

  Hi, I have a scenario where my employee table has multiple IDs. The background to this scenario is …

  masterelaichi

  11 replies

  1 year, 8 months ago

  By: masterelaichi

• Can someone tell me why this select statement does not pull the correct data?

  Data consists of fcinvoice, finvdate, fcstatus 0000071053, 2016-05-02 00:00:00.000, F 0000071894, 2…

  bswhipp

  1 replies

  1 year, 8 months ago

  By: Phil Parkin

• Self join the table itself

    Hello I have such a situation I have a table, I called it 'table' that I most likely need to…

  JeremyU

  2 replies

  1 year, 8 months ago

  By: Phil Parkin

• SSMS access and code formatting

  Hi Everyone, I am new to T-SQL and I need to write some basic code on a dev server. What is the bes…

  oneteabag

  19 replies

  1 year, 8 months ago

  By: oneteabag