T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• CREATE or ALTER PROCEDURE not detecting invalid object names.

  Hello, I have an odd problem that is causing me some frustration. When I execute a CREATE PROC or A…

  EITCL

  2 replies

  15 years, 7 months ago

  By: diamondgm

• Merging database having same structure

  I have 4 database with same structure. we have to integrate it into single database.All 4 database …

  anjani_aim

  1 replies

  15 years, 7 months ago

  By: Lowell

• Getting the dates between a range

  I have two variables @StartDate and @EndDate I want to write a SELECT Query which can give me rows …

  gaurav-404321

  3 replies

  15 years, 7 months ago

  By: Dohsan

• How to Get the count of columns based on some value

  I have 40 columns in my database table col1 col2 col3 col4....col40 …

  gaurav-404321

  5 replies

  15 years, 7 months ago

  By: gaurav-404321

• Create temp table with from existing table adding a new column

  I have a table (FOX.YPROFIT) where I need to write 6 of the columns to a new 7 column temp table (D…

  beth0802

  3 replies

  15 years, 7 months ago

  By: ColdCoffee

• SQL to manipulate rows of data

  Hello, I have a table that looks like this. projectId (char(15)) | departmentId (char(7)) …

  krenshau

  17 replies

  15 years, 7 months ago

  By: Jeff Moden

• Converting to DateTime

  I'm tasked with implementing Reporting from a new Database (Moodle) which is used for employee deve…

  latingntlman

  18 replies

  15 years, 7 months ago

  By: mstjean

• max date in a subset

  I have some data in a table called loadit with an rxno (not unique), patient, location, filldate. …

  timscronin

  2 replies

  15 years, 7 months ago

  By: Ben Teraberry

• Adding multiple records to one line

  Hello All, I have a table that is such Name College Smith Auburn Smith …

  marty.seed

  4 replies

  15 years, 7 months ago

  By: Lowell

• No Lock explatation

  My friend advised me to add no lock to statements because I query the database mostly at the same t…

  jon pill

  6 replies

  15 years, 7 months ago

  By: SQLRNNR

• Multiple inserts using key column and then flag Source table when row is loaded

  Hi, Table_A has many columns which are grouped by a File_Name column. I need to insert one or more …

  DerbyNeal

  3 replies

  15 years, 7 months ago

  By: Eugene Elutin

• Transaction log becomes full with trigger

  Hi there! I have a problem I'm facing. I have two tables; one called LOGGING and the other one ARCH…

  Danspojken

  4 replies

  15 years, 7 months ago

  By: george sibbald

• convert an interger to time

  hello all, Can someone provide me the sql to convert 015136 to 1:51:36 (h:m:s) Thanks

  atwilke

  8 replies

  15 years, 7 months ago

  By: atwilke

• DateDiff Function

  Hello Everyone I am looking for a function that will use the return the differences in Years, Month…

  AndrewSQLDBA

  8 replies

  15 years, 7 months ago

  By: Jeff Moden

• Help with Date part

  create table TestTable (id int, date Varchar(20) ) insert into TestTable values(2,'08/31/1984') in…

  sql.kishore1

  27 replies

  15 years, 7 months ago

  By: rjv_rnjn