T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• getting data from single column and inserting into multiple columns

  example col1 col2 sno firmno 1 1 firmtype ABS …

  jyothirmayi.cr

  1 replies

  18 years ago

  By: Lowfar

• Conditionally Calling a StoredProcedure

  How can i conditionally call a stored procedure in SQLSERVER using IF/CASE statement. The Value pas…

  J S Gurumoorthy

  9 replies

  18 years ago

  By: max8693

• insert value into ntextfield using query analyser

  Hi How can I insert large amount of text data into ntext data field using query analyser. Th…

  salittajose

  4 replies

  18 years ago

  By: salittajose

• Order by Query

  Hi friends, i have column which have data like below. 6 hours 6 hours 30 minutes '' '' '' 14 hours …

  dva2007

  7 replies

  18 years ago

  By: Jeff Moden

• Delete all records in database older than 2 years

  I have been trying to find a good sql statement which would delete all records within a particular …

  AJS101

  6 replies

  18 years ago

  By: Jeff Moden

• about converting datetime without time part

  Hi All, I am trying to make a report with Microsoft Reporting Service. I have an datetime type para…

  aysegul

  6 replies

  18 years ago

  By: Lynn Pettis

• Finding and object in multiple databases

  I have about 20 databases on one instance of SQL server, stored procedures get deployed to all but …

  Maique

  2 replies

  18 years ago

  By: Maique

• inserted data with inner join when ID are same for multiple data

  I have a table that is updated from a 3rd party database from the payroll company that the client u…

  Gail-378561

  8 replies

  18 years ago

  By: Joel Ewald

• Calculating Opentime between several records

  I am trying to get the opentime between the employee exceptions during the day. For instance if em…

  RubyRed

  5 replies

  18 years ago

  By: RubyRed

• Creating a view on stored procedure

  hi I have to create a view for the output of a table and stored procedure1 it is explained below.…

  vsjayashri

  3 replies

  18 years ago

  By: Catalin Enescu

• Stop Script Execution

  I frequently develop scratch sql scripts in Management Studio - as a single file - and only run sma…

  Tom257

  2 replies

  18 years ago

  By: Tom257

• Averages help

  I have a player stats table which I want to get the team average but I can only get the average for…

  bennyt

  4 replies

  18 years ago

  By: bennyt

• column

  Hello Everyone, I am new to this (especially T-sql).I need to define a column in a table.I can use …

  swekik

  3 replies

  18 years ago

  By: swekik

• display single column data into multiple clolumns

  I have four tables customer(pk_Customerid,name,address,fk_phonetypeid) customerphone(pk_customerpho…

  Vundela

  11 replies

  18 years ago

  By: Jeff Moden

• text file in sql

  hi how can i store text files in sql2000? please help me thanks

  hadidavinci

  2 replies

  18 years ago

  By: tbeadle