SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Problems to learn...

  Hi Guys... In my earlier post I have come to know about GROUPS AND ISLANDS problem.. Can you guys …

  vignesh.ms

  6 replies

  11 years, 9 months ago

  By: Dwain Camps

• Insert into table with an identity columns from an other table

  Hi Everyone I just created a new table with over 100 Columns and I need to populated just the fi…

  Johnny H

  1 replies

  11 years, 9 months ago

  By: Lowell

• Calculation in sql query ..

  Hi All, we are facing challege to Calculate percentage as highlighted cell in below mention SnapSho…

  getalok_akg

  1 replies

  11 years, 9 months ago

  By: ChrisM@Work

• Need to find continues number ranges

  Hi There, Please consider the following data create table #sampletbl ( Category varchar(100), Num…

  vignesh.ms

  8 replies

  11 years, 10 months ago

  By: Jeff Moden

• Case sensitive pattern matching

  I have a set of data where a column contains titles which have been formatted as follows: "FirstWor…

  andyscott

  11 replies

  11 years, 10 months ago

  By: Sean Lange

• Conversion failed when converting the varchar value 'Coolant Quick Disconnect' to data type int

  I'm having a problem with inserting test data into a table. I am getting the error listed in the ti…

  samuelshirley

  8 replies

  11 years, 10 months ago

  By: samuelshirley

• select house_no order

  i have table coloum like below House_no 3-4-53 . HYDERABAD 3-4-199/1.ASVV 3-4-vizag 3-4-22,nagar 3-…

  shashianireddy

  15 replies

  11 years, 10 months ago

  By: ChrisM@Work

• error in procedure

  hi every one, i was not able to solve pls i need help. while using store procedure in report getti…

  rajnidas.y

  3 replies

  11 years, 10 months ago

  By: rajnidas.y

• Why partition function works for datetime2 but not for datetime1

  Hi all, DECLARE @DatePartitionFunction nvarchar(max) = N'CREATE PARTITION FUNCTION DatePartitionFu…

  mssqlnoob

  1 replies

  11 years, 10 months ago

  By: Gail Shaw

• ORDER BY ROUNDS - Sanity Check

  I got this working but thought I would share it with you all. I have this query DECLARE @Working…

  pjbaratelli

  3 replies

  11 years, 10 months ago

  By: Jason Wolfkill

• find the missing nos in the continues series

  Hi There, CategoryNos A 1 A 2 A 3 A 5 A 6 A 9 A …

  vignesh.ms

  1 replies

  11 years, 10 months ago

  By: Hunchback

• date between in procedure

  hi every one, i need procedure query for two date between fromdate and todate pls. i need help alte…

  rajnidas.y

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• Add Total to the query

  Fi, I have a table with the Group name and Total Count by group . I need to add a 'Total' and summa…

  PSB

  5 replies

  11 years, 10 months ago

  By: Hunchback

• Doubt in error handling

  Hi There, Please find the following query, begin try select top 10* from Sampletable(nolock) end t…

  vignesh.ms

  8 replies

  11 years, 10 months ago

  By: Gail Shaw

• display order by houseno

  i have table house no like this below coloum......... house_no 3-13-10 3-13-200/a 3-13-450/a 3-13-1…

  shashianireddy

  8 replies

  11 years, 10 months ago

  By: ChrisM@Work