SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• stored procedure return values

  Hello Friends, I had posted a question earlier, but I don't think I articulated the problem correct…

  Data Rat

  5 replies

  5 years, 5 months ago

  By: Jeff Moden

• Issue with case statement

  i have a table A where the data looks like ID        Name      Phone            CODE 15674     AUSN…

  mcfarlandparkway

  4 replies

  5 years, 5 months ago

  By: RC

• Get top 5 records from Table A and for each, one result from Table B

  delete pleaseeeee This topic was modified 5 years, 5 months ago by rhapsap.

  rhapsap

  2 replies

  5 years, 5 months ago

  By: rhapsap

• Need to calculate [ExpirationDate] based on next record's [EffectiveDate]-1

  Hi All, I have the following simple query, and the resulting table: SELECT [Client_ID], …

  Hell-1934

  1 replies

  5 years, 5 months ago

  By: pietlinden

• Top 10, count Distinct of multiple columns in select statement

  Hi All select TOP 10 SiteId, SiteName, count (distinct (JobID,Grade)) from SiteInfo I need to count…

  shagil.a.gopinath

  2 replies

  5 years, 5 months ago

  By: Steve Collins

• The communication with the client application

  Hi friends! What is the best way to notify an application from SQL Server?  For example, when a row…

  Peter Shilovich

  2 replies

  5 years, 5 months ago

  By: Peter Shilovich

• generate insert statement with data from table

  Hi all, My need is to generate insert statement with data from table (using existing data from that…

  marchello

  2 replies

  5 years, 5 months ago

  By: marchello

• ????????Q?:1925465786??????Leeds??????????????????????????????????The University

  The University of Leeds

  qweasdzxsc03

  1 replies

  5 years, 5 months ago

  By: qweasdzxsc03

• insert random value from predefined list of possible values

  Hi all, My need is to insert random value from predefined list of possible values. It's data obfusc…

  marchello

  8 replies

  5 years, 5 months ago

  By: marchello

• Updating data with recording old values - thought process

  Client has a projections table that sales reps can update on their own.  They want to record any ch…

  ucltech

  6 replies

  5 years, 5 months ago

  By: Phil Parkin

• Identity column as Primary Key - good or bad?

  I'm building a web app to maintain some data, which is mostly flat but will benefit from having som…

  edwardwill

  35 replies

  5 years, 5 months ago

  By: Jeff Moden

• Need help with sql query in slitting and putting it in table

  Hello All, I have the following table Table A ID DocNumber InternalDocnumber date DocType…

  anjaliagarwal5

  6 replies

  5 years, 5 months ago

  By: pietlinden

• convert dynamic rows to columns in sql server

  Hi i have one doubt in sql server how to convert rows to columns dynamically in sql server CREATE T…

  asrinu13

  5 replies

  5 years, 5 months ago

  By: Phil Parkin

• count by week by start/end date

  I'm trying to show a count by week but I am unsure of how to find dates between years? How do I sho…

  smattiko83

  5 replies

  5 years, 5 months ago

  By: pietlinden

• Automating a daily download from GitHub

  Does anyone have any experience automating a daily download of csv files from a HitHub repo?  Any g…

  Lynn Pettis

  10 replies

  5 years, 5 months ago

  By: Phil Parkin