SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Better Way of XQuerying

  Gurus, I am very new to XQuery. Trying to figure out how I can make use of extended events to monit…

  jvkondapalli

  13 replies

  11 years, 2 months ago

  By: SQLRNNR

• Determenistic function returns undetermenistic. Why?

  Hello, Has any idea why this is classed as non deterministic. DATEFROMPARTS(DatePart(yyyy,DATEADD(d…

  Champagne Charly

  7 replies

  11 years, 2 months ago

  By: Champagne Charly

• SERIALIZABLE Transaction Isolation Level Is Not Behaving As I Expected

  I have 2 goals to accomplish: 1. Continuously and atomically migrate data from a primary table to a…

  Gail Wanabee

  10 replies

  11 years, 2 months ago

  By: Gail Wanabee

• DATEDIFF with days and hours

  Hi guys, I am trying to calculate the diffs between to days as a decimal. The hours will an easier…

  Ian C0ckcroft

  8 replies

  11 years, 2 months ago

  By: Ian C0ckcroft

• Collation conflict between SQL 2012 SP1 and SQL 2005 SP3 ?

  I have the following error coming back at me Msg 468, Level 16, State 9, Line 243 Cannot resolve th…

  mtassin

  7 replies

  11 years, 2 months ago

  By: mtassin

• create a function to remove vowels from a given string

  Hi,I am creating a function to remove vowels from a given string but its not working,help me to cor…

  byecoliz

  11 replies

  11 years, 2 months ago

  By: Abu Dina

• Character '*' in float column

  Hi everybody, I m an intern in charge of creating an sql server database for production data. We go…

  ohpenot

  9 replies

  11 years, 2 months ago

  By: ohpenot

• Find First and Last Period without holes

  OK, first post and Subject I can not phrase any better. 1. I have a table where all records have a …

  Umfriend

  5 replies

  11 years, 2 months ago

  By: Dwain Camps

• Dynamically discovering row relationships

  My database structure kind of looks like a tree - a main root table with a primary key, tables with…

  Chad Crawford

  3 replies

  11 years, 2 months ago

  By: Sergiy

• simple MAX question

  Hi there, I would like to find the MAX (score for example) and return who got that score. Imagine i…

  Pete-600513

  5 replies

  11 years, 2 months ago

  By: Sergiy

• What's wrong with my DISTINCT

  I've got another noob question... When I run this query to just grab the emp_id I get 6474 but when…

  momba

  16 replies

  11 years, 2 months ago

  By: Sergiy

• Changing from "hard-coded" to dynamic query

  Hi. My name is Momba and I'm a T-SQL noob.... So I've got the following hard-coded query: select * …

  momba

  21 replies

  11 years, 2 months ago

  By: Sergiy

• Parameterized table names?

  Hey, We're going SQL2012 in a few weeks... does this version support parameterized table names? Cur…

  Raymond van Laake

  4 replies

  11 years, 2 months ago

  By: demonfox

• BCP comma delimited file into a table

  I must be overlooking something really simple, but I am stuck. keep getting the error: Error = [Mic…

  dv_peeking

  5 replies

  11 years, 2 months ago

  By: dv_peeking

• Help with a While/Loop Query

  Good Morning I am new to T-Sql and I have been taske with creating a simple Time table with four co…

  wafw1971

  1 replies

  11 years, 2 months ago

  By: Ant-Green