SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Compare two rows in the same table for equality in SQL

  I have the following table in my database: Table name: INSURANCE TABLE Columns names: ID | Policy C…

  sujeeth.selvam

  5 replies

  7 years, 5 months ago

  By: drew.allen

• Sumatory error

  Hi guys, my question is the following: How is the sumatory (sum(units_sold)) giving me the num…

  joao.piti98

  3 replies

  7 years, 5 months ago

  By: Lynn Pettis

• VS2017 loses non-default 'Open With' setting for .sql files

  I have modified settings inside VS2017 to open .sql files with Explorer.exe. This opens the file in…

  Phil Parkin

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• What exactly are window functions and partitions?

  Hi everyone,I've been reading about ranking functions in the T-SQL docs and I'm still unclear on th…

  gacanepa

  5 replies

  7 years, 5 months ago

  By: MMartin1

• Need to Restart SSAS through SQL Agent Job remotely

  Hi All,Need power shell script to restart SSAS server form another SSIS - SQL Agent job stepWe are …

  itsvenkyyy

  2 replies

  7 years, 5 months ago

  By: itsvenkyyy

• Combine 3 SQL queries

  Hello,I want the combine the following queries Select Complains.[Subject] as NewComplains,Com…

  Mando_eg

  14 replies

  7 years, 5 months ago

  By: Jan Van der Eecken

• Stored Procedures with Linked Servers - Failover Question

  Hi, I have a SQL Server 2016 Availability Group between two geographic sites.  In a couple of …

  dajonx

  2 replies

  7 years, 6 months ago

  By: dajonx

• Divide column data into equal parts

  I want to split one of the column's data into 8 equal parts. For eg. i have 73 rows currently in on…

  Papil

  14 replies

  7 years, 6 months ago

  By: Jeff Moden

• Error running execute xp_cmdshell

  Hi AllI can run this from the command prompt C:\Windows\System32\WindowsPowerShell\v1.0\powershell.…

  Northern Monkey

  3 replies

  7 years, 6 months ago

  By: Northern Monkey

• SQL Beginner: one to many relationship, updating single row based on many rows in join table

  Hello, I'm fairly new to SQL and seem to be struggling with the concept of "one to many". I'll use …

  aobf

  13 replies

  7 years, 6 months ago

  By: John Mitchell-245523

• HTTP command

  Hi All, I need to run an http from an SQL procedure (for example http://woodwell.gr/uploads/re…

  ionas

  2 replies

  7 years, 6 months ago

  By: ZZartin

• Filter By AND e not for OR/AND

    Good eveningI need your valuable help. For the following example: =en-us> In this DataSet…

  jmolapa

  4 replies

  7 years, 6 months ago

  By: jmolapa

• Tempdb growth

  Hi, I have a huge insert/update operation performing in set of tables. The process tooks almost 1-2…

  haichells

  9 replies

  7 years, 6 months ago

  By: RandomStream

• Rounding a numeric value to nearest integer

  Hi , I am trying to round the following numbers to nearest integer.SELECT ROUND(9.6,0)SELECT ROUND(…

  khpcbgnt

  5 replies

  7 years, 6 months ago

  By: Lynn Pettis

• Creating multiple Rows from one row by substringing a column

  I need to create from 1 to n rows from a single row where the one column in the read tabl…

  lsinoff

  5 replies

  7 years, 6 months ago

  By: lsinoff