SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Local Date GMT +10

  Hi My Server is hosted in another country so the GetDate() returns the incorrect date for my local …

  ringovski

  2 replies

  8 years ago

  By: Steve Jones - SSC Editor

• How to get a Max Count

  I am trying to pull several fields and get a total count which I was able to do. However, what I re…

  summerfancher

  6 replies

  8 years ago

  By: saravanatn

• Trigger woes

  Hi all We've got an application that inserts information into an SQL table (table A).The trigger on…

  richardmgreen1

  13 replies

  8 years ago

  By: richardmgreen1

• Error Running SSRS Report - The server principal "DOMAIN\User" is not able to access the database "Database" under the current security context.

  Hi there I have created a database, and created a procedure that joins to an additional database t…

  bexstarr

  6 replies

  8 years ago

  By: Sue_H

• SSRS and labels

  I have a program in VB I have created to print labels. Currently I can print to a label printer (In…

  bswhipp

  4 replies

  8 years ago

  By: bswhipp

• Dynamic Schema Name

  Hi,  How to select from a table with dynamic schema name ? The database name and Table name re…

  PSB

  2 replies

  8 years ago

  By: jonathan.crawford

• IDENTITY columns and Java Objects

  I want to use IDENTITY columns in my database. Java devs are telling me that this creates problems …

  Sioban Krzywicki

  2 replies

  8 years ago

  By: sgmunson

• External table on MS Excel

  How can i create external table based on a excel file. //SharedDrive/Myfile.xlsx Format: EmpI…

  konark

  1 replies

  8 years ago

  By: Joe Torre

• Loading intermediate table

  Hi, I have these tables and data: CREATE TABLE [Table1](  [PartnerSiteID] [int] IDENTITY(1,1) …

  hoseam

  2 replies

  8 years ago

  By: Jeff Moden

• Number of Trades

  I need to write a query to extract the region of the trader, his name & the number of trades he…

  dangelo211

  4 replies

  8 years ago

  By: x

• update table with newid

  What is the easiest way to achieve the same results as the provided query?  i'm trying to upda…

  clicky

  2 replies

  8 years ago

  By: clicky

• t-sql to report on databases not recently backed up - if db is in an availability group, only report if it's a primary replica

  Hi allThis is a t-sql question but also involves some knowledge of the AlwaysOn DMVs so wasn't sure…

  doodlingdba

  2 replies

  8 years ago

  By: doodlingdba

• SSIS Package Lookup Task - Is not adding the field to the data flow

  I am in the process of migration data from an old, now unsupported application, into a new shiny SQ…

  Paul Giles-Randall

  3 replies

  8 years ago

  By: subramaniam.chandrasekar

• Scripting/logic help

  My head is well and truly mashed and I could do with some help please...I need to write a script to…

  Atyeo9

  3 replies

  8 years ago

  By: Jeff Moden

• Query to merge data

  I need to write a query to merge data.. basically all rows from one product (p1) should be assigned…

  sqlinterset

  3 replies

  8 years ago

  By: sgmunson