SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• SSIS Error Handling

  I'm trying to add some more robust error handling to my packages. I'm adding Try/Catch to all my Sc…

  planetmatt

  1 replies

  3 years, 9 months ago

  By: Ed B

• Archiving big table

  Hey All, We have a very big table which stores transaction data and it is SCD Type 2 table. Records…

  deepakn6.1987

  2 replies

  3 years, 9 months ago

  By: Jeff Moden

• 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, 10 months 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, 10 months ago

  By: Jeff Moden

• 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, 10 months 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, 10 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, 11 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, 11 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, 11 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, 11 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, 11 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, 11 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, 11 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, 12 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

  4 years ago

  By: bobrooney.81