Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Convert int field into date and format issue

  Hi All, I'm hoping to get your advice on this. I'm trying to take an int field, AccountingPeriod,&n…

  daniness

  14 replies

  7 years ago

  By: Jeff Moden

• Identifying field value corresponding to MAX of another field value

  Hey All, I'm hoping to get your expertise on this. I'm trying to populate a temp table as part of a…

  daniness

  10 replies

  7 years ago

  By: daniness

• Sorting by a column when the name is derived via a CASE statement

  Hi everyone I have created the following SQL statement which works fine. However, it would definite…

  j.clay 47557

  7 replies

  7 years ago

  By: Jonathan AC Roberts

• How to PIVOT various VAT breakdown options with Invoice Summary data

  Countries like Canada have certain consumption taxes to be applied, when selling products, e.g. GST…

  BOR15K

  6 replies

  7 years ago

  By: BOR15K

• Showing all records that appear more than once

  Hi everyoneI'm trying to write some SQL that will allow me to pull all records where the NUMBER col…

  j.clay 47557

  11 replies

  7 years ago

  By: ScottPletcher

• Options to assign a dynamic content to XMLNAMESPACES area

  I have a long running process, generating XML files with XML Namespaces, which are defined using WI…

  BOR15K

  2 replies

  7 years ago

  By: BOR15K

• My data-value parameter does not conform to the parameter SQL Server error is: 200 state 7

  I am attempting to get data from active directory Users and place them into a datatable in SQL Serv…

  bdkdavid

  2 replies

  7 years ago

  By: bdkdavid

• optimize sql stored proc for better performance

  Hello,I have this stored proc I am trying to determine if it can be optimized for better performanc…

  patil.yatish

  2 replies

  7 years ago

  By: Grant Fritchey

• SQL Query to split values

  Hi, I have below column with values and I want to split values into multiple column values Ex…

  dannyfirst80

  5 replies

  7 years ago

  By: Thom A

• Query Performance Improvement

  Hi All,I'm very new to PI and sorry if this is a silly question, but was wondering if I can reduce …

  thenewbee

  10 replies

  7 years ago

  By: Jeffrey Williams

• finding previous 12 months data, not including current month

  on the 10th of each month i run a report for the 12 month period, not including the month i am in.S…

  jeffshelix

  4 replies

  7 years ago

  By: Jeff Moden

• finding duplicates users

  Hi, I'm trying to get the 'leaver's date' of employees who have left our organisation. However, I c…

  osxman

  7 replies

  7 years ago

  By: osxman

• Format column as HHH:MM:SS instead of MMM DD YYYY HH:MM (AM/PM)

  Hi everyone, This problem seemingly does not have a clear solution. I am importing data from Excel …

  Raynard_SwanXI

  12 replies

  7 years ago

  By: frederico_fonseca

• Change Logs

  Assume a simple table such:Id (int)FirstName (nvarchar(50))LastName (nvarchar(50)) And a matching l…

  thelenj

  5 replies

  7 years ago

  By: thelenj

• Optimize Stored Procedure

  Hello,I have this stored proc I am trying to determine if it can be optimized for better performanc…

  bradley 60892

  2 replies

  7 years, 1 month ago

  By: Grant Fritchey