SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• How to capture and log custom error message after RAISERROR()

  SQL server makes it simple to capture error numbers <50000 using ERROR_NUMBER(), ERROR_MESSAGE()…

  DavidL

  3 replies

  6 years, 3 months ago

  By: Lynn Pettis

• Convert all varchars in all tables to nvarchars

  Hello Experts,I have a requirement where I need to convert all varchar datatypes in all tables of a…

  dallas13

  6 replies

  6 years, 3 months ago

  By: dallas13

• Need to modify the Update statement to include combination two new fields instead of one field.i want to write in better way in performance wise.

  Need to modify the Update statement to include combination two new fields instead of one field: Cur…

  saptek9

  10 replies

  6 years, 3 months ago

  By: sgmunson

• 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

  6 years, 3 months 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 pas…

  Snargables

  2 replies

  6 years, 3 months 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

  6 years, 3 months 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

  6 years, 3 months 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 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

  6 years, 3 months ago

  By: drew.allen