T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get the one set of values from the same table

  Hi, I have a table which has following columns ShipmentID, ProductID, ProductType,Qty Now I want to…

  Gunjan

  2 replies

  13 years ago

  By: Gunjan

• retrieve records by joining history table

  HI, Can you help me with the query. Thanks for any help. The below is the example scenario: Master_…

  naveen_balraj

  1 replies

  13 years ago

  By: j.miner

• HierarchyID performance problems... Really???

  I heard tales of performance problems associated with the HierarchyID datatype in SQL Server 2008.…

  Jeff Moden

  31 replies

  13 years ago

  By: Jeff Moden

• Selection using date held as a string

  In our database we have a parameters table that holds a parameter type (e.g. D for date, N for numb…

  Chris Quinn-821458

  11 replies

  13 years ago

  By: Lynn Pettis

• Improve performance of query involving linked server

  I am trying to make improvements to a job that does the following. 1) Load a table with about 40,00…

  SQLCurious

  3 replies

  13 years ago

  By: Chrissy321

• Stored Procedure Records

  I have created a stored procedure that will return approved purchase orders when executed. However,…

  bpowers

  6 replies

  13 years ago

  By: Sean Lange

• Calculate number of days missed per term

  Need to update a new column (DaysMissed). Trying to calculate the number of days missed per term (a…

  Sqlraider

  12 replies

  13 years ago

  By: Sqlraider

• Insert into new table based on conditions

  Hi all, I'm struggling with a query which runs forever and I can't figure out what the problem is. …

  geert.de.vylder

  4 replies

  13 years ago

  By: ChrisM@Work

• Query help

  I need a query to get the required output.. DECLARE @Table TABLE( stid INT, st…

  Mvs2k11

  4 replies

  13 years ago

  By: vinu512

• MERGE TSQL in SQL SERVER 2008

  Hi ALL, Need one help/suggestion in tsql using MERGE in sql server 2008.I'm using the below code to…

  sam 55243

  4 replies

  13 years ago

  By: sam 55243

• Generate all possible number combinations for a provided list of numbers

  Hi Experts, I want to get "all possible number combinations" for provided list of numbers. As an ex…

  Prashh

  6 replies

  13 years ago

  By: vinu512

• how to rename columns that you are unpivoting on?

  I've successfully unpivoted Months01 through Months02 with a query that looks like this: /****** Sc…

  KoldCoffee

  1 replies

  13 years ago

  By: KoldCoffee

• TSQL CTE Insert

  Hello, I was sure I had asked this before but I can't find that post so my apologies for the repeat…

  nfs_john

  1 replies

  13 years ago

  By: Steven Willis

• bcp output of table variable

  DECLARE @tempOutput TABLE ( vend_num NVARCHAR(7) NULL , name NVARCH…

  skb 44459

  1 replies

  13 years ago

  By: Lynn Pettis

• How to select data in a particular format

  Greetings all. I have data in a view that when selected from looks like this: CertYear CertCode …

  jagd

  8 replies

  13 years ago

  By: jagd