T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Dealing with charindex output

  I have two tables TableA and Reference table TableB DECLARE @TableA TABLE ( city VARCH…

  Deepthy

  6 replies

  14 years, 12 months ago

  By: Deepthy

• Pre-Aggregated Tables - Weekly Inventory

  Hello Experts, I am trying to get weekly inventory values from my db table named LookupInv. This ta…

  erdem1973

  7 replies

  14 years, 12 months ago

  By: The Dixie Flatline

• CTE/TSQL to produce the desired results

  Few days back as I mentioned in my post http://www.sqlservercentral.com/Forums/Topic988521-392-1.as…

  Shamshad Ali

  1 replies

  14 years, 12 months ago

  By: Shamshad Ali

• subquery runs quicker than expected

  below is a query to select a data set. I added the sub query in the from clause and joined upon it.…

  winston Smith

  3 replies

  14 years, 12 months ago

  By: The Dixie Flatline

• Deleted Values Insert into a new tables

  Hi All, I have Database DB and Table CB ..CB has 3 dependent Tables OB ,CP,CI So My Requirement is…

  nari.koud

  4 replies

  14 years, 12 months ago

  By: parthi-1705

• Funny Update Statement?

  I've been re-formatting ola hallengren's sql maintenance script so I can read and understand it bef…

  david_wendelken

  2 replies

  14 years, 12 months ago

  By: parthi-1705

• Global Temp Tables

  Hi What is the possible reasons that Global Temp Tables can cause performance issues. Thanks

  coenie-353912

  1 replies

  14 years, 12 months ago

  By: Paul White

• How to get the earliest date in a continous order

  Hi, I have a business case where a member selects a teacher on a monthly basis (but not every month…

  Coconut

  5 replies

  14 years, 12 months ago

  By: Ron McCullough

• Table Partition in Sqlserver 2005

  Hi to all, To partition the table in sqlserver 2005 to all table to create an primary key is opti…

  sqlfriends@sql.com

  1 replies

  14 years, 12 months ago

  By: The Dixie Flatline

• Some advice for a badly performing query

  Hi All, I'm struggling with a badly performing query which has me at my wits end and I was hoping f…

  deenem

  8 replies

  14 years, 12 months ago

  By: The Dixie Flatline

• trim and round

  How to round up a number and trim it to two digits, exe 1.434567 to 1.4

  harita

  14 replies

  14 years, 12 months ago

  By: harita

• Rows to columns

  Thanks in advance for any help you can provide. I have the following; ID Desc …

  peygham

  9 replies

  14 years, 12 months ago

  By: ChrisM@Work

• Different Columns to relate and define a relationship

  DECLARE @MyRelations TABLE ( SubjectID VARCHAR(8), RelatedID VARCHAR(8) ) INSE…

  gova

  5 replies

  15 years ago

  By: gova

• date in sql

  hi , i need to have the current 'thisyearmonth' expressed as 201008 means august 2010 has to be exp…

  cpinky01

  4 replies

  15 years ago

  By: Philipp Post

• SQL Server Table Structure, StartDate and EndDate

  hi, I have this table Structure for international dialing Codes and Tariffs: CREATE TABLE [dbo].[T…

  LightPerf

  8 replies

  15 years ago

  By: houdou2