Development – SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• 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

  0 replies

  2 hours, 34 minutes ago

  By: pnpsql

• 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

  2 days, 3 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

  2 days, 8 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

  2 days, 23 hours 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

  6 days, 16 hours 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

  6 days, 17 hours 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, 1 day 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, 2 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, 2 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

  1 week, 3 days 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 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, 2 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

  2 weeks, 3 days 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 ago

  By: drew.allen

• CTE Group By not grouping results correctly

  I have the following CTE that is doing a SUM on the field MERCHANDISE_AMT, seperately from 2 differ…

  kdrymer

  18 replies

  3 weeks, 2 days ago

  By: Lynn Pettis