SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• query get 0 when month not exist in MSSQL

  I have table names 'payroll' in MSSQL with following data month , pay January , 1200 March , 1500 D…

  stino

  2 replies

  8 years, 7 months ago

  By: Y.B.

• Parsing string

  Hi All, I need help with sql to parsing string. Ex. ''XDX114A77400' or '1123AB00171' I live to pars…

  joemai

  4 replies

  8 years, 7 months ago

  By: joemai

• Truly cleaning sensitive LOB data

  I'm working for a client that has some unencrypted sensitive data stored in XML blobs (like social …

  SeanNerd

  3 replies

  8 years, 7 months ago

  By: Gail Shaw

• It may need to just be getting used whenever

  it may need to just be getting used whenever Alpha Force Testo[/url] signs of acid reflux didn't d…

  bellejacee

  4 replies

  8 years, 7 months ago

  By: bellejacee

• sql server - how do i get hierarchy of data from two different tables?

  Hi Guys, I have two tables structured like this: tblStructure ================= [VCode].....[Name] …

  imanalimi

  4 replies

  8 years, 7 months ago

  By: Jeff Moden

• Duplicate rows confusion

  Hello, I've this table that I pulled from sqlzoo. I loaded this data in my sql server 2016. name …

  Anil Paneru

  4 replies

  8 years, 7 months ago

  By: Anil Paneru

• Display Live clock event

  Hi Experts, I need to solve below two issues in my SQL query, 1.query should not show any duplicat…

  ShawnBryan

  3 replies

  8 years, 7 months ago

  By: Lynn Pettis

• lookup value for each row

  I have a table with currencies, and a table where each day the exchange rates for those currencies …

  marc.corbeel

  20 replies

  8 years, 7 months ago

  By: drew.allen

• How to get full name of the employer by getting rid of null values in between

  HI, I have a table name EmployeeNames ID, FirstName, MiddleName, LastName 1, Sam, NULL, NULL 2…

  SQL-Learner

  19 replies

  8 years, 7 months ago

  By: whenriksen

• DATEDIFF For Start and End Dates Columns

  HI I have the following Columns as below FrankStartDateFrankEndDateTrumpStratDate TrumpEnddate …

  Steve Dell

  2 replies

  8 years, 7 months ago

  By: Steve Dell

• Help: Truncate tables with same prefix

  I apologize for any short comings in advance as I am not all that familiar with SQL. I need to crea…

  mr_xtant

  14 replies

  8 years, 7 months ago

  By: Jeff Moden

• trying to insert data from one table to multiple tables row by row with derived columns. Somehow it's end up with infinite loop. and also throwing the message of

  trying to insert data from one table to multiple tables row by row with derived columns. Somehow it…

  bidba9

  2 replies

  8 years, 7 months ago

  By: Luis Cazares

• Connection to a sql server in an external network

  I have to connect to a sql server at the vendor who is in a different network. What are my options …

  Unniarcha

  6 replies

  8 years, 7 months ago

  By: mister.magoo

• Question on the Data Type Conversion chart

  found here: https://msdn.microsoft.com/en-us/library/ms191530.aspx I had assumed that, when the gri…

  dfalso

  1 replies

  8 years, 7 months ago

  By: mister.magoo

• Daily working Hours

  My table look like this, INSERT INTO dbo.test (`action_id`,`person_num`,`person_id`,`creation_dat…

  ShawnBryan

  5 replies

  8 years, 7 months ago

  By: ShawnBryan