SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• sql cursor in stored procedure - not looping

  I have a problem that I don't know how to solve.Since yesterday I've tried all the different approa…

  sani.bozic

  11 replies

  8 years ago

  By: sani.bozic

• Trigger to stop original transactions AND return error AND do some other stuff

  Hi all I'm looking for a way to use RAISERROR with severity 16 (or at least >10) in a trigger, b…

  antonstar

  14 replies

  8 years ago

  By: antonstar

• Please help with the following query

  I"m calculating shifts time between two date range. the following query works but sometimes it…

  Nomvula

  1 replies

  8 years ago

  By: Mike01

• TRUSTWORHY ON & Execute as user

  I need to query an access .mdb file in a locked down network drive. I was planning on using OPENROW…

  rob.lewis 86087

  4 replies

  8 years ago

  By: rob.lewis 86087

• TSQL queries for handling Merge statements

  Hi All, How can we implement MERGE statememnt using TSQL. Reason, in our application we might need…

  vsamantha35

  4 replies

  8 years ago

  By: Jeff Moden

• Problem with concatenating columns and using that in a WHERE clause

  Hi allI'm currently having a couple of problems with the script below. What I'm trying to achieve i…

  j.clay 47557

  9 replies

  8 years ago

  By: j.clay 47557

• Error handling in nested stored procedure

  I have the following code Create procMaster as Begin try   Begin transaction   exec…

  Guras

  8 replies

  8 years ago

  By: sgmunson

• query help needed

  Hi Experts, Need sql query help. create table test(PropertyType varchar(100),PropertyName varchar…

  vsamantha35

  6 replies

  8 years ago

  By: Luis Cazares

• Cannot reorganize an index because its disabled, but its not disabled.

  I am attempting to reorganize an index, but I get an error message in SSMS that " Cannot perfo…

  gloeffler

  2 replies

  8 years ago

  By: gloeffler

• XML nodes help

  The XML in the attached file is the XMLTEXT field in my CDRecords table. What code would i use to c…

  Jackie Lowery

  22 replies

  8 years ago

  By: Jackie Lowery

• Using multiple thread when executing SSIS packages

  When you execute an SSIS package, does it use a single thread or do I have the ability to make it r…

  NewBornDBA2017

  2 replies

  8 years ago

  By: sgmunson

• Query help for inserting data

  Hi I am writing a procedure to move data from one table to another along with some additional field…

  KGNH

  4 replies

  8 years ago

  By: jimel 39024

• How to use functions to update columns?

  I am a beginner with using functions, I need to update only one column (which is the FIRST null it …

  patelxx

  8 replies

  8 years ago

  By: sgmunson

• convert date to numeric

  Hello, I have a excel document that contains 4 digit numbers in a column.  Sometimes these num…

  clicky

  6 replies

  8 years ago

  By: Eirikur Eiriksson

• Wildcard in IN statement

  I'm using a function to convert a users comma separated list of values to a table to use in a query…

  Jackie Lowery

  7 replies

  8 years ago

  By: jcelko212 32090