Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• SSRS Export to word - error: the rectangle is too complex to export to Word

  There is a report that has been in production for years but now is throwing an error when trying to…

  Kenean

  7 replies

  5 years, 10 months ago

  By: Phil Parkin

• Row_Number for grouping to find min and max values

  I have a dataset which I've added row_number to in order to separate out the basic set of data by r…

  tacy.highland

  19 replies

  5 years, 10 months ago

  By: tacy.highland

• Database Model for Feedback Module

  I wish to generate an online feedback system. Requirements are Admin can enter feedback questions …

  sivaay1223

  6 replies

  5 years, 10 months ago

  By: ScottPletcher

• EXECUTE sp_executesql

  Cordial Saludo. tengo el siguiente script DECLARE @SqlString NVARCHAR(500) DECLARE @ParmDefinition …

  elkinfortiz

  6 replies

  5 years, 10 months ago

  By: elkinfortiz

• Syntax error using openquery()

  Not quite sure what SQL is complaining about here so need some fresh eyes please. I'm trying to put…

  Jay@Work

  4 replies

  5 years, 10 months ago

  By: Jay@Work

• A cursor with the name already exists

  Hi, I have this code in a job that needs to run every 5 minutes. It works most of the time without …

  krypto69

  2 replies

  5 years, 10 months ago

  By: MVDBA (Mike Vessey)

• Table join question -- multiple records in one table

  This is an employment application database.  I have a foreign key table named Application_Locations…

  mjohnson 71479

  2 replies

  5 years, 10 months ago

  By: mjohnson 71479

• Determining if more CPU is needed

  We have a data import & processing process that often longer than expected, often delaying the …

  dan-572483

  2 replies

  5 years, 11 months ago

  By: muthukkumaran Kaliyamoorthy

• Extract Blocks of Number

  Hi, I'm trying to extract blocks of numbers from a column in SQL. I've been looking online for a wh…

  dramaqueen

  11 replies

  5 years, 11 months ago

  By: Jonathan AC Roberts

• Turn If statement into Case

  How can I convert this into a Case statement so that the query is not ran every time for each if st…

  GrassHopper

  8 replies

  5 years, 11 months ago

  By: Phil Parkin

• Multi select parameter does not work in WHERE clause

  Hello, I´m using a SyBase SQL Anywhere 17 Database. Then I want to create a sql server report servi…

  CopWorker

  7 replies

  5 years, 11 months ago

  By: CopWorker

• Openrowset error

  I ma using this command with openrowset on an excel file: SELECT F1, F2, F3, F4, F5, F6=cast(f6 as…

  GrassHopper

  2 replies

  5 years, 11 months ago

  By: GrassHopper

• repeating block of records

  I want to look for blocks of records repeating in a table.   pattern is unknown...to keep it s…

  scott.laird

  3 replies

  5 years, 11 months ago

  By: The Dixie Flatline

• 0 Rows Affected - Requires a value Returned

  Hi, I'm currently using Zabbix Monitoring and when connecting via ODBC, I'm executing the below com…

  Buddy84

  1 replies

  5 years, 11 months ago

  By: Phil Parkin

• SELECT processed before WHERE clause

  I have a SELECT CAST(Column to int) that has been working OK, on the assumption that the WHERE has …

  kuopaz

  7 replies

  5 years, 11 months ago

  By: kuopaz