T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Ussing Substring, Patindex, Charindex to extract data from a string

  Hi guys, I have a conundrum that I would really appreciate some help with... Basically I need to ex…

  James Millar-305032

  8 replies

  15 years ago

  By: James Millar-305032

• Division Problem in SQL 2005

  Why is it that 1 divided by any number larger then 1 always returns a 0? How can I get around this?…

  robertm-772679

  9 replies

  15 years ago

  By: Jeff Moden

• Date conversion problem

  A developer needs to convert a string 'Thu Aug 5 12:14:49 GMT-0400 2010' into a date format. Does …

  gary.morey

  2 replies

  15 years ago

  By: gary.morey

• Concatenating two columns to make a reference and include the date and time

  Hi I would like to create a select statement which abstracts certain information from a table call…

  Jnrstevej

  6 replies

  15 years ago

  By: Phil Parkin

• create table in a script t sql !?

  Hi, I'm a beginner with t sql in sql server 2005. I've try to create a simple script who creates so…

  christophe.bernard 47659

  3 replies

  15 years ago

  By: christophe.bernard 47659

• SQL command

  SELECT RECID,BranchRECID,ScheduleContinueS,EndDate FROM tblBranch_Schedule WHERE DATEDIFF(DAY,Start…

  ying7690

  1 replies

  15 years ago

  By: Jeff Moden

• Replace data in View Query

  Hi folks, I have a strange request which i don't know is possible. Have looked up replace function …

  bpmosullivan

  12 replies

  15 years ago

  By: bpmosullivan

• Alternative to nolock

  I read recently some bad results that can be caused by using nolock. I have quite often used nolock…

  Steve007

  12 replies

  15 years ago

  By: Grant Fritchey

• Row comparision

  Dear All, I have 3 tables having some 10 fields of each i need to compare the each column with anot…

  Gangadhara MS

  2 replies

  15 years ago

  By: Lynn Pettis

• The Row Order Positions and Dynamic CrossTab

  Hello Experts, I have a table named tblKPIResults.Table columns are like below: CREATE TABLE [dbo].…

  erdem1973

  2 replies

  15 years ago

  By: Orlando Colamatteo

• Selecting Rows Based on condition

  Hello all, I've researched a lot but can't figure out a proper way to do this. Please see attached…

  //Ravi

  3 replies

  15 years ago

  By: drew.allen

• Stored Proc. Cycling through database

  I need a procedure to cycle through every database on the server and display the user permissions f…

  kbenevit

  6 replies

  15 years ago

  By: GSquared

• Another Count question

  I have a table listing a bunch of things. I have a sql query I wrote that will give me the data I w…

  lawson2305

  11 replies

  15 years ago

  By: lawson2305

• NOT NULL Constraint Ignored During BULK INSERT

  NOT NULL Constraint Ignored During BULK INSERT I am having trouble with a BULK INSERT that is not g…

  lawrence.raiders

  2 replies

  15 years ago

  By: lawrence.raiders

• Transferring data into from one table to the next

  Hi, I'm trying to transfer data from table A to table B (cant be a temp table must be an actual ta…

  Jnrstevej

  1 replies

  15 years ago

  By: GSquared