SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Using Case with 2 different variables in one query

  Hello Experts,I am trying to use 2 cases in the same query and is not working, this is the code: Se…

  montserrat.deza

  4 replies

  7 years, 12 months ago

  By: montserrat.deza

• Salesforce data and missing foreign keys

  For reporting purposes we have synced our SFDC data onto a SQL server using a third party middlewar…

  Ozymandias_EBON

  6 replies

  7 years, 12 months ago

  By: Ozymandias_EBON

• T-SQL Help on same table join

  Hi  SQL View   SELECT  a.Name , Q0.Value, Q.1.Value,Q2.Value FROM A with (noloc…

  vineet_dubey1975

  11 replies

  7 years, 12 months ago

  By: sgmunson

• Partition/Over Window Woes

  Morning All, I am trying to get a query to show me the results of jobs in the last 24 hours. I want…

  alex.sqldba

  7 replies

  7 years, 12 months ago

  By: Lynn Pettis

• pipe-delimited text with header row

  Hi, I need to save the result with pipe-delimited text with header row.any suggestions please.…

  adisql

  4 replies

  7 years, 12 months ago

  By: adisql

• Using Date in Where Condition

  I Have issues in selecting records when using date in  my where clause 1 )  I am try…

  aloshya

  36 replies

  7 years, 12 months ago

  By: Jeff Moden

• Very challenging TSQL Query

  Hi Experts, I have a table (test) with the following data : FL COL VAL Coverage Coverage N…

  Naveen J V

  9 replies

  7 years, 12 months ago

  By: Jeff Moden

• Ever seen MSDTC errors caused by heavy database load?

  [If there's a better forum to post this in, let me know! Thanks!] Has anyone seen occurrences of "N…

  james.crowley

  4 replies

  7 years, 12 months ago

  By: Sue_H

• SQL Query Help

  Hi Guys, Need help here. I am working on Project in SSRS where users can run and execute the stand…

  rocky_498

  1 replies

  7 years, 12 months ago

  By: Joe Torre

• calculation

  Hi, TOTAL  datatype is (numeric(10,0),null)STR  datatype is (numeric(20,15),null) REPLACE…

  adisql

  8 replies

  8 years ago

  By: Jeff Moden

• TSQL help on strings

  Hi All, I have a table with a varchar column. My requirment is to remove all the extra blank spaces…

  vsamantha35

  5 replies

  8 years ago

  By: Jeff Moden

• User Defined Aggregate assembly / CLR / Database compatibility level

  Hello, I'm having a weird behavior on a clr aggregate function. (concatenation of several strings u…

  ruy.peter

  7 replies

  8 years ago

  By: ruy.peter

• Selecting data related to an aggregated column

  I'm commonly tasked with requests to produce data related to an aggregated column value, what some …

  bartedgerton

  1 replies

  8 years ago

  By: Chris Harshman

• Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

  Hi, is there a tried and true generic script available that I can run that will go through each dat…

  quinn.jay

  7 replies

  8 years ago

  By: Jeff Moden

• Order by issue

  All, I have the following CTE: DECLARE @SQLStr NVARCHAR(max) declare @query AS NVARCHAR(MAX…

  as_1234

  8 replies

  8 years ago

  By: jcelko212 32090