SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• getting mismatched data instead of having same data

  Hi while working with data comparison I faced an issue of mismatched data instead of having same da…

  nikki_d

  3 replies

  11 years, 10 months ago

  By: nikki_d

• Data migration from Excel to SQL

  Please find the script for migration. Here I have attached two supporting documents. One is databas…

  palaz424

  2 replies

  11 years, 10 months ago

  By: palaz424

• Bad performance when using parameterized query with like in where clause.

  Hi all, from MS Dynamics NAV 2013 I get a lot of querries that have a where clause like this: where…

  sqlTobi

  15 replies

  11 years, 10 months ago

  By: sqlTobi

• dropping rows with a duplicate column name

  I have a query that produces unique rows. However, some of the unique rows have the column called …

  ccmret

  1 replies

  11 years, 10 months ago

  By: SQLRNNR

• querry get data in double codes in string

  Hi all i have data like this "entitlementwrapper" : [ { "Type" : "Factory Warranty", "Dat…

  mpradeep23

  11 replies

  11 years, 10 months ago

  By: sqldriver

• foreign key references multiple tables

  Hi there, Is there any possibility to create a foreign key references more than one tables. say for…

  vignesh.ms

  8 replies

  11 years, 10 months ago

  By: RonKyle

• SQL Server Function: Cursor or Tally Table; which to use, HELP

  Hello I have been given a task which I’m having some trouble which getting my head around the logic…

  Knives85

  17 replies

  11 years, 10 months ago

  By: Knives85

• Self Join - Examples

  Hi There, Please give some examples for more understanding on self join thanks

  vignesh.ms

  2 replies

  11 years, 10 months ago

  By: Eugene Elutin

• Schema design for immutable FK data vs user created FK data

  Hi all, Just after recommendations on the best way to design a foreign key table that, for example,…

  cppprogrammer

  2 replies

  11 years, 10 months ago

  By: cppprogrammer

• Insert multiple rows in a table with a single select statement

  I've had some SQL experience, but only through a few classes in college. So I apologize for my lack…

  sKreetz!

  6 replies

  11 years, 10 months ago

  By: Nevyn

• Query from a list in an excel file

  I have database tables for Stores StoreId, Name Products ProductId, Name Transactions TransactionId…

  SqlServerNinja

  9 replies

  11 years, 10 months ago

  By: Welsh Corgi

• Query to consolidate data from tables

  I am struggling with a somewhat tricky query. I need to make a query that counts installed develope…

  stento

  4 replies

  11 years, 10 months ago

  By: stento

• Import csv with SSIS error

  I’m trying to import data from CSV to SQL Server 2012 and I’m using SSIS 2012. CSV file data: Field…

  parky.chan

  1 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• XML data retrieval

  Hello all I am trying to get data from an xml file and I cannot figure out what's wrong. Can you pl…

  alexandru.tero.toth

  7 replies

  11 years, 10 months ago

  By: alexandru.tero.toth

• Can i do this (pivot)

  Im not even sure this is possible. I have a data set that is pulled into a excel spread sheet and p…

  ps_vbdev

  3 replies

  11 years, 10 months ago

  By: Luis Cazares