T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Table updates

  I am trying to update records between two tables given only a file mask to match the two. For examp…

  TeraByteMe

  1 replies

  13 years, 3 months ago

  By: Eugene Elutin

• Query the query result

  Can someone help me with this query. I have the result below, from this query SELECT DISTINCT CAST…

  mgyzelle_valenzuela

  5 replies

  13 years, 3 months ago

  By: Mark Cowne

• Upgraded from 2000 to 2005 and Queries stopped working

  I could use some help, I have a stored procedure which executes 5 update queries. It always worked…

  Ken at work

  4 replies

  13 years, 3 months ago

  By: Ken at work

• How to write a query to pick up only duplicated records like this?

  Hi folks, I have a table Infosys with the following fields: code, name, description There are proba…

  halifaxdal

  9 replies

  13 years, 3 months ago

  By: Eugene Elutin

• Backup only newest database.

  Have an app that creates databases about once every other day a new DB will be created. Once a new…

  Jeff Sims-413169

  4 replies

  13 years, 3 months ago

  By: Jeff Sims-413169

• Update and remove duplicates rows

  Hi, Table "tbl_Reservation" contains below rows. pk_ResId str_tbls ReservationId 1 1907…

  Sagar Sawant

  5 replies

  13 years, 3 months ago

  By: Eugene Elutin

• Remove duplicate rows

  Hi, Table "tbl_Duplicates" contains multiple number of rows. pk_ResId i_Number ReservationId 1 …

  Sagar Sawant

  3 replies

  13 years, 3 months ago

  By: Eugene Elutin

• 3930 Error on SQL Retry after Deadlock

  In a recent flurry of posts, I've attempted to help users of SSC with some of their query questions…

  Dwain Camps

  1 replies

  13 years, 3 months ago

  By: Dwain Camps

• Maintenace Plans using T-SQL

  Hi All We have to create maintenance plan for all the databases on our all the servers in PROD envi…

  Rags-DB

  6 replies

  13 years, 3 months ago

  By: dskinner 44351

• Moving average for the last 4 records

  I have googled this to death and don't seem to be able to nail it so any help appreciated basically…

  frank.pickard

  4 replies

  13 years, 3 months ago

  By: frank.pickard

• Insert into table

  Hi, I have to insert into a table (t2) from other table (t1) with stored proc. I will use insert in…

  thbaig

  2 replies

  13 years, 3 months ago

  By: thbaig

• Update with cursors

  Hi, I have a table which has itemno,itemID,newprice,oldprice,changedate,seqid the data is like t…

  SkyBVI

  7 replies

  13 years, 3 months ago

  By: Jeff Moden

• convert rows into columns

  Hi, How to convert rows into Column using pivot query. I have two tables Table: PS_EMPLOYEES Emplid…

  chandarcst

  19 replies

  13 years, 3 months ago

  By: chandarcst

• Need Help

  Hi, I have a scenario..where an application user can login to the app and can run some workflows/pr…

  jack_kiran

  2 replies

  13 years, 3 months ago

  By: Jeff Moden

• Using COUNT to capture the number of inserted records

  Hello All, Is there any way to simplify this is bit. Can I avoid declaring the @Inserts table varia…

  Chrissy321

  2 replies

  13 years, 3 months ago

  By: Chrissy321