T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• sql quotes help

  I want to get quotes after table1 and table2 using similar sql statement select +'sp_helpdb'''+n…

  invaliddba

  12 replies

  15 years, 5 months ago

  By: mister.magoo

• Creating a Group on Data

  Dear Experts, I have data from a single table without an "obvious" relationship but whose data I …

  martin.edward

  5 replies

  15 years, 5 months ago

  By: mister.magoo

• Cursor Tracking

  Hi all, I ran a cursor (XYZ) to delete some records from a table. Can we somehow track cursor that …

  sqlpassion

  1 replies

  15 years, 5 months ago

  By: LutzM

• video viewing query

  Hello, I am working on a report where I have to show which part of a video was viewed mostly by all…

  Shamshad Ali

  14 replies

  15 years, 5 months ago

  By: LutzM

• How to query remote linked server

  I have linked a remote server successfully. Linked server name is "DATA2". Now I need to issue a sq…

  techzone12

  2 replies

  15 years, 5 months ago

  By: techzone12

• UPDATEs vs. Left Joins - which is faster/more efficient?

  Hello, all - I've heard/seen it both ways - updates are faster/more efficient IF you restrict the s…

  dbursey

  10 replies

  15 years, 5 months ago

  By: TheSQLGuru

• Update statement

  Hi, I am having two tables. like below. Table1: Sequence_ididNameKeyitem_namerule_id 1 …

  pols

  2 replies

  15 years, 5 months ago

  By: Kingston Dhasian

• Count query help required

  I have the following table with this structure CREATE TABLE [dbo].[VTRCheckListDetails]( [userid]…

  joshtheflame

  4 replies

  15 years, 5 months ago

  By: joshtheflame

• Need help with query

  Hi Friends, I am stuck with a query and need direction where to go. I have below data in table call…

  sql_learner123

  3 replies

  15 years, 5 months ago

  By: sql_learner123

• XQuery, output the integer that represents a singleton

  Hi All, I'm currently working on shredding a large xml document (around half a GB) into relational …

  Matthew Darwin

  19 replies

  15 years, 5 months ago

  By: WayneS

• Distinct order by

  select distinct ENTRY_DATE from CIRC.SUBS_TAG ORDER BY to_date( ENTRY_DATE, 'mm/dd/yyyy' )ASC I get…

  varunkum

  3 replies

  15 years, 5 months ago

  By: sql_learner123

• Update Depending on RowID Value

  Hello Everyone I am working on an Update statement. That will update a bit column only if the RowID…

  AndrewSQLDBA

  3 replies

  15 years, 5 months ago

  By: AndrewSQLDBA

• How to update multiple column definition in single update statement

  Hi All, Does anybody know if there is a way to update column definition of multiple columns in a si…

  akhandels

  4 replies

  15 years, 5 months ago

  By: GSquared

• Numeric order of a string

  If I'm asked to sort a result set in "ascending order based on the numeric value of a string," does…

  Mike Scalise

  9 replies

  15 years, 5 months ago

  By: Mike Scalise

• SQL 2008 Query - not running

  Hi, This query is running fine with sql server 2000 version, but SQL 2008 data was retrive, please …

  SQL Galaxy

  4 replies

  15 years, 5 months ago

  By: Eralper