T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Function Using table Variabels degrades perfomance in SQL 2008

  We are now int the process of checking our environment in Sql server 2008. The server for the 2008 …

  gil_adi-803685

  13 replies

  15 years, 3 months ago

  By: Kit G

• Trying to understand SQL_Variants

  Here's my situation: I have a column in a table which is defined as SQL_Variant which seems to cont…

  JohnG69

  1 replies

  15 years, 3 months ago

  By: JohnG69

• Excluding rows from table

  Hi Here is my sample data. CREATE TABLE #WaterDays ( MeterCode VARCHAR (25) NULL …

  anitha.cherukuri

  8 replies

  15 years, 3 months ago

  By: Jeff Moden

• Select last 4 reports into "denormalized" table

  I need to find the 4 last reports from a company and ad them to 4 different colums of my "denormali…

  Jesper Wittendorff

  2 replies

  15 years, 3 months ago

  By: Jesper Wittendorff

• Working with self join

  I'm working on a problem trying to update field payrtamt in following table: SET ANSI_NULLS OFF GO …

  Dave Schutz

  5 replies

  15 years, 3 months ago

  By: Dave Schutz

• Maintenance Plans VS. Scripting?! Which is better?

  Hello, We had one of our DBAs go to a SQL Server Admin class. The instructor, well known SQL Serve…

  WebTechie

  8 replies

  15 years, 3 months ago

  By: WebTechie

• create row for comma seperate

  How to create 3 seperate rows for comma seperate values For example - DECLARE @T VARCHAR(10) SET @T…

  rpatil22

  16 replies

  15 years, 3 months ago

  By: Jeff Moden

• select distinct columns, nondistinct column from table

  Hi, I have a table with columns proj_id char(5), tenant_id char(6), lease_id char(8), Sales_yr num…

  rahulsony111

  4 replies

  15 years, 3 months ago

  By: Eugene Elutin

• See Contents of Temp Table in SSMS 2008 Debug Mode

  Is there a way to see the contents of a temp table while in the middle of SSMS debugging mode?

  Mister Ken

  1 replies

  15 years, 3 months ago

  By: noeld

• xp_cmdshell issue

  Hi All, I wonder if anyone can help shed some light on an issue i've run into. I'm attempting to ca…

  Chris Hazeldene

  4 replies

  15 years, 3 months ago

  By: Chris Hazeldene

• How to select 1 column into different rows and columns

  How to select this ID -- 1 2 3 4 5 6 and return it as : id1 id2 --- --- 1 2 3 …

  Jaybada

  10 replies

  15 years, 3 months ago

  By: Victor Dvoryaninov

• i need a query tip

  Hi guys, i have a transaction table 🙂 I need to find a sale frequency for each customer. In the end…

  canuzun

  12 replies

  15 years, 3 months ago

  By: Victor Dvoryaninov

• How to change some of the columns in to rows

  Hi, I've a query in which i need to change some of the columns into rows. Please see the example; E…

  rbnwork

  3 replies

  15 years, 3 months ago

  By: rbnwork

• Is It Possible To Create Variable To Hold Insert into Tabloe Variable?

  I have a situation where I have to create a dynamic where clause dependant on params passed into s…

  dndaughtery

  3 replies

  15 years, 3 months ago

  By: Gayathri.Varadarajan

• Remove set of characters between [abcd] using SQL function-Need help desperately

  I have a SP which gets parameter @business like this [abcdef] Client [gdhdnuidd] 1st Party SW testb…

  sammm

  2 replies

  15 years, 3 months ago

  By: WayneS