SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• i need to write stored proc following logic please help me the code.

  i need to write stored proc following logic please help me the code.i need to get distinct prodid f…

  saptek9

  5 replies

  7 years, 9 months ago

  By: jcelko212 32090

• Need to modify the Update statement to include two new tables instead of one table

  Currently, in existing system i do have following update statement: Update ProdStgset unit_cost=cas…

  saptek9

  5 replies

  7 years, 9 months ago

  By: Jeff Moden

• Best practice question on using a primary key field opposed to using a foreign key field

  Hi,Let's keep this simple (for my sake) and say we have two tables. Table Employee contains:e.Emplo…

  chocthree

  5 replies

  7 years, 9 months ago

  By: jcelko212 32090

• In Case statement i need to pass subquery. what's the bestway to do it.

  In Case statement i need to pass subquery. what's the bestway to do it. Can i declare it before do …

  saptek9

  2 replies

  7 years, 9 months ago

  By: Thom A

• ADDING FIELDS WITH A SELECT STATEMENT

  Can someone kindly help me with the query below: SELECT 1 AS ID, '1    Field, COALES…

  sahoong

  13 replies

  7 years, 9 months ago

  By: drew.allen

• Different behavior between "alter table drop column if exist" (new syntax) and the legacy one "if exists() alter table drop column " : is this a bug?

  HiI have notice something weird with the new syntax with a "drop if exist"It looks like the new syn…

  Nkl

  10 replies

  7 years, 9 months ago

  By: Nkl

• Hierarchical AND/OR Path Sets

  I am THIS [---] close to figuring out the last step for an ETL project moving data from an old appl…

  RBA

  4 replies

  7 years, 9 months ago

  By: RBA

• SQL Server PIVOT

  How do i pivot on this Table. I want the downer table to look like the one above, with the entries …

  malehakim

  3 replies

  7 years, 9 months ago

  By: drew.allen

• Update failing from CSV if data not in table

  First post here guys so sorry if Im in the wrong place for this.  Its been the bain of my life…

  pauld 57577

  7 replies

  7 years, 9 months ago

  By: SGT_squeequal

• Joining tables

  Hi, I am trying to build sql statement, but got struck. Any inputs please? Table A Tab…

  Edberg Steph

  7 replies

  7 years, 9 months ago

  By: Edberg Steph

• Join on next available non null value

  Hi folks, I have costs that I need to convert into a different currency based on the currency at th…

  Y.B.

  3 replies

  7 years, 9 months ago

  By: jcelko212 32090

• How to merge columns of two different tables into one table ?

  DECLARE @String VaRCHAR(100) = 'Column1|Column2|Column3'DECLARE @StringColumns VaRCHAR(100) = 'EmpI…

  dave.chintan.m

  2 replies

  7 years, 9 months ago

  By: dave.chintan.m

• Creating table on a fly with date + time

  I am very new to SSIS and I am just trying to understand if there is a way to create multiple stagi…

  NewBornDBA2017

  1 replies

  7 years, 9 months ago

  By: Phil Parkin

• SQL stored procedure call error - The index 1 is out of range

  New to SQL and trying to insert 3 fields into an SQL table using a stored procedure call in groovy …

  harbinger910

  3 replies

  7 years, 9 months ago

  By: harbinger910

• SSMS and SOS, difference in execution times

  Came a cross a bit of an oddity, execution times  on the same system differ when run in SSMS a…

  Eirikur Eiriksson

  12 replies

  7 years, 9 months ago

  By: Jeff Moden