SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Query

  Hello I have been asked to write a query on SBO. It requires (among other) a reference to a budget,…

  carin 77561

  6 replies

  11 years, 2 months ago

  By: ZZartin

• How index helps for join in sql server?

  Hello Everyone, How index helps for join in sql server ? when we join two tables how the index took…

  vignesh.ms

  2 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Which is the best method to go with?

  Hi There, Please go through the following query, and help me to understand which one is efficient a…

  vignesh.ms

  3 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Odd behavior from SUBSTRING/CHARINDEX with CHAR(10) and CHAR(13)

  Hello, I realize I'm breaking the first 5 or 6 SSC rules by not posting sample data, but this is an…

  sqldriver

  2 replies

  11 years, 2 months ago

  By: sqldriver

• Query if extract failed and/or succeed the same day

  We extract 10k tables every night and I have a table that keeps track of ETL tables that fail or su…

  smitty-1088185

  5 replies

  11 years, 2 months ago

  By: LinksUp

• Bulk Insert using UNC path of a Filetable Directory

  Overall goal: Write a Bulk Insert statement using the UNC path of a filetable directory. Issue: …

  Louis Albrant

  13 replies

  11 years, 2 months ago

  By: Dan Guzman

• need table returning function with input table name as parameter

  Hi folks, I've done some searches on here and on the web, and I'm still confused. I'm using SS 201…

  DSNOSPAM

  19 replies

  11 years, 2 months ago

  By: DSNOSPAM

• get colums from queries

  Hi All, I have 3 different queries with 3 different where conditions ,then i want to get all those …

  kriskumark96

  12 replies

  11 years, 2 months ago

  By: MMartin1

• Get top 1 row in group

  Hi, Please help me write the T-SQL to get the top 1 row in the group. Thanks Sample data Stack Re…

  vee_jess

  6 replies

  11 years, 2 months ago

  By: Sean Lange

• T-sql puzzle

  Hey guys, I'm fairly newbie with SQL and have been struggling with this used case. I would appreci…

  DataEnthusiast

  2 replies

  11 years, 2 months ago

  By: DataEnthusiast

• PRINT STATEMENT

  Hi, Can anyone please help me how to write query with PRINT Statement for below query. WITH CTE1 AS…

  monilps

  1 replies

  11 years, 2 months ago

  By: Phil Parkin

• dynamic sql inside cursor syntax errors

  Hello, I have this original script to script out user permissions from particular user database. …

  dallas13

  4 replies

  11 years, 2 months ago

  By: dallas13

• SQL Replace function

  I am trying to replace names found in 'xml' fieldname as hyperlinks, by matching with the names in …

  missy786

  1 replies

  11 years, 2 months ago

  By: Jack Corbett

• SQL Server Merge Multiple Rows

  I have the following problem and it seems simple but I am stuck. I have resulting rows from a query…

  beau3jjp

  4 replies

  11 years, 2 months ago

  By: serg-52

• ODBC Connectivity Issue

  Hi, Recently we migrated a database to SQL Server 2012 version and configured mirroring on it as pe…

  balasaukri

  7 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson