SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Calculation at each point in time

  Hi, I am trying to write a stored procedure that calculates a total at each point in time.This is m…

  anikeh

  8 replies

  7 years ago

  By: drew.allen

• Querying for mulitiple tables

  Hi, I am trying to run the following query against an auditee's database.  However, I only wan…

  autoxguy08

  2 replies

  7 years ago

  By: fahey.jonathan

• Can't remove duplicates

  Hi all, I have written below query to find indexes that have page compression.  I have added t…

  shahgols

  2 replies

  7 years ago

  By: shahgols

• Cast of Sceientific notation different result on different SQL version

  Hi, i got a question today and I just can figure out an answer. When casting a Sceientific notation…

  jacob.saugmann

  12 replies

  7 years ago

  By: Matt Miller (4)

• Access form that calls a stored procedure from SQL Server using this VBA

  I have an Access form that calls a stored procedure from SQL Server using this VBA: Private Sub For…

  DaveBriCam

  1 replies

  7 years ago

  By: pietlinden

• Output results of query to multiple text files to be later run into another DB

  We have two DBs A and B.  A is prior to upgrade and B is after upgrade.  B's xml data got…

  JKSQL

  1 replies

  7 years ago

  By: JKSQL

• Issue with synonyms and linked servers

  Hi all I've got a bit of an issue with a synonym being access via a linked serever. On our developm…

  richardmgreen1

  4 replies

  7 years ago

  By: richardmgreen1

• SP with Conditional Where clause where

  I need to create a stored procedure with an optional where clause and I'm just not sure how to get …

  CanuckBuck

  5 replies

  7 years ago

  By: CanuckBuck

• Incremental rowwise sum

  Hello All, I am having a table with two columns like monthname and sell. I want to show Jan to dec …

  abhas

  2 replies

  7 years ago

  By: Jonathan AC Roberts

• Permissions for different AD Groups

  HI, I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server…

  PSB

  8 replies

  7 years ago

  By: PSB

• Subqueries examples

  Someone new to SQL asked me to show him a dozen of subqueries samples for Northwind or AdventureWor…

  VoldemarG

  4 replies

  7 years ago

  By: usererror

• How can I offload the compute of SUM operation ?

  Hi, I have an interesting case. I have SQL resources governor configured with two different type of…

  Gamleur84

  3 replies

  7 years ago

  By: Jeff Moden

• Difference in checksum calculations.

  All,Thank you for looking into my question. I am facing an issue with difference in checksum calcul…

  Siva Ramasamy

  15 replies

  7 years ago

  By: Eirikur Eiriksson

• SSRS Expression Error

  Hello, I have an expression written for a textbox in a tablix. I'm getting an error that I can't se…

  Jim

  2 replies

  7 years ago

  By: sgmunson

• Create View Declar Variable question

  I have below query which I need to create a view for it, can you please guide me to what is the bes…

  lsalih

  2 replies

  7 years ago

  By: lsalih