Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• SQL VIEW works on its own but not when combined

  Hi there, I have around 12 views and that works perfect if I execute them individually but when I c…

  thenewbee

  20 replies

  6 years, 10 months ago

  By: thenewbee

• Update trigger on column

  Hi, I am experimenting with triggers on SQL 2014. When the column Processed is updated I want to up…

  osxman

  2 replies

  6 years, 10 months ago

  By: osxman

• Using a case statement to compare to a paremeter.

  Everything worked great until i added this snippet. I want a column that tells me what "ID" matched…

  jeffshelix

  2 replies

  6 years, 10 months ago

  By: ScottPletcher

• How do i get around this "parameter has already been defined" error?

  My parameter can be a combination of formats and it can be in two different columns . . dashed/no d…

  jeffshelix

  3 replies

  6 years, 10 months ago

  By: Thom A

• Confused on parameter in a Where clause

  i am using the below  code: I tried using PD_ID IN (@Part) but SSRS still bombs. @Part can be multi…

  jeffshelix

  1 replies

  6 years, 10 months ago

  By: jeffshelix

• How do I parameterize my query?

  Hi, I'm using SSIS ScriptTask for file transferring purposes and inside of the code I have a little…

  svojnovic 66304

  1 replies

  6 years, 10 months ago

  By: Chris Harshman

• Scalar-valued Function Alternative

  We have a scalar-valued function that returns a product based on a series of criteria passed to it …

  RonMexico

  1 replies

  6 years, 10 months ago

  By: ScottPletcher

• Using Cursor in DELETE statement

  I have a need to use a SQL Cursor in order to delete data from a table, one row at a time (to preve…

  kdrymer

  11 replies

  6 years, 10 months ago

  By: Luis Cazares

• Row_Number, partion and order by

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

  chris.stuart

  2 replies

  6 years, 10 months 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

  6 years, 10 months 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 firstname, …

  j.clay 47557

  7 replies

  6 years, 10 months 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 years, 10 months 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 ( FIEL…

  sqlmak14

  2 replies

  6 years, 10 months 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 issues I …

  Jay@Work

  13 replies

  6 years, 10 months ago

  By: rVadim

• Update trigger and concurrency issue

  I built a table - and the DBA added a mandated UPDATE trigger to automatically update standard audi…

  Seggerman-675349

  5 replies

  6 years, 10 months ago

  By: Thom A