SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• please help to convert column to row in sql

  Hi I have table like customerid 101 customernameRam gender Male married Y…

  panneermca35

  5 replies

  10 years, 4 months ago

  By: J Livingston SQL

• Split string into multiple entries based upon known static length

  I have several tables of data where one field holds multiple records of "n" static length. In the e…

  mciesiensky

  5 replies

  10 years, 4 months ago

  By: Alan Burstein

• programming within SELECT statement

  Hi, Does SQL Server allow programming within a SELECT statement? For instance, SELECT col1, col2 (…

  etl2016

  16 replies

  10 years, 4 months ago

  By: MMartin1

• How to sort sql result set like attached image

  Above is my sql query set which i want to sort like below My original query is this (means it sho…

  emadkhanqai

  5 replies

  10 years, 4 months ago

  By: drew.allen

• SQL Contains

  Hi, CREATE TABLE #TableSol ( ID INT IDENTITY(1,1), Text VARCHAR(100) ) INSERT INTO #TableSol ( Tex…

  PSB

  6 replies

  10 years, 4 months ago

  By: spaghettidba

• Extract xml to table.

  Hi, I have a following xml. '<Item> <Item customerid="101" customername="Ram" gender="Male…

  panneermca35

  3 replies

  10 years, 4 months ago

  By: panneermca35

• How to prevent data from being written to SQL Filetable Data Container

  HI All, I have a SQL file table which is created in a single File Stream Group. There are multiple …

  singh.ashal

  2 replies

  10 years, 4 months ago

  By: singh.ashal

• How to Remove Duplicates from my table

  Hi All, Hope you are doing great. Here I have a problem and I am sure you will help me out. I have …

  niladri.primalink

  15 replies

  10 years, 4 months ago

  By: Orlando Colamatteo

• execution of function with TVP

  HI. I am trying to execute the following function ( it is not mine) ALTER FUNCTION [dbo].[Dis] ( …

  gxdatareal

  1 replies

  10 years, 4 months ago

  By: spaghettidba

• Calculate Head Cout

  USE AdventureWorks2012; GO SELECT p.FirstName, p.LastName ,ROW_NUMBER() OVER (ORDER BY a.Postal…

  hoseam

  1 replies

  10 years, 4 months ago

  By: xanthos

• copy some column data from one table to another

  Hello, I am working at college. We using one ERP software called Jenzabar. Somehow advising tab is…

  Virtual Reality

  10 replies

  10 years, 5 months ago

  By: Virtual Reality

• Mystery data type conversion

  This one is so weird. I'd love to have some help figuring it out. A query works fine when I run it…

  PHXHoward

  5 replies

  10 years, 5 months ago

  By: PHXHoward

• BCP Issue in SQL

  I have issue in executing the command below SET @filePath = '\\i.p.a.d.d.r.e.s.s\Shared\Output1\…

  yitzakn

  1 replies

  10 years, 5 months ago

  By: Lowell

• Trigger for Table Updates

  Hi, I was wondering if anyone had some advice or example for creating a trigger that fires when a s…

  TJT

  11 replies

  10 years, 5 months ago

  By: Sean Lange

• Many conditions - best practice

  Hi, all. I have a table with information on thousands of network nodes where an engineer supplied m…

  SmackMule

  13 replies

  10 years, 5 months ago

  By: Jeff Moden