SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Inner joins

  Hi all.Our current version is 2008 and we are going to migrate it to 2016 or 2017.In many stored pr…

  SQL Guy 1

  19 replies

  6 years, 11 months ago

  By: x

• OPENROWSET

  WHT DOES THIS--select top 1 a.* into #t from openrowset('SQLNCLI', 'Server=localhost;Trusted_Connec…

  Budd

  3 replies

  6 years, 12 months ago

  By: Jeff Moden

• Select data from the right

  Hello can some one help me select data from the following: I have data:1001100110021002100310031004…

  Krasavita

  3 replies

  6 years, 12 months ago

  By: Jeffrey Williams

• Execute a Stored Procedure against every row insert in Table

  I have around 200 tables and we have insert in each table with in each seconds.so there are around …

  azhar.iqbal499

  22 replies

  6 years, 12 months ago

  By: sgmunson

• how do i do a partial string search in a Full Text Index?

  Hi I've set up a full text catalog and index on a column in my table. I need to mimic the exact res…

  stiej1977

  4 replies

  7 years ago

  By: stiej1977

• Power BI Import or DirectQuery?

  Hi all, Sorry, it is power BI related question.I am new to Power BI. I am from Sql Server BI backgr…

  a2zwd

  1 replies

  7 years ago

  By: Eirikur Eiriksson

• Obfuscating character columns

  Is anyone aware of any resources/websites/T-SQL code  that will allow me to obfuscate ALL colu…

  VoldemarG

  11 replies

  7 years ago

  By: VoldemarG

• Max Date Case When?

  Hiya all Stuck with a query (first post, quite a beginner, but a complex query (i think) My data is…

  DEANFORD

  4 replies

  7 years ago

  By: DEANFORD

• SQLServers list all in a single domain

  Under what circumstances will a SQLserver/(cluster also) will not be recognised/stays invisible to …

  mtz676

  1 replies

  7 years ago

  By: andycadley

• Always encrypted and existing Sql code

  Hello all We are upgrading some of our sql servers from 2012/2014 to 2016 so we can use always on e…

  danny.prior

  1 replies

  7 years ago

  By: sgmunson

• T-SQL Loan Repayments Schedule - PLAN v ACTUAL

  Hi All, I have used the forum with some great success in the past an hope you can help with this.&…

  Daniel Taylor-446457

  2 replies

  7 years ago

  By: sgmunson

• Processing SSRS based on record level user inputs (check box)

  Short version:I'd like to add a new check box parameter as a column in my SSRS report. I'll populat…

  Johnny B

  1 replies

  7 years ago

  By: sgmunson

• Query to be used in an Access report

  I have an Access front end database with a SQL Server front end. I need to produce in Access a repo…

  DaveBriCam

  2 replies

  7 years ago

  By: Phil Parkin

• IsNull to check column

  I need to check if col1 is null, then show Col2 else show col3.Used a case statement in the select …

  s-sql

  4 replies

  7 years ago

  By: ScottPletcher

• WHERE Clause

  I've come across a stored procedure that has this code. DECLARE @Status INT = -100 SELECT * FROM Co…

  NikosV

  2 replies

  7 years ago

  By: NikosV