SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Updateing related record

  Hi there im not sure how to do this as im not great with update statements. I have a table that ge…

  ps_vbdev

  7 replies

  11 years, 6 months ago

  By: ps_vbdev

• Trying to find a more simplistic way to execute this complicated Aggregation Query

  Greetings all So below I have a query that is returning results as I actually want them. However, …

  shannonjk

  5 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Surrounding proc definitions with BEGIN ... END

  We have a discussion going on internally. Some devs prefer doing this: CREATE PROC x as BEGIN --do …

  Phil Parkin

  12 replies

  11 years, 6 months ago

  By: Phil Parkin

• Do @@Identity And Scope_Identity Always Return The Record Just Added?

  I understand the differences between @@IDENTITY and SCOPE_IDENTITY, I think, but I'm struggling to …

  Phil Stratford

  4 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Moving identical data from one table to another. Error on Converting to Float

  So I have two tables with similar columns etc, unfortunately the Insert to the History table fails.…

  wit_jp2001

  1 replies

  11 years, 6 months ago

  By: wit_jp2001

• output identity values

  Hi I have a process to rollover prior quarter data to new quarter in a table. For example, i have a…

  AVDR

  27 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Regroupement sur interval de date

  Salut, voila j'ai les données suivantes : INSERT INTO Sales(mnth, qty) VALUES ('20071201', 100), ('…

  bkaurelien

  3 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Join on different data types

  Long story short, we have a query that joins column A int which is an int onto column B with contai…

  devorlask

  6 replies

  11 years, 6 months ago

  By: Phil Parkin

• Converting XPath to FLWOR

  I'm trying to go deeper into SQL Server's XML support. When looking at a recent forum post, I got …

  gbritton1

  1 replies

  11 years, 6 months ago

  By: Alan Burstein

• Issue with a slow Query

  Hi all, I have attached a script and its execution plan for your review. We are working for a long …

  T.Ashish

  14 replies

  11 years, 6 months ago

  By: Gail Shaw

• equal (=) comparison of strings

  Is there a limit on the size of the strings on both sides of the '=' sign for string comparison? I…

  N_Muller

  1 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• How to insert the results returned using 'exec StoreProc with result sets' when called from a another proc

  I have a stored proc that calls a child proc that returns 2 result sets. the first one is just a r…

  wall str33t

  7 replies

  11 years, 6 months ago

  By: Jeff Moden

• access the XML, CLOB and BLOB Oracle data through linked server from SQL Server 2012

  Hi, How to access the XML, CLOB and BLOB Oracle data through linked server from SQL Server 2012?

  s.ravisankar

  1 replies

  11 years, 6 months ago

  By: Sean Lange

• Variables being ignored ?

  Hi, I'm having a crazy time trying to understand a problem I have in a script. The script is design…

  giles.clapham

  7 replies

  11 years, 6 months ago

  By: wall str33t

• return multiple messages to client application

  Hi, I have a procedure where after processing, i am required to send multiple message to calling ap…

  AVDR

  1 replies

  11 years, 6 months ago

  By: Sean Lange