SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Help with Pivoting Table

  Hi all,     This topic was modified 1 year, 9 months ago by  carlton 84646. …

  carlton 84646

  15 replies

  1 year, 9 months ago

  By: carlton 84646

• SQL blocking caused by running ALTER VIEW script

  Hello experts, One of our developers tried to alter a view and reported to me that it was taking a …

  webrunner

  3 replies

  1 year, 9 months ago

  By: webrunner

• Find specific string in column and retrieve text that follows it

  I have a table contains 2 fields , objid and COMMENT as below: objid  | COMMENT 1  |  CHG_ASS_TI…

  fafful

  1 replies

  1 year, 9 months ago

  By: frederico_fonseca

• Best way to ETL on large tablle with columnstore index

  I have a table with 489M rows and growing. The reason we had to add columnstore index was because i…

  SQL_Surfer

  4 replies

  1 year, 9 months ago

  By: frederico_fonseca

• Email using msdb..sp_send_dbmail

  Hello,   I have a data export process using msdb..sp_send_dbmail.  Most fields come out to th…

  rjjh78

  1 replies

  1 year, 9 months ago

  By: rjjh78

• How to download from a dynamic link using SSIS?

  Hi everyone, So I have a ssis package in which I download a excel file and import the contents of t…

  Jobs90312

  1 replies

  1 year, 9 months ago

  By: Jobs90312

• AFTER TRIGGER QUESTION - How To filter Non Real Updates

  NEERMIND I just figured it out.     This topic was modified 1 year, 9 months ago…

  YSLGuru

  13 replies

  1 year, 9 months ago

  By: YSLGuru

• Fetching data from WEB API using SSIS

  Hi everyone, I am using SSIS script component to fetch and store data in to my sql tables from web …

  Jobs90312

  3 replies

  1 year, 9 months ago

  By: frederico_fonseca

• Is it possible to SUM on two different ranges in one SELECT query?

  Hello All and apologies for a silly question. I wonder if there is a better way to SUM values for t…

  BOR15K

  4 replies

  1 year, 9 months ago

  By: BOR15K

• How can convert hex value to decimal in sql server 2012

  How can convert hex value to decimal in sql server 2012

  kailashIndia

  8 replies

  1 year, 9 months ago

  By: Jeff Moden

• Need to append 2 columns

  Hi. Sorry for my original post not being clear. I think I am providing everything needed and I am c…

  jpgdrive

  1 replies

  1 year, 10 months ago

  By: Emperor100

• Islands (no gaps) - Problem solved but could this be done better?

  I've obfuscated my data, but this is legitimately the way the data in my table is distributed.  A …

  SoCal_DBD

  5 replies

  1 year, 10 months ago

  By: Emperor100

• Issue Extracting 2nd Level Node Data from JSON File

  Hi all, I'm venturing into the world of JSON and am currently trying to extract data out of and int…

  Exacto

  2 replies

  1 year, 10 months ago

  By: Exacto

• How to remove special chars?

  Hi everyone, So I have a xml file from which I am trying to import data into my sql tables. I notic…

  Jobs90312

  3 replies

  1 year, 10 months ago

  By: Johan Bijnens

• Need to add columns to table from lookup to 2 other tables

  Hi there. Thanks for code from my previous post and so many good working options. Now I want to add…

  jpgdrive

  4 replies

  1 year, 10 months ago

  By: jpgdrive