SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months 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

  6 years, 8 months ago

  By: lsalih

• Can I hint a join order or can I hint the first index seek ?

  Hi, I have a query that is not performing well. The execution plans starts with an index seek on th…

  Gamleur84

  5 replies

  6 years, 8 months ago

  By: Grant Fritchey

• Changing the isolation level without wrapping code in BEGIN / COMMIT TRAN

  Hi all, My question is whether or not I have to wrap my SP code in a transaction to take the "SET T…

  Mr. Holio

  3 replies

  6 years, 8 months ago

  By: Mr. Holio

• Script to close the excel file

  I have an agent job which runs everyday and it often fails because the excel file (source) is open.…

  LearningDBA

  5 replies

  6 years, 8 months ago

  By: Lowell