T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Counting into Month Columns

  Hi all, I'm working with the AdventureWorks database, trying to learn T-SQL better and hopefully ex…

  SeanCly10

  4 replies

  16 years ago

  By: Jeff Moden

• Database Migration- Urgent help

  Hello SQL Guru's, I need an urgent help. We are migrating the sql 2000 to sql 2008. The final cutov…

  hydbadrose

  10 replies

  16 years ago

  By: Peter Schott

• Restore option-During cutover

  Hello SQL Guru's, I need an urgent help. We are migrating the sql 2000 to sql 2008. The final cutov…

  hydbadrose

  2 replies

  16 years ago

  By: hydbadrose

• Select statment problem in cursor using datetimes

  I am going nuts trying to get this code to work with the final criteria! Trying to extract Notes th…

  rons-605185

  8 replies

  16 years ago

  By: Lynn Pettis

• How to search junk charcaters in a column

  HI, I have a employee profile tablewith 5000 rows. IN the firstname and lastname field few junk cha…

  vkundar

  3 replies

  16 years ago

  By: Garadin

• Extracting Only Time From DateTime Field in a Certain Output Format

  I'm trying to extract the start time of a meeting in the following format: 3:00 PM If I use the fol…

  Roger Abram

  3 replies

  16 years ago

  By: Roger Abram

• DateOf getdate()

  How can I obtain a date part of the function getdate ? or any datetime value. For Example: If i hav…

  sistemas_casinomnes

  4 replies

  16 years ago

  By: Nabha

• How can i overcome....?

  Dear all, Here I have some authors name here like Alok Bhatia Amit Chaudhuri Amit Varma Amitabha …

  Saravanan_tvr

  2 replies

  16 years ago

  By: Saravanan_tvr

• Qty values for each day

  Dear friends, I have a table like below: CREATE TABLE #MyTempTable (qty INT, startdate datetime, e…

  ss-457805

  10 replies

  16 years ago

  By: ss-457805

• Delimited file import

  Hi, Is it possible to import a pipe | delimited file int a table. The format of the file is as bel…

  bob.jubb

  3 replies

  16 years ago

  By: bob.jubb

• How do I group columns

  Hi, I think I am posting here after a long hiatus. I have tables as below Table Name : Emp Columns:…

  cmrhema

  1 replies

  16 years, 1 months ago

  By: Garadin

• Moving tables between servers

  Could anyone tell me how to use T-SQL to copy tables (structure and data) between servers? Thank yo…

  sqlgreenhand

  15 replies

  16 years, 1 months ago

  By: Garadin

• Select 10 contacts in a company randomly

  hi All, We have two table company and people and people has coid as a foreign key. I need to select…

  sharonrao123

  5 replies

  16 years, 1 months ago

  By: Jeff Moden

• trigger is throwing error when db is offline?

  Dear All, I have trigger that performs checking whether the database is online or not and it insert…

  dzordz_parowkowy

  5 replies

  16 years, 1 months ago

  By: Gail Shaw

• Getting information in database in structured format

  I have 4 columns in sql server Name Class RollNo Section I want to get the concantenated value of t…

  gaurav-404321

  2 replies

  16 years, 1 months ago

  By: Steve Jones - SSC Editor