SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• heat map as sql function or proc

  Does anyone have a good heat map function or proc that takes three params. TheValue, MinOfAllValues…

  Snargables

  4 replies

  6 years, 9 months ago

  By: Snargables

• Trying to export data into csv file using bcp stored procedure

  Can someone please help me with explaining why I am getting the error shown in the attached file?Th…

  mp88_3

  12 replies

  6 years, 9 months ago

  By: mp88_3

• Easy way to replicate SSRS Multi-Select Parameter from SSRS in TSQL?

  When attempting to diagnose issues with SSRS Reports, I often run into an issue where there is a mu…

  Steven.Grzybowski

  4 replies

  6 years, 9 months ago

  By: drew.allen

• Index on #tmp without PK

  Hello! If I create a index on a #temp table, without create a Primary Key, the index will work…

  JoseACJr

  3 replies

  6 years, 9 months ago

  By: ScottPletcher

• Merge from Heap to Clustered Index Table.... Improvements?

  Hello hello! The source will have approx 10 million rows on each daily run: 5% fresh data (inserts…

  nslupi

  13 replies

  6 years, 9 months ago

  By: Jonathan AC Roberts

• How to connect to git in SQL Server 2016/2017 without using any third party tool

  I was curious to know if we can connect to Git in SQL Server Management Studio without using any th…

  vikasjagadale8

  3 replies

  6 years, 9 months ago

  By: vikasjagadale8

• SSAS tabular Dax help

  In my fact table, I have ordernumber and orderlinenumber column as below I need to show calculated …

  SQL_Surfer

  1 replies

  6 years, 9 months ago

  By: pietlinden

• SSIS Can't set foreign keys to NULL in an update

  Hi,I'm  trying to recreate a stored procedure within SSIS .Basically what I'm trying to do is …

  arthovs94

  2 replies

  6 years, 9 months ago

  By: ScottPletcher

• SSIS Conditional Split with Multiple conditions

  I am building an ssis upload into sql.  the excel sheet tht I import contains multiple supplie…

  debbie.coates 10909

  1 replies

  6 years, 9 months ago

  By: drew.allen

• Unpivot query

  All, DDL and DML: CREATE TABLE [dbo].[tabDemo]( [ProductGroup] [varchar](50) NULL, [ContactTyp…

  as_1234

  4 replies

  6 years, 9 months ago

  By: as_1234

• Operating system error code 5(Access is denied.) when running SSIS package

  Hi, I have a job step which executes an SSIS package on SQL Server 2016 SP1.  The owner of the…

  Roust_m

  1 replies

  6 years, 9 months ago

  By: frederico_fonseca

• Sort already comma separated list

  Hi I have values like this in a column which basically is the exact same thing if sorted . ORM;PS…

  PSB

  69 replies

  6 years, 9 months ago

  By: x

• Database Access Rights

  Hi,I am tying to find who have given read only access to  some user in the database. when the …

  KGJ-Dev

  1 replies

  6 years, 9 months ago

  By: Sue_H

• Group a set records based on particular row value

  Create table #tmp(id int,Type char(1))Insert into #tmpselect 1,'F' union select 1,'F' unionselect 1…

  sac.nan

  5 replies

  6 years, 9 months ago

  By: sac.nan

• Multiple Filegroups vs. Multiple Databases for better Performance

  Hi, I need to add some new tables to an existing database which will have:1 - much more read/write …

  amns

  8 replies

  6 years, 9 months ago

  By: Jonathan AC Roberts