SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• error sql71516

  i work on visual stduio 2013 (C#) i work on school project .My problem when i want create relations…

  worldwithsmile2014

  2 replies

  10 years, 9 months ago

  By: Grant Fritchey

• on delete cascade

  i work on visual stduio 2013 , i have [highlight=#ffff11]Branches table [/highlight] contains ----…

  worldwithsmile2014

  1 replies

  10 years, 9 months ago

  By: Phil Parkin

• Loop through each instance on a server

  I'm writing a query to loop through each instance on a server so I can get each instances relevant …

  SQLHeap

  7 replies

  10 years, 9 months ago

  By: SQLHeap

• creating XML file from T-SQL query

  Hi All, I'm missing something here. What I am trying to recreate is: <value version="5" type="da…

  jeff.farr 88997

  2 replies

  10 years, 9 months ago

  By: jeff.farr 88997

• Sql71516 ,when i want create relationship between tables

  -4 down vote favorite i have table (ClassTab) contains [ClassNum,BranchID,SysNum primary key,StageN…

  worldwithsmile2014

  2 replies

  10 years, 9 months ago

  By: Gail Shaw

• Stuck with LIKE criteria

  Hi I have problem that I can't get my head around. I'm sure there's a simple solution but I can't f…

  jgale 70688

  10 replies

  10 years, 9 months ago

  By: Jason A. Long

• Tough multi-table JOIN query

  Hello, I'm having trouble with a multi-table JOIN statement with more than one JOIN statement. Fo…

  redmittens7

  2 replies

  10 years, 9 months ago

  By: Grant Fritchey

• Stopping TSQL loop at will while preserving successful changes

  Hi, I'm a bit rusty on error handling, so I need some help with below script. SET NOCOUNT ON DECLA…

  sql-lover

  3 replies

  10 years, 9 months ago

  By: sql-lover

• Using sp_executesql in order to call a stored procedure with table type input parameter, from different Database

  Hello, I would like to kindly ask for some help on the following situation. I have 2 databases into…

  SQL_Hound

  2 replies

  10 years, 9 months ago

  By: SQL_Hound

• Select a matching rows which exist in particular string

  Hi, Suppose I have string like DECLARE @strname varchar(50) = 'i_ncm_ai04'; DECLARE @SAMPLE_DATA TA…

  fanindrabhortakke

  2 replies

  10 years, 9 months ago

  By: Phil Parkin

• Rolling 12 month average in DAX or T-SQL

  I'm starting to learn DAX (which is kinda cool!)... but I was wondering about how to do something i…

  pietlinden

  4 replies

  10 years, 9 months ago

  By: Jason-299789

• Case statement on nvarchar with literal string comparrison to varchar

  Hi All, I just wondered if anyone could tell me how SQL 2012 would treat a literal string for a com…

  Thom A

  3 replies

  10 years, 9 months ago

  By: Grant Fritchey

• Number of column mismatch in source file and staging table

  Hi All, I am having one store procedure which use to load data from flat file to staging table dyna…

  vipin_jha123

  2 replies

  10 years, 9 months ago

  By: Grant Fritchey

• Round current timestamp 15 minute

  Declare @dt datetime set @dt = GETDATE() SELECT @dt I want to round the current timestamp to som…

  PSB

  2 replies

  10 years, 9 months ago

  By: PSB

• Supress Results from running a DTS Package via xp_cmdShell within a Stored Procedure

  I've created this stored procedure to run two DTS packages which pull in data from two Excel files.…

  david.c.holley

  3 replies

  10 years, 9 months ago

  By: manub22