SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Traversing down a tree

  I'm working with a development bug database where if someone puts in a bug number, they want to get…

  mark.worthen

  25 replies

  10 years, 11 months ago

  By: Jeff Moden

• Checksum hashvalue in sql 2012

  Hi , By using below command I am able to get the hashvalue, update ArchiveBBxCcsms set RowChecksu…

  vipin_jha123

  4 replies

  10 years, 11 months ago

  By: Umer Akram

• Capture Source count,update count,inserted count in variable using merge

  Hi , Below sp is working fine updating and inserting record properly. But now I want to track the s…

  vipin_jha123

  3 replies

  10 years, 11 months ago

  By: Eirikur Eiriksson

• Stored Proc compiles even when there is no CREATE TABLE for a temp table

  Hi All, I think that the below snippet should give a compilation error because I am inserting somet…

  Vinoo

  3 replies

  10 years, 11 months ago

  By: Steve Jones - SSC Editor

• The dreaded RBAR

  Can anyone tell me where to look when trying to figure out why the following query is running forev…

  Rick Todd

  16 replies

  10 years, 11 months ago

  By: Rick Todd

• Parameter Sniffing or Something else?

  A web app calls a proc from a sql server which resides on VM box. A proc takes a date range. When I…

  SQL_Surfer

  29 replies

  10 years, 11 months ago

  By: sqldriver

• How to join the tables to get only record with specific field value in a table

  I have a table of "applicants" with unique applicant id and another table "reviews" with reviews wh…

  amar_kaur16

  6 replies

  10 years, 11 months ago

  By: amar_kaur16

• GET 1 RECORD WHERE STARTDATES ARE IDENTICAL

  CREATE TABLE TEMPS(MEMBERNBR VARCHAR(11), STARTDATE DATETIME, ENDDATE DATETIME) INSERT INTO TEMPS(M…

  Nilssond

  2 replies

  10 years, 11 months ago

  By: LinksUp

• Weird behavior comparing two float columns in SQL 2012

  I am validating an ETL and am experiencing some weird behavior when I compare the numbers in my dat…

  dbodell

  3 replies

  10 years, 11 months ago

  By: TheSQLGuru

• Update Query

  I have 4 columns, ID, Dept.Number, Address and Grouping ID Dept Address GroupID 165683 32 P O BOX 6…

  Thugs

  2 replies

  10 years, 11 months ago

  By: TheSQLGuru

• Issue with Date

  Hi, The following code is pulling back odd date for 'TEST' column - why would that be? Basically I…

  TSQL Tryer

  8 replies

  10 years, 11 months ago

  By: vecerda

• What's a good indexing strategy for this situation?

  I have a 94,000 row table that looks like: CREATE TABLE dbo.GrossPay ( [CompanyID] [int] NOT NULL, …

  Dave-3000

  12 replies

  10 years, 11 months ago

  By: aaron.reese

• A delicious dilemma

  Hello, Given the below table, how would you go about finding bars that carry the same brands of sco…

  sqldriver

  22 replies

  10 years, 11 months ago

  By: aaron.reese

• Handling flat file destinations dynamically

  This is regarding a SSIS package. After performing a join operation on two tables i get the below r…

  toraghubiz

  2 replies

  10 years, 11 months ago

  By: aaron.reese

• If minus figure pull back 0

  Hi, Have the following in my SELECT Stataement CASE WHEN com.completion_date IS NOT NULL AND dim.D…

  TSQL Tryer

  4 replies

  10 years, 11 months ago

  By: TSQL Tryer