SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Add Zero(0) to columns based on Min and Max value of the record.

  Here min Calendar year is 2010 and max Calendar year is 2013 How to add Zero to employes who does n…

  yuvipoy

  6 replies

  6 years, 6 months ago

  By: Eirikur Eiriksson

• Balancing the work among users of a group

  Hi Team, I need a help with the query to get the work balance among users in a group. There are gro…

  eshwar401

  2 replies

  6 years, 6 months ago

  By: x

• NULL Storage

  I'm trying to figure out how NULLs are actually stored in SQL Server. Non-variable types are pretty…

  Sioban Krzywicki

  8 replies

  6 years, 6 months ago

  By: Sue_H

• Current day from current week of the year

  I need help to find current day from current week of the year, and start and end dates of the curre…

  MrMister17

  4 replies

  6 years, 6 months ago

  By: Steve Jones - SSC Editor

• Categorize data without an indicator in the table

  I have a table that has two columns as follows. I am not able to categorize colB by using windows f…

  Nilesh-788004

  3 replies

  6 years, 6 months ago

  By: Nilesh-788004

• Using table for search and replace values

  I have been searching, but have not been able to find a solution for this.  Hoping someone on here …

  timothy.m.phillips

  11 replies

  6 years, 6 months ago

  By: Jeff Moden

• Convert DATETIME to a date in ISO format

  I have a field, DATO, which is formatted as DATETIME. There is no time part anyway. If I use: SELEC…

  Edvard Korsbæk

  9 replies

  6 years, 6 months ago

  By: Jeffrey Williams

• Unable to connect SQL Server Data Quality Service.

  I tried to connect SQL Server Data Quality Service, ran the tool script, but still can't connect. G…

  shamshad.ali

  2 replies

  6 years, 6 months ago

  By: shamshad.ali

• Get Records from UDT

  I’m trying to get data from User-Defined Table type which has the values needs to be inserted into …

  Whizkid

  3 replies

  6 years, 6 months ago

  By: ben.brugman

• Running SSIS package from IS catalog fails

  This is the situation. I created a project and package in SSDT 2016.No parameters involved. This pa…

  kp_svasan

  3 replies

  6 years, 6 months ago

  By: kp_svasan

• Get the multiple rows data into single row.

  Hi Team,   Please help me to get the expected data for the below details. My present data look…

  kbhanu15

  5 replies

  6 years, 7 months ago

  By: kbhanu15

• Viewing database diagrams

  Hi all   We've designed some database diagrams on our DEV server (we have SA access). We want …

  richardmgreen1

  16 replies

  6 years, 7 months ago

  By: Sue_H

• ssms crashes when editing .sql script

  I've recently been having an issue with ssms freezing and crashing while editing a sql script. The …

  Samwell

  4 replies

  6 years, 7 months ago

  By: Eirikur Eiriksson

• Need help on a query, not sure if PIVOT is what I need to use

  I have a need to get output in the following format: In this case, I have an importer (importer nu…

  woody_rd

  6 replies

  6 years, 7 months ago

  By: woody_rd

• How to send mails from sql server 2016

  Hi All I am setup mail configuration in sql server database but it is not send and return error. li…

  polo.csit

  10 replies

  6 years, 7 months ago

  By: pietlinden