SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• A better way than multiple subqueries?

  I have a table that contains a single record for each of the (several thousand) devices we manage, …

  Mark Harley

  10 replies

  8 years ago

  By: ScottPletcher

• Need to run Pacakge on 10th of every month

  hi,I have a requirement to run the package only on 10th of every month , but 10th should not fall o…

  komal145

  6 replies

  8 years ago

  By: Phil Parkin

• connecting two microsoft sql server management studio in lan

  hi everyone, i try to connect two microsoft sql server management studio 2016(on Laptop) in LA…

  santoshghogare2008

  3 replies

  8 years ago

  By: Steve Jones - SSC Editor

• Previous one year and previous two years in sql

  report_Begin_date = 1/1/2017 report_End_date = 9/30/2017 Based on the begin and end date, I want pr…

  soldout6000

  4 replies

  8 years ago

  By: Lynn Pettis

• Select By Date Groups

  Hi I came across this question the other day and I didn't know the correct approach. Each product h…

  ringovski

  5 replies

  8 years, 1 months ago

  By: Lynn Pettis

• Looping through 65 millions of combinations: Excel or SQL or something else?

  Hello, I have to count the number of persons in a company according to multiple dimensions / f…

  allard.julien.70

  4 replies

  8 years, 1 months ago

  By: Luis Cazares

• AVG days between max and second last date

  Hi I am trying to work out a script to return the average number of days between the most recent da…

  ringovski

  5 replies

  8 years, 1 months ago

  By: saravanatn

• A Column Stuff() Alternative SubQuery

  I used Stuff() to combine the rows for ModifyName after unpivoting Charity & Super and placing …

  ackrite55

  5 replies

  8 years, 1 months ago

  By: Eirikur Eiriksson

• Comparing two columns of nvarchar data that is identical col1=col2 comes back as false not true?

  I have a table of data that is comparing employee job titles. This data comes from an external syst…

  Maxer

  3 replies

  8 years, 1 months ago

  By: Maxer

• Storing multiple variations of the same data?

  Can anyone weigh in on why you would want to store multiple variations of the same data?  In a…

  Kevlarmpowered

  16 replies

  8 years, 1 months ago

  By: Jeff Moden

• Is there a maximum number of joins allowed in SQL 2016?

  I have reports that are between 6 and 100 User DefinedFunctions joined together. When I have the c…

  GBimberg

  22 replies

  8 years, 1 months ago

  By: Lynn Pettis

• Connecting the DB LIBRARY (SQLDB.H) to sql server 2016(64 BIT)

  We are having an application(VC++ windows service) ,which connects to SQL server through DB-Library…

  r_d_d_06

  1 replies

  8 years, 1 months ago

  By: sgmunson

• In what twisted SQL world will a JOIN result in more records than a LEFT JOIN

  I have never seen this before and it goes against everything that I know about SQL data sets.  …

  aaron.reese

  20 replies

  8 years, 1 months ago

  By: Jeff Moden

• Export data in XML to import into Word

  Hi Folks, I am building a one-click application to export information from SQL Server 2016 in XML f…

  kevaburg

  23 replies

  8 years, 1 months ago

  By: kevaburg

• how to select data from xmldata

  Hi all, my front end appliction store the data in xml data type but we select the data in query.my …

  polo.csit

  2 replies

  8 years, 1 months ago

  By: Eirikur Eiriksson