T-SQL

• Topics

  Started by

  Posts

  Last post

• DateTime conversion

  Hi, I am trying to convert DateTime type to Double in a query. I want convert 07:30.00 to return 7,…

  eroness

  2 replies

  15 years ago

  By: LutzM

• Datediff on same column

  I am trying to exclude records from my query where the datediff is more than 14 days from the origi…

  asbains8

  10 replies

  15 years ago

  By: asbains8

• Given @ID select all associated IDs in a history table

  Thanks to anyone who can help. --DROP TABLE History CREATE TABLE History ( ID int, Parent_ID int ) …

  Chrissy321

  10 replies

  15 years ago

  By: Sergiy

• OpenQuery with parameters

  I have an OpenQuery Select A, B, C From OpenQuery (MyServer, 'Select A, B, C, From Table_A') As vT…

  Ken at work

  13 replies

  15 years ago

  By: GSquared

• Using a query to return the next Sunday

  I have the following query: select a.MyDate, Sunday = dateadd(dd,((datediff(dd,'17530107',a.MyDate…

  doug 40899

  12 replies

  15 years ago

  By: doug 40899

• Dynamic Columns Names

  Hello I have to create a sp that returns results between an interval of dates, those dates are pass…

  rootfixxxer

  22 replies

  15 years ago

  By: rootfixxxer

• go command

  DELETE FROM emp WHERE job = 'clerk'; go i m getting som erros.i read alomst 10 to 15 of article…

  jay.supersaiyan

  12 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Optimizing dynamic sql query

  Hi, I have this query where I build the where clause dyncamically based on user criteria selection,…

  Senthil T

  1 replies

  15 years ago

  By: WayneS

• replacing long running cursor

  I have one table tbldsrtemplate it has 3 columns namely Id,OrderNo,PhoneID Id is an identity column…

  Sanjay-940444

  15 replies

  15 years ago

  By: Jeff Moden

• Long Running Sproc

  I have the following sproc which I'm running as a job. As of this moment, it's been running since W…

  Chris-717525

  2 replies

  15 years ago

  By: Luke L

• Compute By used with substring

  I'm trying to do a Compute ... By when selecting a substring and the two don't seem to work togethe…

  Andy.Roberts

  1 replies

  15 years ago

  By: Andy.Roberts

• What is Best Way to calculate presence time....

  Dear friends, I have a card time table in DB. it has cardID , TimeofCard and date. I want to calcul…

  ashkan sirous

  15 replies

  15 years ago

  By: ashkan sirous

• openquery and inserting into a tiemstamp column

  Here is my sql insert into dbo.PayerContracts (PUID, ContractID, PyrContractUID, Effective, Termina…

  Mountain Steve

  5 replies

  15 years ago

  By: arpit.decompiler

• Need help for scripting dimension

  This is a current scrip that I use to populate dimension. I run this on Staging database, and if th…

  Sezam

  1 replies

  15 years ago

  By: Sezam

• Blobs

  I have a need to update a document in an existing row of a table which is in blob format (it happen…

  randal.schmidt

  3 replies

  15 years ago

  By: randal.schmidt