SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Open Query Column List

  Hi all, Please I need help on how to get all the columns using the below TSQL. The error is that th…

  eobiki10

  4 replies

  6 years, 2 months ago

  By: Thom A

• Pivot account date list to account start and end dates with missing dates

  I have this requirement to convert a list of account active dates to summarize the active start and…

  John Gundrum

  9 replies

  6 years, 2 months ago

  By: DesNorton

• How to split time into hourly slot using SQL (can use view,or stored proc or fun

  I have data in table which has start date, end date and duration. I want to show hourly time slot. …

  shilpa_288

  4 replies

  6 years, 2 months ago

  By: shilpa_288

• query with CTE

  Hello, I need help to write a query with CTE. I wanna write a query for TotalPrice of Last Sunday o…

  nooshin

  3 replies

  6 years, 2 months ago

  By: Jeff Moden

• Select Query Weirdness

  Hi, I've been given a spreadsheet containing a list of identity values that our marketing team need…

  five_ten_fiftyfold

  8 replies

  6 years, 2 months ago

  By: Jeff Moden

• Difference between SQL Server and SQL Database?

  SQL Server is a physical computer right?  Whereas SQL Database is software that runs on SQL Server …

  michael.leach2015

  6 replies

  6 years, 2 months ago

  By: michael.leach2015

• Delete and update locks on table when there is no row to delete/update

  I was looking to see how the lock will work in the delete and update commands, but I am a little co…

  ashkan sirous

  1 replies

  6 years, 2 months ago

  By: Sue_H

• CASE Statement

  I am a SQL novice. Our SQL expert is unavailable and I need to make some small changes to a stored …

  thunter 5669

  11 replies

  6 years, 2 months ago

  By: thunter 5669

• transfer data from one sql server to another

  Hi there, I am trying to transfer one table from our production server to the replication server th…

  JohnDoe564

  2 replies

  6 years, 2 months ago

  By: BrownCoat42

• Incorrect syntax near 'pvt' error

  I keep getting an error and when I click on the error, it brings me to @PropertyTable on the Proper…

  bobbydave

  6 replies

  6 years, 2 months ago

  By: rVadim

• Problem writing a query to handle dynamic field usage

  I have been presented with some source data and mapping tables where the source data is stored as :…

  cpage 92973

  7 replies

  6 years, 2 months ago

  By: cpage 92973

• Stored Procedure broken out into views

  So my end result, I want to use the dataset in Tableau. Right now, I have a stored procedure. DECLA…

  bobbydave

  2 replies

  6 years, 2 months ago

  By: HanShi

• Indexing for View Containing UNION

  Basic outline is that I wish to ensure uniqueness of data within a table where some of the data can…

  michael.cole 47030

  4 replies

  6 years, 2 months ago

  By: michael.cole 47030

• eroor in value datetime

  Hello , Can  you help me in this Error use tempdb ; declare @date datetime ='2019-01-31 00:00:00.00…

  abdalah.mehdoini

  3 replies

  6 years, 2 months ago

  By: Jonathan AC Roberts

• Need help to export result of my query (XML result) to disk

  Hello comunity, I need to export this result to filename on my disk, how can do that : I post above…

  luissantos

  1 replies

  6 years, 2 months ago

  By: Lynn Pettis