SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Question regarding cursor in tsql

  I am trying to find differences between a normal table and an audit table. Iam_audit: A_n &nb…

  sukichweet

  2 replies

  6 years ago

  By: x

• Help: SQL one row to many rows

  Folks,I could use some help,  I have a script that returns x number of jobs that were run. For…

  aobf

  1 replies

  6 years ago

  By: Luis Cazares

• Convert Negative values -2.56 to (2.56) in excel

  hi , I have a package right now which loads data from Table to a  .csv flatfile. When loa…

  komal145

  7 replies

  6 years ago

  By: MMartin1

• Sql Server Development

  Hi, I was wondering are there any free pdf Books that cover SQL Transact. Thank You !

  Data Rat

  3 replies

  6 years ago

  By: Joe Torre

• Using In-Memory Tables To Improve Performance

  Hi Everyone, I'm working on an ETL tool and I'm focusing on improving performance. What we're doing…

  John O'Connor

  4 replies

  6 years ago

  By: sgmunson

• SELECTing a hierachy

  I do not need the code to make the hierarchy. I have a table and want to know if there is a way to …

  Amy.G

  4 replies

  6 years ago

  By: Jeff Moden

• GDPR and Business Objects

  We have an old DWH with a lot of universes and reports.Some of the tables contain personal informat…

  christian 52014

  6 replies

  6 years ago

  By: Emperor100

• Generate a sequence number for corresponding numbers

  I have a requirement , where i need to create a look up table to generate a Sequence number for eac…

  komal145

  8 replies

  6 years ago

  By: jcelko212 32090

• Generate a unique number for a combination

  How do you generate unique number based on  a Loannumber , Date columns Example Declare @loa…

  komal145

  21 replies

  6 years ago

  By: ChrisM@Work

• Retreving phone numbers based on phone type

  i have a table where it has empid, phone type and phone number one employee has multiple phone numb…

  mcfarlandparkway

  11 replies

  6 years ago

  By: ChrisM@Work

• Trying to assign payment amounts for each consecutive month within a date range

  I have authorizations that have start and end dates and I need to calulate the monthly payment and …

  shel 29143

  5 replies

  6 years ago

  By: shel 29143

• Temporal Tables - Delete Conflict

  Well, I'm trying to figure out a way around another massive hole in a SQL Server feature.  I h…

  Mike Hotek

  2 replies

  6 years ago

  By: Eirikur Eiriksson

• Comparing Two Tables and Comparing Within Each Result

  Hi,  I've been stuck on this for a week now and was wondering if someone could help.  I'v…

  NKKN

  5 replies

  6 years ago

  By: sgmunson

• Converting varchar to float

  Hi, I get error 'Error converting data type varchar to float.' and I have a blind spot, I can't fig…

  WilburSmith

  7 replies

  6 years ago

  By: jcelko212 32090

• Identifying a specific record to remove at different rows for the same set of groupings of repeated data

  hi I have the following data DROP TABLE #TestHldgs CREATE TABLE #TestHldgs( [HoldingID] [float]…

  Weegee2017

  3 replies

  6 years ago

  By: sgmunson