SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to create Alert if there in No New Data loaded into Table

  Hi, I have a table with date column and primary key column with auto increment, but few times we ha…

  Sangeeth Raj

  1 replies

  9 years ago

  By: Eirikur Eiriksson

• Add 2 decimal fields(columns) with a CASE in SQL Server

  Hi All, I've 4 decimal(15,6) columns in my table and based on the condition i am updating one of th…

  User7766

  3 replies

  9 years ago

  By: User7766

• Conversion failed on datetime

  Hello, I have a stored proc I am trying to run but I am getting the error "Conversion failed when c…

  Matt.Altman

  5 replies

  9 years ago

  By: Matt.Altman

• How to Pass Output Parameter Store Procedure Value to input to another SP

  Hi All, I have two store procedure, i) Proc 1 (With Output Parameter) : No input parameter, one out…

  Sangeeth Raj

  3 replies

  9 years ago

  By: John Mitchell-245523

• Need help with a SQL "least significant digit" algorithm

  Hi all, Looking for some quick help with a bit of SQL. The best way I can describe it is that I'm …

  BowlOfCereal

  14 replies

  9 years ago

  By: BowlOfCereal

• Delete temp table by joining derived table

  Hi, I want to delete temp table by joining dervied table. EX: ; with cte ( select * from employee )…

  @Patrick123

  4 replies

  9 years ago

  By: Phil Parkin

• Trigger Questions

  I have a stored procedure that contains a merge statement that is working well. The Merge is your r…

  LinksUp

  6 replies

  9 years ago

  By: ScottPletcher

• How to get date value from a number ( ex: 20161108) ?

  Hi, I have this "20161108", I need this "2016-11-08 00:00:00.000", may be this pretty simple, but …

  prabhu.st

  5 replies

  9 years ago

  By: prabhu.st

• Get records which satisfy particular condition and exclude others

  I have the following data with client account decision and status Clientfields value 111Decisi…

  sindhupavani123

  19 replies

  9 years ago

  By: sindhupavani123

• Big data: transfer x-number of rows per batch?

  Hi all, I must transfer a big table (231k rows not that big, but 735GB big because of blob) to anot…

  Super_Grover

  43 replies

  9 years ago

  By: Jeff Moden

• sp_settriggerorder in section TRY/CATCH

  I have a problem with calling "EXEC sp_settriggerorder" when @TriggerName is not exists. After call…

  rajnoha

  6 replies

  9 years ago

  By: Phil Parkin

• Insert XML into SQL Server table

  Hi All, I will get XML input from the UI and need to insert the same into one of my SQL Server tabl…

  User7766

  11 replies

  9 years ago

  By: Eirikur Eiriksson

• Filling the missing rows/gap in the data

  Hello, I have been setting up a database where I can store our sales and activity data, and struggl…

  seismicbeat

  8 replies

  9 years ago

  By: Jeff Moden

• Query Help -Orgstructure count -TOTAL levels distinct required

  Please perform below steps We have different columns Rootlevel,level1,level2,level3 to Level6 . Now…

  mytesting9

  3 replies

  9 years ago

  By: sgmunson

• Record Selection

  Hi All, The below query gives two records, but I am trying to figure out a way to display only one…

  ssc_san

  8 replies

  9 years ago

  By: ssc_san