SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Alter query to avoid hardcoding

  Hi Team, using below query to raplace the string values (REPLACE abc with T1223), how to use the qu…

  Minnu

  4 replies

  10 years, 9 months ago

  By: Minnu

• Is this possible in T-sql

  I have a stock Table with a FIFO QUE data which is : delimited. To complicate things the colon spli…

  MikeTomkies

  13 replies

  10 years, 9 months ago

  By: Ed Wagner

• SQL Cursor Logic

  Hi Team, Using below table. UserStrg_1Strg_2 -------------------------------- MiamiTestTest_1 M…

  Minnu

  1 replies

  10 years, 9 months ago

  By: Jeff Moden

• Insert Clone copy of records

  Hello All, I am having three table tblTest,tblTestQuestion,tblAnswers Each test can have multiple q…

  VijayLaxmi

  5 replies

  10 years, 9 months ago

  By: Jacob Wilkins

• SQL Cursor to display result in single transation

  Hi Team, Here the SELECT query is fetchign the records corresponding to ITEM_DESCRIPTION in 5 separ…

  Minnu

  1 replies

  10 years, 9 months ago

  By: Luis Cazares

• Access to Create/Amend/Delete Tables in a named ( none dbo schema )

  Hi, I have a 3rd party product that has tables and object within the dbo schema of a given database…

  Adrian Sims-154382

  2 replies

  10 years, 9 months ago

  By: Adrian Sims-154382

• Select quert with REPLACE function

  Hi Team using below code to replace the city names, how to avoid hard coding of city names in below…

  Minnu

  3 replies

  10 years, 9 months ago

  By: ScottPletcher

• When Invoice contains multiple values Set value equal to a value

  All I have a table full of invoices and in that table there is a field named HCC. An invoice can co…

  brianconner

  4 replies

  10 years, 9 months ago

  By: Dwain Camps

• Status Movement

  Good day good people Am working on the 2 datasets. The first keeps the status history all the accou…

  Olalekan Adewale

  1 replies

  10 years, 9 months ago

  By: Dohsan

• Working with Triggers, stored procedures.

  Hi, I have a problem working with below mentioned situation. Please help me out with this. I have t…

  narengc

  4 replies

  10 years, 9 months ago

  By: Michael L John

• XML Format

  I'm just doing practice questions for MCSA and came across this: Q: Return query in this format: &l…

  Blackdog

  1 replies

  10 years, 9 months ago

  By: SQL aus HH

• Issues With Database Bulk Update

  Dears, i am stuck with an issue on our database servers, we are doing synchronization services that…

  aboodm

  1 replies

  10 years, 9 months ago

  By: aboodm

• Creating a pivot like table result

  I have 2 tables (#raw1 & #raw2). Each has a year (yr) and month (mnth) and a count (cnt1 / cn…

  mike 57299

  1 replies

  10 years, 9 months ago

  By: Alan Burstein

• Problems with XML Date Time Conversion

  Okay, I'm banging my head against the wall on this one. I am querying XML data, which the data and…

  jordon.shaw

  11 replies

  10 years, 9 months ago

  By: Eirikur Eiriksson

• tsql

  1Green 2Yellow 3Yellow 4Pink 5Green 6Yellow 7White 8White 9Pink I want following output 1…

  meerack11

  7 replies

  10 years, 9 months ago

  By: meerack11