Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Run-time error '-2147467259 (80004005)': [Microsoft][ODBC SQL Server Driver]Invalid use of default parameter

  I have code written in vba that inserts data, via Excel, into SQL-Server.  So far everything w…

  leavesandmusic

  3 replies

  8 years ago

  By: leavesandmusic

• Restore Database from folder

  I want to restore databases residing in folder say "D:\Backups\". This folder contains many set of …

  khushbu

  6 replies

  8 years ago

  By: khushbu

• Dynamic Columns as parameter in where clause

  Hi All, I have query which has 20 columns along with alias names for the column. The plan is to hav…

  alladiz

  13 replies

  8 years ago

  By: Thom A

• Query with Where clause + 3 OR clauses not working

  after 40 minutes, none of the three conditions were returned in my results  . . . and i had to…

  jeffshelix

  11 replies

  8 years ago

  By: Matt Miller (4)

• Execute Process Task

  Hi,I have SQL Server 2014 running on a Windows Server 2012.Until now, when I needed to post a file …

  f_matthews

  3 replies

  8 years ago

  By: f_matthews

• SQL to Excel : Using a SQL Table with Report Columns

  This is a SQL to Excel question.  We have a new SQL table with report columns and the position…

  Charles_P

  6 replies

  8 years ago

  By: Charles_P

• Pivot Row to Columns

  I have a table "tblPerson" that only has three columns hder, hderOrder  and key. The hder…

  Charles_P

  2 replies

  8 years ago

  By: Jeff Moden

• SELECT all negative values, that have a positive value

  Hello,I need to identify in SQL server table all entries with a negative value, that have a positiv…

  adiedler

  18 replies

  8 years ago

  By: ScottPletcher

• Row Over Partition

  Row Over partition escapes me. I wrote this: Select  [COMPOSITE_PART] ,[CREATED_DATE] ,HTS_NU…

  jeffshelix

  3 replies

  8 years ago

  By: Gail Shaw

• Detecting change week over week in SQL table

  Hello everybody, trying to figure what is the best way to figure out change between snapshots of pr…

  vecerda

  15 replies

  8 years ago

  By: DesNorton

• Interesting DimDate population task

  Hey Guys, Happy New Year.  I have a very interesting DimDate population request. I w…

  sqlislife

  2 replies

  8 years ago

  By: TheSQLGuru

• Selecting records where column contains specific integer in specific position

  Hi All, Can anyone please advise on how to go about returning records where an int dataty…

  daniness

  4 replies

  8 years ago

  By: Luis Cazares

• Convert from datetime to varchar to int

  Hi All, So I've been working on an SSIS package and part of it involves pulling data from a table's…

  daniness

  8 replies

  8 years ago

  By: daniness

• Issue with ROW OVER partition

  I was able to get this far from other posts in this forum, but keep getting error . . . invalid col…

  jeffshelix

  5 replies

  8 years ago

  By: drew.allen

• Wrong regional settings (decimal point)

  I'm not sure how this happened, but I'm no longer able to use a decimal point on SSMS. Instead, I n…

  Luis Cazares

  2 replies

  8 years ago

  By: Luis Cazares