Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Single Query Instead of a Cursor

  Is it possible to rewrite this routine to be a single query, instead of a cursor.  We take a daily …

  AMCity

  2 replies

  4 years, 2 months ago

  By: ScottPletcher

• Microsoft.ACE.OLEDB.16.0 Provider Is Not Registered

  I am trying to import an Excel file (*.xlsx) into a SQL Server table using both SSIS and the "Impor…

  AMCity

  15 replies

  4 years, 2 months ago

  By: Phil Parkin

• Get double records returned from SELECT because I failed to save the PK.

  I have two tables. A lookup table that has a PK and various columns. Looks something like this: tbl…

  tim8w

  7 replies

  4 years, 3 months ago

  By: Jeffrey Williams

• Trying to understand percent sign next to field name

  I have a simple query where I needed to see if a qty had decimal places. I was instructed to use fi…

  jcobb 20350

  2 replies

  4 years, 3 months ago

  By: jcobb 20350

• sp_getschemalock long duration on linked server query

  I am having an issue in which sp_getschemalock is running with a duration of >= 800ms any time I…

  kevinhackney

  1 replies

  4 years, 3 months ago

  By: kevinhackney

• SQL SUM and divide linked tables

  I have the following tables: create table Cars ( CarID int, CarType varchar(50), PlateNo varchar(20…

  milo1981

  4 replies

  4 years, 3 months ago

  By: milo1981

• Send alert whenever a Field data type value is about to reach its maximum limit

  How to setup a monitoring where it throw an alert whenever a field data type value is about to reac…

  Rani

  4 replies

  4 years, 3 months ago

  By: ScottPletcher

• Query to Get Differences in Table Sizes

  Dear Group: We get a daily push from other systems into our SQL Server for us to do reporting again…

  AMCity

  2 replies

  4 years, 3 months ago

  By: Jeff Moden

• Between dates SQL help needed

  Hi, I required duplicate values in the below table For e.g  staff date 10192 first record To date i…

  mageshl79

  2 replies

  4 years, 4 months ago

  By: Ken McKelvey

• Conditional where clause

  Hi , I wrote a stored proc where I need to evaluate a bit flag and if true append "NOT IN" clause. …

  thbaig

  4 replies

  4 years, 4 months ago

  By: ScottPletcher

• BCP Error : A valid table name is required for in, out, or format options.

  Hi, I wanted to do insert data from file into table without SSIS using select query instead of tabl…

  Samit Shah

  10 replies

  4 years, 4 months ago

  By: x

• Query select.

  Hi, I have a sample data and table as: Field0Field1Field2Field3Field4Field5 1000Text1Text2T…

  Dee Dee-422077

  4 replies

  4 years, 4 months ago

  By: Phil Parkin

• usage of BCP and BULK INSERT

  as I'm not clear how to use bcp and bulk insert in the following cases, could you please give me an…

  892717952

  1 replies

  4 years, 5 months ago

  By: Ant-Green

• how checksum works?

  Could you please me how checksum work in the SQL statement ? below is an example. SELECT * FROM Ta…

  892717952

  7 replies

  4 years, 5 months ago

  By: 892717952

• Top 1 makes very fast query into very slow query

  I have a very simple query: SELECT AkcesAutoID FROM ( SELECT P.AkcesAutoID, A.AkcesitPred, A.…

  pdanes

  22 replies

  4 years, 5 months ago

  By: The Dixie Flatline