Development – SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Row_Number, partion and order by

  Hi all I have the following SQL SELECT Account, LogDateTime, RowId, Cell, lag(LogDateTim…

  chris.stuart

  2 replies

  5 hours, 56 minutes ago

  By: Thom A

• Generate list of working day according to rule defined.

  I have table workingDates that has 3 columns wd:(type int ) This column has all working dates in in…

  pnpsql

  1 replies

  3 days, 19 hours ago

  By: ScottPletcher

• Issue with +LEFT(xx) if a value IS NULL

  Hi everyone I’m using the code below to take someone’s title, the first letter of their…

  j.clay 47557

  7 replies

  6 days, 4 hours ago

  By: j.clay 47557

• Insert to Clustered Index

  Hello, I have a stored procedure that consists of a relatively simple INSERT INTO SELECT, the table…

  Jim-S

  10 replies

  6 days, 9 hours ago

  By: Jim-S

• BULK insert from a csv/txt file

  I want to import from a csv file with a bulk insert. BULK INSERT ... FROM 'C:\....txt' WITH ( FIELD…

  sqlmak14

  2 replies

  1 week ago

  By: Steve Jones – SSC Editor

• Simplest way to (automatically) output query results to csv

  With so much on deadlines looming I’d prefer not to have to wrestle with SSIS and all the iss…

  Jay@Work

  13 replies

  1 week, 3 days ago

  By: rVadim

• Update trigger and concurrency issue

  I built a table – and the DBA added a mandated UPDATE trigger to automatically update standar…

  Seggerman-675349

  5 replies

  1 week, 3 days ago

  By: Thom A

• Using PIVOT

  I need to know how can I use PIVOT , my query SELECT A.HIS_STD_OID, B.HIM_SERIES_ID FROM …

  aliahad

  1 replies

  1 week, 5 days ago

  By: frederico_fonseca

• How to achive Oracle Rownum with Order by clause equalent in SQL server script

  Hi Everyone, I hope, you are doing good! I have a requirment to migrage all oracle open query into …

  manavairajan

  1 replies

  1 week, 6 days ago

  By: saravanatn

• Using LIKE breaks my openquery

  I have an LDAP query that runs perfectly. However, as soon as I introduce a LIKE into the WHERE cla…

  Jay@Work

  3 replies

  1 week, 6 days ago

  By: Sue_H

• Select column names and top 1 records along.

  This query retrieves column names and their data type along with the tables they’re in. SEL…

  keneangbu

  2 replies

  2 weeks ago

  By: ScottPletcher

• trying to add individuals to a variable call…

  Thanks to all that take the time to read or reply… I have this snippet of code and i want to …

  DHeath

  5 replies

  2 weeks, 4 days ago

  By: DHeath

• Replace 1st char in a string if not null

  I’m doing an active directory extract using t-sql and need to manipulate the mobile column to…

  Jay@Work

  2 replies

  2 weeks, 6 days ago

  By: Jay@Work

• Getting Powershell to shut up

  Hi, I’m hoping someone can help me with this, it’s very shonky but it’s what I…

  richard.gardner87

  2 replies

  3 weeks ago

  By: richard.gardner87

• Using SUM OVER without an Order by

  We capture the MPF at a header level and call it TOTAL_MPF.We  also capture Line Level MPF and…

  jeffshelix

  6 replies

  3 weeks, 5 days ago

  By: drew.allen