SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SSIS : C# script that reads txt file and generates several excel files from it

  Dear all, I have this txt file from where I will need to extract infromation (generate several exce…

  river1

  3 replies

  7 years, 9 months ago

  By: river1

• Case sensive search using IN in a case statement.

  Below is my code. I need to search on 5 terms. The example givin, it is pulling rcords with 'APPROV…

  bswhipp

  2 replies

  7 years, 9 months ago

  By: bswhipp

• SQL Server Agent with Proxy - running under incorrect credentials

  Hi,I've got a batch file which simply echos the username (%USERNAME%), and I'm calling this from a …

  Steve Smith-163358

  1 replies

  7 years, 9 months ago

  By: Sue_H

• ORDER By Based on Company then SubCompany

  Hello,Trying to create a selection in a specific order.The table is like this  CompanyName , C…

  jslist

  21 replies

  7 years, 9 months ago

  By: jslist

• suggestion on table order inside a join ?

  Hi All, Does the order in which the tables are placed inside a join matter for getting better perf…

  vsamantha35

  12 replies

  7 years, 9 months ago

  By: jcelko212 32090

• HashBytes sometimes adds trailing zeroes

  Hi, declare @Paper varchar(100), @Value_date datetime2;select @Paper = 'Kotimaiset osakaslainat, ki…

  WilburSmith

  8 replies

  7 years, 9 months ago

  By: WilburSmith

• Simplified maintenance of columnstore indexes

  Hello all, I've just started to use columnstore Indexes in a SQL Server 2016 for a datawarehouse an…

  alexander.parakhnevich 27977

  2 replies

  7 years, 9 months ago

  By: alexander.parakhnevich 27977

• MDS - Business Rule -> Stored Procedure -> Insert/Update in another DB

  Hello all,I'm not sure if i'm posting this in the correct area however it is an MDS related questio…

  cs_source

  2 replies

  7 years, 9 months ago

  By: cs_source

• Setting a variable using select with other variables in the select statement

  To all:. Happy Holidays. I  need some help on this statement. Currently this works but I need …

  bswhipp

  4 replies

  7 years, 9 months ago

  By: Eirikur Eiriksson

• I don't think Pivot is going to work

  I have a list of users who but time in on a daily basis, I want to Sum it er week and have my 52 we…

  rick.staples

  4 replies

  7 years, 9 months ago

  By: Jeff Moden

• Table updates on large table with no ID or large gaps between IDs

  Hi Folks,I have a requirement to update a field on every record on a series of large tables (> 3…

  hoffy

  8 replies

  7 years, 9 months ago

  By: Jason A. Long

• Difference between dates displayed in days, hours, minutes and seconds

  It is right? CREATE FUNCTION dbo.ufn_DifferenceBetweenDates(  @Date1 Datetime,    &n…

  robinson.netdevelop

  6 replies

  7 years, 9 months ago

  By: Jeff Moden

• Can someone explain how this works

  This code works, but I don;t understand it.  The part I need some clarification is on the Retu…

  macbaze72

  5 replies

  7 years, 9 months ago

  By: Jeff Moden

• Issue converting image data type to string

  I've done some research on this and have yet to fully understand why it's happening and how I can f…

  thinkink07

  2 replies

  7 years, 9 months ago

  By: thinkink07

• Search for account by account segment

  Hello SQL Experts,I have a table with account #'s ( Example :  20-200-300-4000)I am using para…

  Hogie503

  4 replies

  7 years, 9 months ago

  By: Hogie503