T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Calculate Elapsed DateTime

  I have an application that handles a work queue. As a case is passed from status to the next throu…

  stphnlwlsh

  5 replies

  13 years, 2 months ago

  By: stphnlwlsh

• replicating data with an ID

  Hi, Is it possible to replicate data in a column and assign a "ReplicationID" for each incremental …

  ismailmallum

  3 replies

  13 years, 2 months ago

  By: drew.allen

• Query Stalls - Upgrade from 2000 to 2005

  Thank you all for your help during this upgrade, yikes!!! I'm getting yet another query that is sta…

  Ken at work

  11 replies

  13 years, 2 months ago

  By: Ken at work

• A strange T-SQL challenge

  I have been asked to do something that I have never done in T-SQL before. In order to describe what…

  meichner

  26 replies

  13 years, 2 months ago

  By: cstevens 101

• INSERT.....SELECT MAX() problem

  Hello everybody, first post here but thanks for all the work behind the site, it has been very usef…

  dbonno

  8 replies

  13 years, 2 months ago

  By: dbonno

• EXEC sp t.C1 FROM Table t

  Hi, Is there a syntax that will allow me to execute a stored procedure for each row of a table (wit…

  jp.v

  12 replies

  13 years, 2 months ago

  By: Eugene Elutin

• Fetch table name,size

  Hi, How can I fetch table name, no of Rows and occupied size in MB from TSQL ?

  thbaig

  11 replies

  13 years, 2 months ago

  By: Jeff Moden

• sql_variant

  I've just seen the schema of an application under development, which is designed to be 'flexible'. …

  David McKinney

  7 replies

  13 years, 2 months ago

  By: Jeff Moden

• UPDATE STATEMENT ERROR (Subquery returned more than 1 value)

  Hi, I have two tables. Table 1 for Head of Family Details and Table 2 for Dependents Details. Fa…

  rajeev_vandakar-782919

  4 replies

  13 years, 2 months ago

  By: rajeev_vandakar-782919

• Sequence Number based on Date and Customer Number

  Hello.. I am trying to add a sequence number to a number of entries in my database. my data looks l…

  8-Bit Ninja

  8 replies

  13 years, 2 months ago

  By: 8-Bit Ninja

• How to get YTD & Quarterly sales??? Any help please?

  how to calculate YTD sales values Here is a sample query and not sure how to get last year sales va…

  gerald.hoole

  5 replies

  13 years, 2 months ago

  By: tfifield

• Display all the users with group descriptions for semicolon seperated values.

  Hi all, Create table UserTable (C101 varchar(100),C8 Varchar(1000),C104 Varchar(1000)) GO insert in…

  Bagath

  3 replies

  13 years, 2 months ago

  By: Bagath

• How to compare results from two queries?

  Hi folks, I have two queries to get results from two different data source, there are lots of discr…

  halifaxdal

  8 replies

  13 years, 2 months ago

  By: GSquared

• Explain Plain

  Hi, I am tuning a query and execution plan is telling me the implicit conversion. I think this conv…

  thbaig

  7 replies

  13 years, 2 months ago

  By: Lowell

• Can i change it in single query - Was pivot table in MS Access

  Hi All, Query in MS Access - TRANSFORM Count(Model2.UNIT) AS CountOfUNIT SELECT MDL.MODEL, MDL.M…

  AMJ-458987

  1 replies

  13 years, 2 months ago

  By: Eugene Elutin