SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• SQL Entity Partion

  Hi, When partitioning data from a table do I need to have a separate filegroup for each partition?&…

  mwamoreira

  1 replies

  7 years, 8 months ago

  By: BrainDonor

• Need to write query with conditioms

  update tab1.ut_prc with tab2.prcup of seqnum in which amtperact fall under.for example if you take …

  saptek9

  6 replies

  7 years, 8 months ago

  By: sgmunson

• Grouping Records by evaluating the next record...

  We have GPS data that we receive from several devices that we have.  When we receive the data …

  steve.groner

  3 replies

  7 years, 8 months ago

  By: ben.brugman

• Insert with dynamic SQL and Cursor for variable table/columns according to update list

  Hi!I have a bit of a problem for a while. I have updated tables in Database A. These tables gets up…

  coolasice24

  9 replies

  7 years, 8 months ago

  By: ben.brugman

• sql 2017 'sqllocaldb' is not recognized

  Hey there,  this issue 'killed' 🙁 my working time. Need a REAL solution for this issue. See p…

  fleur.loves

  1 replies

  7 years, 8 months ago

  By: frederico_fonseca

• Convert Varchar field

  I have a Varchar field with units in inches 🙁 that i need to convert to an integer (Unfortunately t…

  bpmosullivan

  41 replies

  7 years, 8 months ago

  By: TomThomson

• XML Query

  I have XML being passed into a stored procedure in the following format.  I'm struggling with …

  Mike01

  13 replies

  7 years, 8 months ago

  By: Mike01

• Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

  Can someone help me with loading the attached csv file database.The issue here is the CSV file has …

  kashyap4007

  26 replies

  7 years, 8 months ago

  By: Sergiy

• 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

  7 years, 8 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

  7 years, 8 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

  7 years, 8 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

  7 years, 8 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 passe…

  Snargables

  2 replies

  7 years, 8 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

  7 years, 8 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

  7 years, 9 months ago

  By: waxb18