SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• How do I use IFF statement in the WHERE

  Hi, I have this table CREATE TABLE Test ( FirstName    VARCHAR(50) ,LastName&nb…

  sirkinghorse

  4 replies

  7 years ago

  By: sirkinghorse

• datawarehouse questions

  We’re going to build out a data warehouse. My boss has been researching for a month or so and passe…

  Snargables

  2 replies

  7 years ago

  By: xsevensinzx

• Row-by-row insert with error handling -- Stored Procedures vs. SSIS

  Hello, I have dynamic inserts and update statements that are created based on a select from sys.col…

  aaron.beer

  6 replies

  7 years ago

  By: Sergiy

• Proc Fails when run in SSIS but runs fine in SSMS

  Hi All,  I have the Stored procedure below which iterates through a table to decrypt RSA encry…

  waxb18

  3 replies

  7 years ago

  By: waxb18

• 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 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 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 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 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 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 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 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 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 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 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 ago

  By: jcelko212 32090