SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Problems with date formats

  I am creating a User Defined Function in which I pass in a character string representing a date and…

  AmberArmy

  6 replies

  4 years, 12 months ago

  By: Carmon28

• stored procedure update

  There is a stored procedure that updates some columns. I want the following: if the column value al…

  coolchaitu

  2 replies

  5 years ago

  By: ScottPletcher

• SQL query on existing query results

  Hi there I have a query result (sub-query) and want to refine it more with another query. I'm tryin…

  Calvin

  4 replies

  5 years ago

  By: Calvin

• PL/SQL to T-SQL Code Error

  Hi Community, Before I ask this question, I want to let you know that I followed the advice @Phil P…

  carlton 84646

  7 replies

  5 years ago

  By: carlton 84646

• MERGE Not Providing Results from with Query

  Hi, I have posted a similar question which has been resolved. However, this follow on question is i…

  carlton 84646

  8 replies

  5 years ago

  By: carlton 84646

• Conversion failed when converting date and/or time from character string

  Hi Community, I have created the following table CREATE TABLE HMCTS.MDM_DEV.dimDate ( DATE_KEY DA…

  carlton 84646

  7 replies

  5 years ago

  By: carlton 84646

• Sending Locking Alert

  I have 2 tables the first one holds the dbwait information(locks), and the second table holds the d…

  Bruin

  6 replies

  5 years ago

  By: Bruin

• Need help with calculating data between 6pm-6pm instead of 12am-12am

  Hi, I am looking to calculate some data. We have orders dropping every day, and I need to calculate…

  uahmed90

  3 replies

  5 years ago

  By: ScottPletcher

• Dynamic SQL? Inserting Sproc data into table variable

  Hello, I have a bunch of stored procs that I'd like to execute all at once,  insert their results i…

  tacy.highland

  6 replies

  5 years ago

  By: tacy.highland

• query runs for some users fast and for some very long why?

  Hello, While running the above query thru SSMS we see odd behavior with the time it takes to run th…

  juliava

  12 replies

  5 years ago

  By: juliava

• Result set different after breaking up case expression in where

  I'm back again with more dumb questions. This time I am dealing with refactoring a single select wi…

  scarr030

  4 replies

  5 years ago

  By: ScottPletcher

• Can I prove queries were created in ORM from SQL ?

  Getting a lot of raw, non-sproc queries run which is causing plan cache bloat, any ways to prove th…

  JaybeeSQL

  4 replies

  5 years ago

  By: Grant Fritchey

• Surprising results when analyzing Bltzcache results....

  Blitz Cache reveals that the 50 most expensive queries run against the production servers are raw s…

  JaybeeSQL

  3 replies

  5 years ago

  By: Jeffrey Williams

• Export empty JSON with headers & footers

  Hello, I have inherited a process that utilises an SSIS package and related stored procs that creat…

  stephen.plant

  4 replies

  5 years ago

  By: Phil Parkin

• Need to Convert SQL Code Written for Azure SQLDW to SQL Server 2016

  Hello Community, The attached SQL Script (Procedure) is compiled / written for Azure SQL DW. As suc…

  carlton 84646

  2 replies

  5 years ago

  By: Phil Parkin