T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Kerberos

  Hi, Anyone know of a DMV or an easy way to check using TSQL whether Kerberos double-hop is working?…

  adb2303

  2 replies

  13 years, 1 month ago

  By: adb2303

• Compare Database Objects from Multiple Instances

  Dear Friends, I am planning to compare database objects from Multiple Instances. Details are given …

  pawana.paul

  11 replies

  13 years, 1 month ago

  By: pawana.paul

• insert top (X) into table

  Hello, this is rather urgent.. I have a population of people who got less than 3 coupons, and i nee…

  Mikalina

  4 replies

  13 years, 1 month ago

  By: Mikalina

• junk characters in a field

  I have a field called " TranNo" which is a 12 digit number but it seems like some of the reords hav…

  Tara-1044200

  29 replies

  13 years, 1 month ago

  By: Jeff Moden

• LEN function

  I want to remove last 12 characters of a string but looks like there is a limitation for only 8 cha…

  Tara-1044200

  15 replies

  13 years, 1 month ago

  By: Ron McCullough

• T-SQL Programming Query

  Hello, I find myself in a situation where the business users that I am working with to create an ap…

  TeraByteMe

  9 replies

  13 years, 1 month ago

  By: cphite

• SQL to get all Days in the month in Group by even with Zero values

  How do I write a SQL which outputs all the days of the given month even when the Count of the Regis…

  datsun

  9 replies

  13 years, 1 month ago

  By: mstjean

• paramatize case statement?

  Please advise with this case statement: CASE [ApprovalID] when '35CD3B40-DD5B-4231-9FF4-C4549BBAD…

  AIRWALKER-375999

  13 replies

  13 years, 1 month ago

  By: Eugene Elutin

• covering indexes

  hi guys, I have a table with 110M rows in it, 33 fields per row, mostly varchars of varing lengths …

  aaron.reese

  3 replies

  13 years, 1 month ago

  By: David Benoit

• How to dynamically select a db based on data in another db's column

  So here is my layout. I've got identical customer DB's (different data) DBName Table Column…

  bopritchard

  7 replies

  13 years, 1 month ago

  By: Sean Lange

• split string separated by special character .

  Hi, I have one string say '123^4567890'. I want either left part or right part from '^'. how can I …

  fanindrabhortakke

  2 replies

  13 years, 1 month ago

  By: fanindrabhortakke

• Pivot or dynamic query

  hi friends, just wondering if some one can help me writing this query? drop table #temp create tabl…

  dva2007

  2 replies

  13 years, 1 month ago

  By: The Dixie Flatline

• Adding a Cumulative Sum Column

  Hi, I need to write SQL query to assign a running total. Scenario: A running total of everytime a …

  aarionsql

  9 replies

  13 years, 1 month ago

  By: Dwain Camps

• SPACE() vs REPLICATE()

  Hi all. I had in the back of my mind for some reason that SPACE() was faster in a SELECT query than…

  jgoeson

  1 replies

  13 years, 1 month ago

  By: Dwain Camps

• The recursive part of a CTE do not allow aggregate functions

  There is a SQL Server undocumented extended stored procedure called xp_dirtree, which can return al…

  yousui

  7 replies

  13 years, 1 month ago

  By: Sean Lange