SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• create table in mutiple schemas

  hi, i need to create single table in nearly 50 schemas.can anyone provide automation script for this

  Arjun SreeVastsva

  2 replies

  8 years, 9 months ago

  By: SQLPirate

• SSIS : "The value could not be converted because of a potential loss of data.".

  Dear all, I have a data conversion task and I am getting the following error message: while conver…

  river1

  6 replies

  8 years, 9 months ago

  By: sgmunson

• Need help on extracting to XML format - Solved

  Hi, I have the following table: CREATE TABLE dbo.TimeTable (  WorkDate date,  EmpID int,&…

  dcw8888

  3 replies

  8 years, 9 months ago

  By: TheCTEGuy

• C# SQL CLR to download an *.xlsx file from the SSRS webserver.

  I have recently been given the task to create an SQL CLR stored procedure for SQL 2012, to download…

  vagaines

  2 replies

  8 years, 9 months ago

  By: vagaines

• Identify wrong links inside a hierarchical tree-structure

  Hello, I'm working on an electrical network, edge are link between nodes, insert lines with 'end' a…

  team.bernard

  10 replies

  8 years, 9 months ago

  By: drew.allen

• Find tables

  I have to design a script to find all tables in a database with below criteria.1. Identify all tabl…

  ramrajan

  33 replies

  8 years, 9 months ago

  By: Lynn Pettis

• How to loop through two tables data and fine matched ones using loop

  Good Morning, Create table #tablesrc (VendorId int, vendorname varchar(30), brokerfee int, alianced…

  asita

  2 replies

  8 years, 9 months ago

  By: jcelko212 32090

• using cross apply to find different values trough xml files eficiency

  Hello Experts, I am trying to run the following query:       &nb…

  montserrat.deza

  7 replies

  8 years, 9 months ago

  By: montserrat.deza

• OPEN TEXTFILE FROM T-SQL

  Hai Friends, I have this TXT FILE And I want to create Stored Procedure to insert to TEMP TABLE&nbs…

  Deny_Christian

  14 replies

  8 years, 9 months ago

  By: sgmunson

• How to do this results table - Change Report (not a report though result set)

  I am trying to figure out how to take a results set and have it show differences between row and ha…

  Stephen crocker

  4 replies

  8 years, 9 months ago

  By: Lynn Pettis

• Performance Optimization: Can a varchar(max) be "SPLIT" into 8K chunks at the nearest delimiter AND quickly?

  I've got a scenario where it might be almost impossible to change a data type for an existing store…

  sgmunson

  12 replies

  8 years, 9 months ago

  By: sgmunson

• SSIS : Excel Source (Connect to protected file without password)

  Dear all, I have a excel file that is protected but not with password. Everytime I try to connect t…

  river1

  2 replies

  8 years, 9 months ago

  By: frederico_fonseca

• combine multiple lines into a single line in a column

  I need help pleaseIn my table I have column called LongDescription it is of type ntext. The texts o…

  Nomvula

  3 replies

  8 years, 9 months ago

  By: Avi1

• Help in finding events in two-week period

  Hello everyone, I have an issue in pulling out members having three or more events in a two-week p…

  dhanekulakalyan

  5 replies

  8 years, 9 months ago

  By: Luis Cazares

• SSIS : Excel Data source (cloumn names starting in row 11)

  Dear All, I have an excel file that has header information which is not relevant for me . Column na…

  river1

  3 replies

  8 years, 9 months ago

  By: Thom A