T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Difference in ISDATE function's behaviour

  Recently i migrated from SQL Server 2005 to SQL Server 2008. At one place our code was giving error…

  sqlnaive

  12 replies

  14 years, 10 months ago

  By: sqlnaive

• Find previous Saturday and Sunday

  Sample here populates a table for all of August 2011, incremented in 30 minute intervals: declare …

  kuopaz

  2 replies

  14 years, 10 months ago

  By: kuopaz

• how rollback works in sql server?

  Hi, In Oracle, If you do an update, delete and insert, then we can use COMMIT to commit the transac…

  gary1

  12 replies

  14 years, 10 months ago

  By: HowardW

• Please help with Merge statement understanding

  Hi all, I am looking to use the Merge statement for ETL processes, and I am having a hard time unde…

  Sha_

  4 replies

  14 years, 10 months ago

  By: Ron McCullough

• combine string from multiple records

  I know i can write select sum(price) from orders how do i combine text from multiple records say my…

  skb 44459

  9 replies

  14 years, 10 months ago

  By: diamondgm

• Need help with custom ordering, null first/last

  Hi all, my first post here, hoping someone could help me out on the following problem. I have this …

  wouter.alleweireldt

  7 replies

  14 years, 10 months ago

  By: Jeff Moden

• Same Date and Various Time Select in Single Row in sql server

  EmpCode ShiftDateTime 2058 01/02/2011 13:43 2058 01/02/2011 20:12 2058 01/03/2011 14:04 2058 01/03/…

  tamil.selvanmca

  5 replies

  14 years, 10 months ago

  By: Jeff Moden

• Select where records dont exist

  I have a table of employess with 1049 records, and a table of training assessment results, and a ta…

  daniel.hobbs-939069

  2 replies

  14 years, 10 months ago

  By: Jeff Moden

• SQL to return only rows that aren't distinct

  Anybody know an easy way to do this. I have some rows that aren't distinct by the key I'm using, an…

  Sean Grebey-262535

  4 replies

  14 years, 10 months ago

  By: R.P.Rozema

• Select where statement issue

  Hi Folks, select * from Form where FromID < > 3 and FromID < > 4 Above SQL Query retu…

  maxcoder1@gmail.com

  6 replies

  14 years, 10 months ago

  By: Salil-386686

• Query execution much slower after upgrade

  Hi folks, Last weekend I upgraded a key database from SQL2k to SQL2k8R2. There's a view on the DB …

  webtekkie

  16 replies

  14 years, 10 months ago

  By: Salil-386686

• Month and YTD Running Totals

  Greetings, I am attempting to do something that is seemingly simply, though I have run into a few c…

  @Mike

  5 replies

  14 years, 10 months ago

  By: Jeff Moden

• Join two views cause slow query.

  I have two views joining on accountID. -------------------------- Main query of the report -------…

  pphimchaidee

  5 replies

  14 years, 10 months ago

  By: pphimchaidee

• Is there any way to capture parameter values passed for nested stored procedures?

  Is there any way to capture parameter values passed internally for nested stored procedures? Profil…

  praveen_vejandla

  13 replies

  14 years, 10 months ago

  By: praveen_vejandla

• error while deleting entries from the table

  UTS testing is goin on and as a part of it few entries need to be deleted from VTBFHAPO.When the se…

  aby_dvd

  3 replies

  14 years, 10 months ago

  By: Ashok Teotia