SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Where to install vendor DLL drivers on SQL Server box for use in SQL Agent SSIS job

  On a SQL Server 2016 server (not my local machine), where do I need to install a vendor's ODBC and/…

  unknown_sql

  3 replies

  7 years, 2 months ago

  By: unknown_sql

• Simple question on multiple INNER JOINs

  Hello I am trying to join tables in an Access Database, which I'm reading via SQL queries under Act…

  milasoft64

  10 replies

  7 years, 2 months ago

  By: sgmunson

• Split column values using delimiter and insert them into referenced table

  Hello,I am copying few million rows from Table1 into Table2 via INSERT INTO...SELECT. Caveat is tha…

  inHouseDBA

  8 replies

  7 years, 2 months ago

  By: ScottPletcher

• How to Deploy Multiple SSRS reports from folder (at a time) using commend prompt or Batch file

  Hi Team,  Could you please help me how to deploy more than one SSRS report(RDL files) at a tim…

  manavairajan

  1 replies

  7 years, 2 months ago

  By: Sue_H

• CASE with LEN Evaluation

  I'm struggling with this bit of code within a case Statement: CASE     WHEN (LEN(([…

  DinoRS

  12 replies

  7 years, 2 months ago

  By: DinoRS

• carriage return in dynamic sql

  How do you add a carriage return with dynamic sql? This doesn't work.DECLARE @SQL NVARCHAR(MAX)SET …

  michaelyarbrough1975

  5 replies

  7 years, 2 months ago

  By: michaelyarbrough1975

• SQL security question: Extract limited dataset without granting access to all tables needed for the extract

  I apologize for the confusing title, but I think its accurate. I have the following basic scenario.…

  DataAnalyst011

  5 replies

  7 years, 2 months ago

  By: Jonathan Szeto

• Pass date input parameter as float data type

  Hello,I have a stored procedure that takes date as input parameter but it converts that date parame…

  lukaszpiech

  5 replies

  7 years, 2 months ago

  By: ScottPletcher

• SSMS, right click on a table takes ages.

  Hello all, In SSMS, in the object Explorer a right click on a table (context menu) takes ages. (SSM…

  ben.brugman

  3 replies

  7 years, 2 months ago

  By: ScottPletcher

• Who made that change which caused the job to fail? Everyone said "Not me....."

  I had a list of users who have access to the folder where all our SSIS packages are and someone mad…

  LearningDBA

  3 replies

  7 years, 2 months ago

  By: Grant Fritchey

• Get count for changed value

  Hi, I need to to something similar for TOwners like I have for WorkDone  in the code below . I…

  PSB

  3 replies

  7 years, 2 months ago

  By: PSB

• Dynamically outputting a set of columns based on another Tables records

  I have a table (called #OutputTable) which i would like to be able to dynamically select certain co…

  Weegee2017

  14 replies

  7 years, 2 months ago

  By: Thom A

• Query to get next month's Data

  Hi,I am trying to get the report for the next month , but every month no of days are different .Can…

  adisql

  4 replies

  7 years, 2 months ago

  By: Lynn Pettis

• How to select the data from JSON file

  Hi All, how to select the data from JSON text file.Please check the below json format and my s…

  polo.csit

  1 replies

  7 years, 2 months ago

  By: CKX

• Year By Months -Columns

  Hi guys In what way can I have a result of a table that the columns are the years and months. I wou…

  angelreynosog

  5 replies

  7 years, 2 months ago

  By: jcelko212 32090