T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• COALESCE returns 8 blank spaces?

  I'm perplexed by a problem I'm having with the COALESCE function. What I'm trying to accomplish is…

  cvandevoorde

  5 replies

  15 years ago

  By: cvandevoorde

• Hiding account number

  I have been assigned a task to change account numbers in two sql tables. This is to accomodate a co…

  krypto69

  9 replies

  15 years ago

  By: krypto69

• Database mirroring?

  Hi, Can we configure the sql 2000 databases in Sql 2005 for database Mirroring ? Subha

  subha.mcts2005

  3 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Database Mirroring.

  Hi, in my environment i need to configure the 50 Databases(including System DB's) for Database mirr…

  subha.mcts2005

  4 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Add to query to show if populated

  I have this query - problem is my results bring back hundreds of tables.. I need to know if the tab…

  krypto69

  4 replies

  15 years ago

  By: krypto69

• Select Rows with same field

  HI, I have the following statement : select CSK_PRODUCTID,csk_quantity,T.loc_code,y.CLC_ID from lv_…

  j.grimanis

  1 replies

  15 years ago

  By: Ron McCullough

• add data separate with a coma in temp table !?

  Hi, I'm a beginner with t sql and sql server 2005.. i must to create a stored procedure who do an i…

  christophe.bernard 47659

  8 replies

  15 years ago

  By: Jeff Moden

• Update with Joins

  Can someone tell me what is wrong ? Im trying to perform an update on a table based only if the cor…

  LOOKUP_BI-756009

  4 replies

  15 years ago

  By: LOOKUP_BI-756009

• Update Table If Record Exists Else Insert ?

  I have a 'Test1' table (with: 'uid' and 'CatFName' and ''CatLName' and 'CatMName' and 'countID' col…

  l_srinuu

  2 replies

  15 years ago

  By: ChrisM@Work

• Convert rows to one column

  I need to be able to do the following: ID,VALUE 1,A1 1,A2 1,A3 2,B1 3,C1 3,C2 Convert the above to:…

  rmdb

  4 replies

  15 years ago

  By: WayneS

• SET Based Vs While loop for repetitive updates

  Hi All, I have to update table A based on some criteria for every record of table B. I am attaching…

  Aparna-1

  2 replies

  15 years ago

  By: Aparna-1

• Further my Sql knowledge, Possible to run such a query?

  Hello everyone, sorry I couldn't come up with a better title. I have ran into a snag and am looking…

  IronSingh

  6 replies

  15 years ago

  By: IronSingh

• Create Table Script

  I have been given a word document that has many table schemas. I have been tasked to create a new D…

  krypto69

  2 replies

  15 years ago

  By: IronSingh

• Need help with GROUP BY

  I have the following table with data. CREATE TABLE #IdTable( [RecId] [int] IDENTITY(1,1) NOT NULL…

  bpar

  2 replies

  15 years ago

  By: bpar

• how many variables can I have?

  Hi Guys, I'm writing a rather big management information system, a monthly stored procedure will be…

  BenWard

  11 replies

  15 years ago

  By: Nadrek