T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• T-SQL Help

  Hi T-Sql gurus, Guys I have question, Below is the sample table ID NAME STATE E.MAIL 1 …

  rocky_498

  7 replies

  15 years, 2 months ago

  By: Lynn Pettis

• How to return rows based on a condition

  Hi, I got stuck on the following: I have Table1 and Table2 Table1 PolicyNum____PreviousPolicyNum 77…

  elogen

  3 replies

  15 years, 2 months ago

  By: elogen

• Using Case for an Update

  Here's the scenario: There are two tables involved. One is the BookingActivity table which will be…

  tacy.highland

  9 replies

  15 years, 2 months ago

  By: tacy.highland

• Query default sort order

  I thought I knew the answer to this until restoring a 2000 db in 2008 for migration testing. An id…

  tsduke

  3 replies

  15 years, 2 months ago

  By: tsduke

• Need Help

  Hi, I have a strange problem while writing one SP. Could you please help me to find out why the res…

  borra2005

  1 replies

  15 years, 2 months ago

  By: Koen Verbeeck

• How to add one year to a date using SQL script in SQL server?

  Hi All, I am getting a date parameter value as '4-1-2009' (for @d parameter in SQL server) from f…

  sreeramjithendra

  4 replies

  15 years, 2 months ago

  By: Henrico Bekker

• Merge statement question

  i have a table like this CREATE TABLE Tbl ( [GUID] [uniqueidentifier] NOT NULL ROWGUIDCOL [Address]…

  danavni@officecore.com

  5 replies

  15 years, 2 months ago

  By: danavni@officecore.com

• Need help SET CONCAT_NULL_YIELDS_NULL Issue

  Hi all, I am facing a problem with set concat_null_yield_null option I am having a trigger, which i…

  ghanshyam.kundu

  2 replies

  15 years, 2 months ago

  By: ghanshyam.kundu

• Query to Rip the X & Y from a Geometry column

  Hi everyone, I am trying to rip the x and y coordinates from a geometry column(geom) can anyone …

  rk07

  1 replies

  15 years, 2 months ago

  By: Evil Kraig F

• SQL OpenQuery to Active Directory Data Type Challenge

  Hello, I've created a linked server ADSI to issue an OpenQuery to Active Directory. I'm grabbing t…

  SQL Dude-467553

  1 replies

  15 years, 2 months ago

  By: Orlando Colamatteo

• Add a ' to a String

  I pass a string to my stored procedure which is similar to this: 'test1,test2,test3,test4' SQL Serv…

  mpartridge

  12 replies

  15 years, 2 months ago

  By: mpartridge

• Need help with query to generate a Matrix

  I have a requirement for a query that, based on a set of data, it should return a matrix. The prem…

  Michael Bianchi-134041

  11 replies

  15 years, 2 months ago

  By: LutzM

• Performance tune SS SP

  Hi All, I have one SP to performance tune and the MAX function is not properly working on the VARCH…

  bhushan.bagul

  29 replies

  15 years, 2 months ago

  By: Dave Ballantyne

• Duplicates

  Hi. I want to find address duplicates. ACCOUNT and ADDRESS are columns(all the addresses are format…

  varunkum

  3 replies

  15 years, 2 months ago

  By: WayneS

• Auto adjust column width in query results window

  Hi All - Quick question. Is there a way to have the columns returned in my query results window aut…

  Shaira

  1 replies

  15 years, 2 months ago

  By: WayneS