SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• SSIS Random Failure reading from Excel

  I have an SSIS package that's looping thought a folder of Excel files and loading them into SQL Sta…

  planetmatt

  17 replies

  3 years, 1 month ago

  By: Ed B

• one dbmail is getting delivered thousands of time

  One of the dbmail is getting delivered thousands of time. Same recipient, same subject , same body.…

  skb 44459

  2 replies

  3 years, 1 month ago

  By: Jeff Moden

• SQL query change font color based on value

  Good Morning. I made a view with select in SQL. I need the negative numbers to be in green color, a…

  ograndioso

  6 replies

  3 years, 1 month ago

  By: Phil Parkin

• Hello. I need a computed field im my view

  Good Morning I need to subtract : a.[Vendas Ultimo Ano]-2.STKActual and b.[Vendas Ultimo Semestre] …

  ograndioso

  5 replies

  3 years, 1 month ago

  By: ograndioso

• Can I use XML.modify in combination with SELECT statement

  I need to add xml data stored in multiple rows in a table  to a XML document by using XML.modify Wh…

  Harry Drenth

  2 replies

  3 years, 1 month ago

  By: Harry Drenth

• T-SQL : Slicing time Islands and gaps

  Hello, Consider the following table that gives the validity dates of an item : create table #table…

  MrRobot

  11 replies

  3 years, 2 months ago

  By: MrRobot

• How to avoid using operator when there are different values on two tables ?

  I work on sql server 2017 I need to get different of feature value based on partid and feature name…

  ahmed_elbarbary.2010

  9 replies

  3 years, 2 months ago

  By: Jeff Moden

• Error: excel automation Open File does not work in SQL 2017

  This code works on other 2005 SQL Sever but my 2017 SQL Server gives error. /* Excel Automation*/d…

  skb 44459

  3 replies

  3 years, 2 months ago

  By: frederico_fonseca

• How to get correct Part Feature Number when Part Exist ?

  I work on sql server 2017 I have table #partsfeature already exist as below   create table #pa…

  ahmed_elbarbary.2010

  10 replies

  3 years, 3 months ago

  By: ahmed_elbarbary.2010

• How to make select Dense Rank over max of TechnologyId Based on FeatureString Fo

  I work on sql server 2017 i have table have dense rank over FeatureString and column store rank inc…

  ahmed_elbarbary.2010

  2 replies

  3 years, 3 months ago

  By: ahmed_elbarbary.2010

• sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

  It seems that SQL*Server does not have equivalent of Oracle %ROWTYPE ? Unless I am lookin…

  allan.ford17

  24 replies

  3 years, 3 months ago

  By: ratbak

• Calculate field in SQL statement

  How we can achive from sql for balance field. I have attacted png file to expain. I will try my bes…

  sks_989

  12 replies

  3 years, 3 months ago

  By: MMartin1

• when save float numbers it converted to IE so how to solve this issue ?

  I work on sql server 2017 i face issue when save data on float column data type it saved as IE-07 A…

  ahmed_elbarbary.2010

  6 replies

  3 years, 3 months ago

  By: Steve Collins

• How to handle sticks on column country1 and country2 columns ?

  I work on sql server 2017 i have table data as below i need to make design for data to be best prac…

  ahmed_elbarbary.2010

  5 replies

  3 years, 3 months ago

  By: Jeff Moden

• need some help in tweaking a query

  Hi All, I am looking for some tsql help. I am from Oracle background. Not good at programming. Got …

  bobrooney.81

  4 replies

  3 years, 3 months ago

  By: bobrooney.81