SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• INSERT INTO where if a Select statement returns no records use an alternate one

  I feel like this is pretty basic but I have never done it before. How can I do an INSERT INTO and d…

  Sean Grebey

  7 replies

  10 years ago

  By: Sean Grebey

• Excel Time into Decimal. SQL Decimal into TIME

  I have an excel cell that is a TIME format. Take 10:00:00 AM for example, when it is exported into …

  John215

  2 replies

  10 years ago

  By: John215

• How to improve performance of select statement in Dataware house app

  HI Champs, I have huge table of 70 million records and 300 columns, and it is partitioned based on…

  ravi@sql

  3 replies

  10 years ago

  By: ScottPletcher

• SQL Agent job failed with [SQLSTATE 23000] (Error 2627)

  Hello, My name is Avadesh, and I'm new to this forum. Nice to be here! I have this SQL agent job th…

  avadeshuwaran

  3 replies

  10 years ago

  By: Phil Parkin

• Possible Query Refinement & SSIS Package Locking Source Table?

  Hi, I wrote an SSIS package to generate a report. The basic flow of the data flow is this: - Declar…

  abelwingnut

  3 replies

  10 years ago

  By: Phil Parkin

• SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

  DECLARE @Date datetime SET @Date = '2016-03-10 00:00:00.000' The code below giving out of range err…

  PJ_SQL

  3 replies

  10 years ago

  By: John Mitchell-245523

• replacing text after a certain character

  Hi I have a table called 'mytable' we have various records in it such as abc@someemail.com def@some…

  PearlJammer1

  2 replies

  10 years ago

  By: PearlJammer1

• Flag Values Based on Columns

  Hi All, I Have a Table with the values as shown below : IDcode recoIDPostmtsa_m Desired…

  nm.rajesh

  38 replies

  10 years ago

  By: Sergiy

• traverse query

  I need a query to get Parent, childrens,grand childrens,greatgrand childrens etc relationship upto …

  Mvs2k11

  17 replies

  10 years ago

  By: Mvs2k11

• How to create a Stored Procedure from this Code

  Hi all, I have a process written in SQL that is around 4000 Line, the process is basically 25 secti…

  oneteabag

  29 replies

  10 years ago

  By: Luis Cazares

• Link two SQL R2 servers

  I have access to 2 servers. 1 server is 100% access to do anything I want. The other is read and se…

  tinamiller1

  2 replies

  10 years ago

  By: tinamiller1

• Column values into comma seperated

  Hi Team, using below query to convert the columns in to comma seperated. SELECT 1264, isnull(col1,…

  Minnu

  4 replies

  10 years ago

  By: drew.allen

• 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 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 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 ago

  By: MMartin1