SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Barcodes Code128 generator function

  Use Following Functions ALTER FUNCTION [dbo].[CreateBarcodeCode128](@Barcode VARCHAR(20))RETURNS VA…

  Vishal Kale

  2 replies

  8 years ago

  By: aaron.reese

• Scripting Parameters Comments in Queries

  Hello Everyone,     I just recently updated my SSMS to 17.2 and now I am notici…

  meichmann

  4 replies

  8 years ago

  By: meichmann

• Stored procedure with input parameters

  Hi , I have the following stored procedure with  three input parameters. But not all the …

  sql_2005_fan

  4 replies

  8 years ago

  By: sgmunson

• Pivot basic question

  All, Apologises for the basic question. I have the following pivot: DECLARE @SQLStr NVARCHAR(max) …

  as_1234

  6 replies

  8 years ago

  By: as_1234

• Speeding up OBJECTPROPERTY...

  in our Azure environment, we are using some auto-generated code in our DACPAC deployments(code samp…

  mark seidelin-407018

  4 replies

  8 years ago

  By: ScottPletcher

• Sql Help

  I'm trying to return the orders and order line items for a specified customer.How can I get the ord…

  jason 50597

  3 replies

  8 years ago

  By: ScottPletcher

• General interview questions

  I had an interview where the interviewer asked "how to load data to olap and oltp". I was little co…

  komal145

  4 replies

  8 years ago

  By: Jeff Moden

• Assign group identifer to records with Cursor

  Hi, Can you please help with this? I have a table called HelpDesk with two fields(RowID and Name),…

  shogunSQL

  6 replies

  8 years ago

  By: jcelko212 32090

• First and last values before a partition change

  give the following data set: create table #t (CustomerID INT, Stage int, GroupStage int, FromDt dat…

  leeholden

  1 replies

  8 years ago

  By: Thom A

• test if first character of a value is upper case

  I want to test whether or not the first character of every value is upper case, and the rest are lo…

  isaac_654135

  4 replies

  8 years ago

  By: sgmunson

• Issue with update statement

  I have a column where it has all report names with the paths in the database For example - the path…

  mcfarlandparkway

  3 replies

  8 years ago

  By: Lynn Pettis

• difference between early start date and recent end

  can someone pls help with the code to get the difference in seconds between the recent end date and…

  Papil

  8 replies

  8 years ago

  By: Papil

• ssrs 2016 pivot capability over tabular models

  Hi, my tabular model has survey data with various dims including interviewer (employee), form,…

  stan

  9 replies

  8 years ago

  By: stan

• Merge replication using Web Sync

  I have setup Web sync for merge replication, which was working fine for a while. However I now have…

  David Kilmartin

  10 replies

  8 years ago

  By: Sue_H

• Partitioned tables slow running query (timeOut) while fetching data from Data View ?

  HI ,We are experiencing very slow running retrieval of data when fetch data from data View. Our tab…

  vineet_dubey1975

  1 replies

  8 years ago

  By: sgmunson