Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Nested Joins - Having syntax and bounding issues

  Hello. My first post here and hope to get some help. It'll be obvious that I'm a newbie. I apolog…

  doasidont

  23 replies

  9 years, 6 months ago

  By: Lynn Pettis

• please fine tune this query

  f

  rajadadi

  4 replies

  9 years, 6 months ago

  By: Grant Fritchey

• Change Order of Week Names to Show Current Data First

  Hello. Pardon me, I'm new to both this forum and SQL. I need assistance with code that will allow m…

  clbishop

  3 replies

  9 years, 6 months ago

  By: J Livingston SQL

• Bulk Insert for text file with irregular terminators

  I have run into an issue with several clients when importing their files into tables. I can manual…

  John.F.Houck

  2 replies

  9 years, 6 months ago

  By: John.F.Houck

• Handling xml data and formatting into separate table

  I have xml data in table, here xml data looks mentioned below, And it’s taken from different table …

  s.ravisankar

  12 replies

  9 years, 6 months ago

  By: drew.allen

• Passing variables into SSIS config files

  Hello SSC friends, I have been tasked with creating a dynamic SSIS config file for several packages…

  Lord Slaagh

  5 replies

  9 years, 6 months ago

  By: Phil Parkin

• SSIS Performance Question - Child Packages

  I've stumbled into an unexpected situation. I'm observing significant performance differences depen…

  larry.andrews

  3 replies

  9 years, 6 months ago

  By: Phil Parkin

• Need help with shrink

  Hello experts, I'd like to setup a job that will take a log backup, and then shrink the log file fo…

  Feivel

  7 replies

  9 years, 6 months ago

  By: Hugo Kornelis

• Convert Value Returned by Row_Number() Function to Text Based on Relationship to Overall Result Set

  I'm using the SELECT below to pull a list of parts and rank them by the number of times that they h…

  david.holley

  1 replies

  9 years, 6 months ago

  By: Ed Wagner

• Using Subqueries as Calculated Fields

  I have a concept question on this code: SELECT cust_name, cust_state, (SELECT Count(*) …

  SQL 2016

  10 replies

  9 years, 7 months ago

  By: Sachin Nandanwar

• Spatial Data: finding the closest point to a geographical point. Populating a distance field in a table.

  I am using SS2014 and T-SQL. I have two tables. Both have latitude and longitude. I added a field…

  Tom Carnahan

  4 replies

  9 years, 7 months ago

  By: Tom Carnahan

• Non cursor based looping within a script.

  I have a script that I am trying hard not to use a cursor for. The script will insert values into a…

  Paul Giles-Randall

  4 replies

  9 years, 7 months ago

  By: Hugo Kornelis

• Combining two qureies to one

  Hi , I have two query and the explanation is we run the query pasted in file OpenRejectedReport.tx…

  mbavabohrude

  10 replies

  9 years, 7 months ago

  By: drew.allen

• Creating Combined Queries

  Hello Help forum, SELECT vend_id, prod_id, prod_price FROM products WHERE prod_price <=5 UNION S…

  SQL 2016

  9 replies

  9 years, 7 months ago

  By: Eirikur Eiriksson

• A GROUP BY rule

  Here is something that I read and I cant figure it out. (by the way this is my last post for awhil…

  SQL 2016

  4 replies

  9 years, 7 months ago

  By: SQL 2016