T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Mapping Old identity values to new ones

  Hi All, I have a requirement in which I insert values into same table, but I need to map old identi…

  chandrakant_gaurav

  2 replies

  13 years ago

  By: Kingston Dhasian

• nvarchar

  From my understanding nvarchar allows you to store more than one language compared to varchar. Does…

  sstacy7

  3 replies

  13 years ago

  By: Jeff Moden

• Remove Duplicates from a Table using specific columns

  Hi Gurus, I am new to Teradata and working on a requirement. Below is the table Col1 Col2 Col3 Col…

  Babbi

  2 replies

  13 years ago

  By: Sergiy

• How to report on historical movements within a changing hierarchy

  I'm in an IT environment where we're wanting to: 1. run queries which will show rates of consumptio…

  polkadot

  12 replies

  13 years ago

  By: polkadot

• Simple update to opposite

  Hi I am struggling to find out how can I do the following in my SP. UPDATE EmployeeData SET selec…

  meelan

  1 replies

  13 years ago

  By: meelan

• Custom sp_who

  Hello All, Couldn't find anything that addresses this specifically, so here goes. I have a group th…

  datwungai

  17 replies

  13 years ago

  By: Vedran Kesegic

• Add variable number of rows into a table based on the values in another table (without cursors/while loops)

  Below is a simplified version of my tables: set nocount on drop table #x create table #x (docid int…

  charles99

  16 replies

  13 years ago

  By: Jeff Moden

• Debugging stacked CTEs efficently

  I'm curious if anyone else has figured out a good system for performing analysis on a query that ma…

  Banana-823045

  2 replies

  13 years ago

  By: Orlando Colamatteo

• Running Query on Multiple Database/Servers

  Hi I have a database table that contains all the server details. I have a query and wanted to run …

  ShuaibV

  2 replies

  13 years ago

  By: Orlando Colamatteo

• Optimization of dynamic SQL

  Hi All, I have a stored procedure with many optional parameters. Following is one of the code block…

  rajawat.niranjan

  1 replies

  13 years ago

  By: Orlando Colamatteo

• Calculate percentage

  Hi, I need to make a report from a table contains following data (I made a simple structure as the…

  RZ52

  3 replies

  13 years ago

  By: SwePeso

• i want update the 2nd column based on first column:

  hear i have id column based on that getting one more column as mid and data as belo: id 100 200 300…

  DBA.k

  13 replies

  13 years ago

  By: carlosaamaral

• index re-build on trucated table

  hi, i've seen a couple of cases where huge staging tables containing c/nc indexes are truncated and…

  _rohit_

  2 replies

  13 years ago

  By: Orlando Colamatteo

• Need help with recursive query

  Hello, Here is my scenario. Let's say I have two tables "Car" and "CarPart". The car consist of m…

  Misha_SQL

  9 replies

  13 years ago

  By: Misha_SQL

• how create sql str with special condition

  create sql str with special condition hellow I have 2 table Table a(code, price, check) Table b(…

  armm1388

  1 replies

  13 years ago

  By: Lynn Pettis