T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• RS with two date columns from a single date column

  [not sure that Subject made sense but I couldn't think of a good description for this] I have the f…

  Brian Ki

  9 replies

  14 years ago

  By: Jeff Moden

• retrieve only month and year (last two digits) part of datetime field

  I found this statement on line for retrieving only MON-YYYY portion of datetime field. SELECT CO…

  polkadot

  26 replies

  14 years ago

  By: polkadot

• Run query it takes 16 seconds run stored procedure never finishes

  I have a stored procedure that never finishes. I run the query inside the stored procedure and it …

  pamozer

  14 replies

  14 years ago

  By: pamozer

• BCP cmds BUILDING up in cursor

  I have a cursor which with each loop selects a BLOB and outputs it to a file using EXEC master..xp_…

  Edward-445599

  1 replies

  14 years ago

  By: CapnHector

• Count aggregate rows

  Can someone help me figure out the logic on how to deliver the count after I aggregated the rows? F…

  bostonjoey

  5 replies

  14 years ago

  By: CapnHector

• How to update/delete rows from different tables (tables have relationship)?

  Hello Sirs/Mams, A pleasant day to every one. I have the following tables and a sample dummy data (…

  marksquall

  6 replies

  14 years ago

  By: marksquall

• Handling Multiple transaction

  HI These are the 3 tables •AgencyAccount (AgencyID,AccountBalance) •Ag…

  SQL006

  5 replies

  14 years ago

  By: SQL006

• Multiple Select statements for insert into table

  Hi I have a table like as below : Date StoreName ItemID Lcount 11/22/2011 AAAAA …

  Steve Dell

  3 replies

  14 years ago

  By: vinu512

• Question about EXCEPT statement returning a row it shouldn't

  hi, i'm stumpped as to why an EXCEPT statement is still seeing a difference between two text value…

  digimetic

  1 replies

  14 years ago

  By: digimetic

• String extraction

  string extraction: Hi, 1)IF input = SampleDoc (07) o/p should be sampledoc(07) 2) For '/Customer Se…

  komal145

  10 replies

  14 years ago

  By: komal145

• How to calculate the number of minutes between 1900-01-01 00:00:00 and 9999-12-31 23:59:59

  So I was working with a performance metrics table, trying to load it into the DW. One of the tasks …

  mtassin

  6 replies

  14 years ago

  By: ChrisM@Work

• Quering filestream data

  Hi, Decided to check out the filestreaming feature. Created a copy of the current table replacing …

  Roust_m

  5 replies

  14 years ago

  By: Steve Jones - SSC Editor

• insert missing rows for duplicate tables but different databases...

  i have table in 2 databases. tbl1 f1 char(2) f2 char(6) f3 char(1) f4 char(18) f5…

  roy.tollison

  8 replies

  14 years ago

  By: roy.tollison

• DataAdapter.Update(Datatable) is not working

  SqlCommand cmd = new SqlCommand(); cmd.CommandText = "UPDATE DimRequestMasterTestHS SET [RunningBoa…

  hmsanghavi

  3 replies

  14 years ago

  By: Sean Lange

• Improve Performance of this Purge Process

  This proc has been designed in 2005 but I feel it can be improved. I thought I'd ask for others op…

  MegaDBA

  7 replies

  14 years ago

  By: GSquared