SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• JSON: why not a JSON data type (like XML has)?

  I was just curious, is there a reason there is not a JSON data type? XML has an XML data type... wh…

  Maxer

  4 replies

  8 years ago

  By: Maxer

• SSIS: Not able to rename package

  Dear all, I have a problem when trying to rename a package name. I get this message even knowing th…

  river1

  5 replies

  8 years ago

  By: Phil Parkin

• Running balance calculation

  Hi all, I'm interested in creating a query that would calculate the balance of customers with an ac…

  piet_dj

  16 replies

  8 years ago

  By: piet_dj

• Importing a DAT file

  Hi, I have to import (ETL) a DAT file into one of our SQL databases but I'm having trouble getting …

  BI_Developer

  8 replies

  8 years ago

  By: BI_Developer

• Caught errors on linked server

  Hello!I observe unexpected SQL Server behavior which associated with errors handling I have l…

  p.zvonarev

  5 replies

  8 years ago

  By: sgmunson

• One of my Passed Exam of MCSA shows in MCSE, Why?

  Hello,I passed MCSA today.When I see the requirement for MCSE, among the list, it shows an exam (70…

  SqlServerPass

  9 replies

  8 years ago

  By: SqlServerPass

• Object Dependency

  Hi All,I am using SQL below to get the object dependency.select Obj.name,dep.referenced_entity_name…

  nadersam

  15 replies

  8 years ago

  By: nadersam

• Start of month last year

  Hi Guys, I have a query which works great and bascially brings back data from the start on the curr…

  craig.jenkins

  11 replies

  8 years ago

  By: Jeff Moden

• Best method for coding stored proc SQL to get next key to avoid DUPs

  Developer called.   She need best practice to accommodate the following:TableXYZ has a numeric…

  Express12

  3 replies

  8 years ago

  By: Jeff Moden

• [Solved] Unpivot?

  Hi all, I'm trying to turn Table A into Table B with a query. I'm studying how to use unpivot as t…

  Vegeta7

  3 replies

  8 years ago

  By: Jeff Moden

• A Window Function question...

  Hi,  I am working with Window Functions and am trying to understand their behaviour a bit bett…

  kevaburg

  10 replies

  8 years ago

  By: whenriksen

• [SOLVED] Filling Date Gaps

  Hi, I'm trying to summarize some sales figures per customer per Year-Month but can't include the mo…

  antti_turunen474

  6 replies

  8 years ago

  By: antti_turunen474

• Window Function Lag() - No previous Value when 1 row.

  Hi, LAG function gives us value which was encountered in previous line.There is no lag value availa…

  info 58414

  3 replies

  8 years ago

  By: sgmunson

• SSIS : Group by in Aggregated task

  Dear all, I have created an aggregated task which is producing the below data: CIA_ContainerId…

  river1

  18 replies

  8 years ago

  By: sgmunson

• Get the year and Qtr

  Ia am trying to get the year and Qtr from my date column which has values like- YYYY-MM (2017-02). …

  Papil

  22 replies

  8 years ago

  By: ScottPletcher