SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• How create a report based on column value change

  I have been asked to create a report based on when a column gets updated with the row and date it w…

  smoham22

  6 replies

  5 years, 4 months ago

  By: aaron.reese

• Find percentage of column

  Hi, I'm trying to find the percentage of a column but I'm not sure how to get the percentage correc…

  smattiko83

  3 replies

  5 years, 4 months ago

  By: pietlinden

• query CTE

  Hi, I have a table with 2 fields DocumentID and ArrivedDate. I am able to elaborate only 2 document…

  AntonyO

  14 replies

  5 years, 4 months ago

  By: Jeff Moden

• Sql Statement to display multiple true statement

  I have a sql statement that checks for certain special characters in a string and returns that. SEL…

  bionicsamir

  3 replies

  5 years, 4 months ago

  By: bionicsamir

• Temp table and table variable

  DECLARE @command varchar(1000) SELECT @command = 'USE ? SELECT dbschemas.[name] as 'Schema', dbtabl…

  mtz676

  2 replies

  5 years, 4 months ago

  By: Jeff Moden

• Column total using group by rollup

  I'm trying to total all the rows but one in a column using group by rollup in SQL Server. I'm getti…

  smattiko83

  11 replies

  5 years, 4 months ago

  By: smattiko83

• SQL Job that takes too long

  Hi, I am trying to send notifications to myself when a articular job that longer than 8 minutes to …

  PSB

  2 replies

  5 years, 4 months ago

  By: John Mitchell-245523

• Controlling Text Box Overflow

  I have a situation in which I have a text box in a report that I do not want to increase in height …

  RonM_JIS

  2 replies

  5 years, 4 months ago

  By: Jeffrey Williams

• Oracle to Sql

  I've been tasked to convert Oracle reports .rdf files to SSRS and I am curious if anyone has used a…

  cbrammer1219

  4 replies

  5 years, 4 months ago

  By: cbrammer1219

• Integration service and OLE DB provider Microsoft.ace.oledb.16.0 is not register

  Hi to all. I'm in trouble. I want to create an Integration Service project in Visual Studio 2017. I…

  matteo.veggiari

  1 replies

  5 years, 5 months ago

  By: frederico_fonseca

• String or Binary Truncation Error Strange Behavior

  Ok... this is driving me absolutely nuts! We have a insert query that is throwing a "string or bina…

  DB_Newbie2007

  12 replies

  5 years, 5 months ago

  By: frederico_fonseca

• IDENTITY and INSERT INTO... SELECT... ORDER BY

  Greetings All; Per MS KB273586 (which is no longer available), it used to be the case that one coul…

  cs_troyk

  4 replies

  5 years, 5 months ago

  By: cs_troyk

• Generate a Restore Statement Based upon the Backup File.

  Team, Can somebody please help with a Logic to Generate a Restore Statement based upon the Backup F…

  satnam.singh 44358

  1 replies

  5 years, 5 months ago

  By: Ken McKelvey

• update by quantity

  I'm writing an update statement that uses a quantity column to determine how many rows get updated.…

  askcoffman

  16 replies

  5 years, 5 months ago

  By: michael.cole 47030

• bcp format file and import fixed width text file

  I'm trying to set up a format file using bcp but I'm unsure of how to set it up. I used "bcp de_ide…

  smattiko83

  30 replies

  5 years, 5 months ago

  By: smattiko83