SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Any way to include SSIS execution messages in an alert?

  Hello experts, When I get an error with an SSIS package, I follow the manual process of right-click…

  webrunner

  5 replies

  7 years, 5 months ago

  By: richardmgreen1

• Wht is the best way to load 15 million rows into a table with a pk? There are known duplicates.

  Good morning, I have a table that needed a Primary key on the table id column (tableID int).  …

  WebTechie

  20 replies

  7 years, 5 months ago

  By: ScottPletcher

• Can anyone explain why this isn't populating the two desired columns?

  Hi,Please see the below query. When executing this query I find two derived columns [Candidate Firs…

  chocthree

  9 replies

  7 years, 5 months ago

  By: sgmunson

• CTE to returning WAC price

  Hello community, I have build  a CTE to calculate my WAC price like that: CREATE TABLE stock_t…

  luissantos

  5 replies

  7 years, 5 months ago

  By: luissantos

• How to get and use the value returned by SP to a INSERT INTO... SELECT... statement

  Hi, I am just new in SQL language and still studying it. I'm having hard time looking for answer on…

  Djrivers2002

  8 replies

  7 years, 5 months ago

  By: Djrivers2002

• Lookups on remote database

  SQL is not my primary language and I could use some insights into how to accomplish a task I need t…

  MothInTheMachine

  3 replies

  7 years, 5 months ago

  By: MothInTheMachine

• Same stored procedure 5 times vs 5 different procedures

  Hi, I have ONE report and it has 5 sections. I wrote a stored procedure and each report sectio…

  Naidu PK

  3 replies

  7 years, 5 months ago

  By: ScottPletcher

• YTD running balance including missing months

  Hi All,I am trying to get the  YTD Account Balances for a financial statement. There are accou…

  ddly_ann

  37 replies

  7 years, 5 months ago

  By: x

• Help on ROW_NUMBER

  I would need to make the column num1 have the value from column numa where the rent_…

  jezem

  5 replies

  7 years, 5 months ago

  By: sgmunson

• insert into: ignore identity column's value

  Hi,is there any Chance to get this working? CREATE TABLE [dbo].[Table_1]( [id] [int] IDENTITY(…

  rotcha99

  9 replies

  7 years, 5 months ago

  By: jcelko212 32090

• how to store percent symbol while creating a new table,which datatype will store percent symbol.

  I am importing data from excel and there is a column which contains % symbol for example 15%,I want…

  TAJ@2018

  3 replies

  7 years, 5 months ago

  By: sgmunson

• Value violated integrity constraints on data import

  I am trying to import some data from an excel spreadsheet into a SQL table but am getting some erro…

  ACECORP

  4 replies

  7 years, 5 months ago

  By: RonKyle

• Special output from xml data with XQuery

  Hello, Can you help me with this?I have an xml data and I would like a special output with an XQuer…

  salliven

  3 replies

  7 years, 5 months ago

  By: Eirikur Eiriksson

• find char in column

  hi,column containing alphanumeric data. i won't data from column having first five digit is char. P…

  santoshghogare2008

  3 replies

  7 years, 5 months ago

  By: SGT_squeequal

• Need an extended event trace definition for capturing lock info

  Hi All, Can someone help in creating an extended event  to lock information of the currently …

  vsamantha35

  1 replies

  7 years, 5 months ago

  By: Jack Corbett