SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Counting with Where clauses

  Hi All, It's time for my weekly post and cry out for help. I do really appreciate your help. Belo…

  TSQL Tryer

  5 replies

  11 years, 3 months ago

  By: TSQL Tryer

• Need to format value of a column and insert it into another column of the same table.

  A column of a table has values in the format - 35106;#Grandbouche-Cropp, Amy I need to format the c…

  thinkastrategy

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• Pivoting Question

  Lets say you have address information (ie... Address, City, State, Zip) for one contact lets call …

  charlesafarr

  1 replies

  11 years, 3 months ago

  By: Luis Cazares

• COMPLEX DATA QUERY

  --Here is the data I am working with: CREATE TABLE COORDBEN( ID INT IDENTITY(1,1), MEMNBR VARCHAR(1…

  Nilssond

  1 replies

  11 years, 3 months ago

  By: Sean Lange

• Getting @@ServerName into a variable or table

  Hi, I am trying to store the server name from a query into a variable or table. Declare @ServerName…

  hurrican3p

  10 replies

  11 years, 3 months ago

  By: hurrican3p

• Table to Table Validation

  Hi All... I am not even sure what to search under so here is the question: Setup: PStat * PStat_id …

  mike 57299

  2 replies

  11 years, 3 months ago

  By: ScottPletcher

• XML Shredding / parsing

  Ok I am faced with working with XML on a regular basis, which is fine. So I am presently having to …

  Jeffery Williams

  7 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• linked server - delete hangs

  Hi, I have a procedure on SQLSERVER DB1 where i insert into few tables on SQL SERVER DB1 and delete…

  AVDR

  2 replies

  11 years, 3 months ago

  By: Sarah Wagner

• Using COALESCE and also trying to multiply and divide

  Hi, Need to multiply the following by 12 then divide this by 52. ,COALESCE(CTAX.[NET-AMT],0)+COALE…

  TSQL Tryer

  46 replies

  11 years, 3 months ago

  By: Jeff Moden

• t-sql to call a split parameter function

  In t-sql 2012, the followinng sql works fine when I declare @reportID. IF @reportID <> 0 BEG…

  wendy elizabeth

  2 replies

  11 years, 3 months ago

  By: Eirikur Eiriksson

• TSQL Not doing what I expect

  I'm trying to run this TSql so I can enable/disabled jobs in MSDB: use msdb; go select 'exec dbo.sp…

  SQLGlenn

  5 replies

  11 years, 3 months ago

  By: SQLGlenn

• Need help for complex query

  hi all, SELECT debit.ACCOUNT_NO, debit.Serviced_Amt,credit.Tran_Amt,credit.Serviced_Flag FROM tbl_I…

  rajnidas.y

  5 replies

  11 years, 3 months ago

  By: Lynn Pettis

• Table Partitioning

  Hi, We have a database and have 6-7 growing tables. All the tables have Primary and foreign key rel…

  ramana3327

  16 replies

  11 years, 3 months ago

  By: ramana3327

• Trying to get results in a specific order

  Hello all. I have a simple example of what I am trying to do. Here is some code to make a quick tab…

  robert.wiglesworth

  7 replies

  11 years, 3 months ago

  By: Sean Lange

• How to troubleshoot and solve Index page locking or/and row locking

  Hello All, I am facing a lot of page and row locks on the indexes created for a specific table and …

  angelo.dasilva

  4 replies

  11 years, 3 months ago

  By: i_amhers