T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 1 months ago

  By: marksquall

• Handling Multiple transaction

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

  SQL006

  5 replies

  14 years, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 1 months 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, 2 months 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, 2 months ago

  By: GSquared

• Getting Output value from sp_executesql for XML

  Hi All- I've been trying to solve this one for days with no avail. I'm using sp_executesql to run …

  Rogman

  3 replies

  14 years, 2 months ago

  By: GSquared

• help with SQL query please

  I have table with below structure Create table ClientDetails (ID int, ClientID int, InterviewDate…

  Lucky9

  19 replies

  14 years, 2 months ago

  By: vinu512

• sum operation

  Hi. i have a table ProductTrack.Table is like below: ProductTrackId PK ProductId int SizeI…

  sa.ordekci

  3 replies

  14 years, 2 months ago

  By: Kingston Dhasian

• Getting the error - Transaction count mismatch

  How to fix this error ? Transaction count after EXECUTE indicates a mismatching number of BEGIN an…

  rockybhai

  2 replies

  14 years, 2 months ago

  By: CapnHector

• Update sql database table by Datatable which I have made

  I have made a datatable. Now i want to update that datatable records in existing sql database table…

  hmsanghavi

  2 replies

  14 years, 2 months ago

  By: hmsanghavi