SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SMALLDATETIME question

  Hi, I'm using a time series table with a SMALLDATETIME field.The table stores sensors' data every 1…

  PiMané

  5 replies

  6 years, 11 months ago

  By: PiMané

• Suspected bad data in table

  HI, I think I have bad data getting into one of my tables. I have searched and found some scrub/ch…

  krypto69

  2 replies

  6 years, 11 months ago

  By: Greg Goss

• Get Ip Address of Servers on network and Check if services are running

  I have ADSI Linked Server created on Server , I am able to get computer names from using TSQL, How …

  mandavli

  3 replies

  6 years, 11 months ago

  By: Sue_H

• Syntax error

  hi ..Can anyone tell me what is the error here. I tried closing the table and adding but it still g…

  komal145

  4 replies

  6 years, 11 months ago

  By: Luis Cazares

• Joining two lists

  I have a list of Store Locations and an Inventory List. Example below Store ListStore 1Store 2Store…

  bpaul 90357

  1 replies

  6 years, 11 months ago

  By: debasis.yours

• SSIS Data Profiling task The variable "User::Results" was not found in the Variables collection. The variable might not exist in the correct scope.

  Hi folks I'm new to SSIS so apologies for the newbie question. I've been following this guide - htt…

  raf 78133

  5 replies

  6 years, 11 months ago

  By: clicky

• Uploading Excel File data into SQL database via a website

  I am using php to develop my website and I need to be able to browse for and upload an Excel sheet.…

  sarahdoll1112

  2 replies

  6 years, 11 months ago

  By: sarahdoll1112

• get missing dates differencedays and fill previous dates data in sql server

  How to fill missing dates related data with previous date related data and get days differnce b/w m…

  baladevu

  1 replies

  6 years, 11 months ago

  By: Kingston Dhasian

• Sql Query

  SQL Server 2008 My Table: InstructionID CompanyCode ProductType (F/I/P/C/…) Amount Output : I…

  sajjadkaswani 43055

  4 replies

  6 years, 11 months ago

  By: Kingston Dhasian

• Column dependencies

  Hello,I have a users tables and i need to delete all the users that created before 2016 (i have cre…

  89netanel

  2 replies

  6 years, 11 months ago

  By: 89netanel

• week start date - week end date for a month

  I have daily dates for a month with number of appointments made per day.Table: DailyNumOfAppointmen…

  vizagboy

  8 replies

  6 years, 11 months ago

  By: jcelko212 32090

• How to use 'between' in CASE statement?

  Hi Friends, I am trying to wirte a filter condition in WHERE clauselike CASE WHEN GETDATE() = …

  Charmer

  19 replies

  6 years, 11 months ago

  By: Nate the DBA

• SSMS 2016 13.0.1601.5 Update Not Complete

  Ok. Every time I open my SSMS 2016, the update is returning the following. Obviously I ran the up…

  kDBAjan

  6 replies

  6 years, 11 months ago

  By: kDBAjan

• How to convert string to "data type" ?

  Hello everybody, First of all sorry for my English 😉 Here is my problem.In a table I've :&n…

  jeremie 98561

  15 replies

  6 years, 11 months ago

  By: ScottPletcher

• remove the characters and need to show only Numbers

  Hi Sir, I need one help CREATE TABLE TEMP(Name NVARCHAR(200)) INSERT INTO TEMP VALUES ('Abc Bbc (81…

  kiran.rajenimbalkar

  6 replies

  6 years, 11 months ago

  By: Jason A. Long