SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Strange Problem ???

  Hi guys, My code : Select A.price1, B.price2 from  (SELECT Top 100 tarih, coin, MIN(price) AS …

  xtrmus2319

  16 replies

  6 years, 10 months ago

  By: xtrmus2319

• Is 'Select Top 1000 Rows' functionality still available in SSMS 17.4?

  My question is about a specific functionality in Microsoft's release of SQL Server client: SSMS 17.…

  polkadot

  5 replies

  6 years, 10 months ago

  By: Gail Shaw

• I need a broken 10 second SQL Script

  Hi, I am doing some Q/A work where I am executing a ob that I need to fail - after 10 seconds. I am…

  krypto69

  3 replies

  6 years, 10 months ago

  By: krypto69

• 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 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

  6 years, 10 months ago

  By: jmolapa