SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Can't we rely on execution plan for performance !!!

  Hi all, I have a heap table USER_COUNT_MONITOR with a single column ID and DISTINCT values fro…

  T.Ashish

  9 replies

  12 years ago

  By: Grant Fritchey

• Pivot EDI EAV type table

  Hi all- I'm trying to flatten this table into something like the second table. Any suggestions woul…

  al_nick

  3 replies

  12 years ago

  By: TheSQLGuru

• Max Consecutive Dates Without an Exclusion Date

  Here's one that's been nagging me. I've got two tables, with date "ranges." Table A is an "order" …

  rockfordphile

  7 replies

  12 years ago

  By: Dwain Camps

• Creating a Database

  I am having trouble creating my first database file. Here is the syntax used: CREATE DATABASE Accou…

  Rizk.Christopher

  4 replies

  12 years ago

  By: Rizk.Christopher

• Help On Query

  CREATE TABLE [dbo].[tmp]([msisdn] varchar(20)) DECLARE @intFlag bigINT SET @intFlag = 15210000000…

  vignesh.ms

  5 replies

  12 years ago

  By: vignesh.ms

• Msg 4862, Level 16, State 1, Line 1

  with reference to OPENROWSET (TRANSACT-SQL) http://technet.microsoft.com/en-us/library/ms190312.asp…

  mssqlnoob

  4 replies

  12 years ago

  By: Erland Sommarskog

• EST TO UTC

  Hi I have to create offset to convert my EST Datetime columns to UTC to compare with Utc datetime c…

  sdennis

  2 replies

  12 years ago

  By: sdennis

• send_dbmail recipients from table

  Hi All, my first post here maybe a newby one. Well, i have a table with data as from example below.…

  djmarkoos

  2 replies

  12 years ago

  By: PiMané

• Trying to create line items records from a string

  Hi all- I've got an invoice coming in as a single sting and am trying to figure out how to best bre…

  al_nick

  2 replies

  12 years ago

  By: al_nick

• Msg 2812, Level 16, State 62, Line 2 Could not find stored procedure 'xml_schema_namespace'.

  Hi, my version is sql server is as follow SELECT @@VERSION Microsoft SQL Server 2012 - 11.0.2100.6…

  mssqlnoob

  3 replies

  12 years, 1 month ago

  By: Erland Sommarskog

• Help On Query

  Hi Everybody, Create Table #sample ( Name Varchar(100), Mark1 int, Mark2 int, Mark3 int) insert in…

  vignesh.ms

  7 replies

  12 years, 1 month ago

  By: R. Brush

• Help On Query

  create table Sample (Name Varchar(100), Role Varchar(10)) insert into Sample values ('Vignesh' , 'A…

  vignesh.ms

  11 replies

  12 years, 1 month ago

  By: Naren-274001

• How do I convert column data into row data?

  table gennum tollnum, n1, n2, n3 800123, 1234, 1235, 1236 999123, 9876, 9875, 9874 I want to my…

  gregorykearney

  17 replies

  12 years, 1 month ago

  By: ChrisM@Work

• Help on a complex query that may be easier than what we have??

  Hello all. We have a solution to a problem but think there is a much easier way to do this...I was …

  david.john.gilligan

  3 replies

  12 years, 1 month ago

  By: david.john.gilligan

• How to Split An Incoming Array Parameter from VB6 into SQL Server 2012

  I have a need of passing-in an array of email addresses from a VB6 application to SQL Server 2012 s…

  brad.mccollum

  2 replies

  12 years, 1 month ago

  By: brad.mccollum