SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Islands question - I cannot channel Itzik this morning...

  I have this example DECLARE @StatusTABLE ( AccountINT, AStatusVARCHAR(20), SDateDATETI…

  SQLOzzie

  6 replies

  11 years, 10 months ago

  By: TheSQLGuru

• DateDiff one Date column of First Row and the other Date column of second row.

  Is there a efficient way to compare two different columns of 2 different rows in a data set as show…

  KtmGuy

  4 replies

  11 years, 10 months ago

  By: milos.radivojevic

• By Pass Error While insetion

  Hi all, I have a scenario in which if I do bulk insertion in a table and if any error occurs then …

  kapil_kk

  2 replies

  11 years, 10 months ago

  By: Luis Cazares

• SQL Agent Job

  Hi Got an unusual one here. We've a SQL Agent overnight process; takes about 7-8 hours a night, pro…

  peter.cox

  2 replies

  11 years, 10 months ago

  By: peter.cox

• select from two tables and get count of records in joined table that match

  I am trying to create a query that will give me customer and order information the scenario is this…

  robert.wiglesworth

  8 replies

  11 years, 10 months ago

  By: robert.wiglesworth

• Need query for comma delimited output

  Hi there, Below is the sample data create table #sample (name varchar(100), id int) insert in…

  vignesh.ms

  5 replies

  11 years, 10 months ago

  By: Sean Lange

• More then 8000 chars in a column

  Hi There, Is there any possibility to store more then 8000 chars in a column? please assist...

  vignesh.ms

  1 replies

  11 years, 10 months ago

  By: Lowell

• Need To display data in Blocks (Column name: value )

  Hi All, I want to display data in block. Below is the Create,Insert Script and format of desired o…

  nikki_d

  4 replies

  11 years, 11 months ago

  By: nikki_d

• Padding zeros after decimal

  i have a table like [A]------------- [0]-------------[0.012345] [1]-------------[0.002345] [0.…

  sql84

  4 replies

  11 years, 11 months ago

  By: Jeff Moden

• Need replacement for Triggers

  Please go through the below query... CREATE TRIGGER TRG_UpdateSyncAcc ON dbo.AccountSample AFTER u…

  vignesh.ms

  4 replies

  11 years, 11 months ago

  By: TheSQLGuru

• Optimize PIVOT table to include unlimited column and QTY of SKU - Help

  [font="Courier New"]--Need some help reformatting data in a PIVOT Table or find a better way to dis…

  wit_jp2001

  6 replies

  11 years, 11 months ago

  By: Dwain Camps

• Adding 2 COUNT statements results in heavy query

  These separate COUNT queries are very fast: SELECT COUNT(id) as viewcount from location_views WHERE…

  petervdkerk

  7 replies

  11 years, 11 months ago

  By: TheSQLGuru

• Sometimes values get saved, other times they don't. Can't figure out why?

  This effects both SQL Server 2012 and SQL Server 2008 R2, but I'm posting this here. Some years ago…

  Rod at work

  7 replies

  11 years, 11 months ago

  By: Rod at work

• How to use scalar function without WHILE

  Hey, I have a scalar function, which calculates the similarity of two strings. I use the following …

  vip.blade

  11 replies

  11 years, 11 months ago

  By: ChrisM@Work

• Multiple Records queried into Single Record

  I have 2 tables People and Scores. A person might have 1-5 scores (unknown at time of Query). I wou…

  Terry Bottorff

  8 replies

  11 years, 11 months ago

  By: Sean Lange