SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• SSIS : Convert MM/DD/YYYY into DD/MM/YYYY

  Dear all, I am receiving from a excel file a string with the format (MM/DD/YYYY). I would like to …

  river1

  7 replies

  8 years ago

  By: Thom A

• Stored Procedure comparison -same SP with text changes

  We have 2 different same stored procedures in 2 different databases .We want to see the changes don…

  mytesting9

  4 replies

  8 years ago

  By: Sue_H

• SSIS : csv File with different structure

  Dear all, I receive from a provider a csv file. Sometimes this file end on column 3 but other time…

  river1

  6 replies

  8 years ago

  By: sgmunson

• Need to access binary data via http connection

  Hi, Sorry if this sounds like a stupid question. I am looking into using SQL Server 2016 as a …

  Paul Giles-Randall

  1 replies

  8 years ago

  By: sgmunson

• All constraints in at table No.of relations- each table wise

  Want to see all constraints in at single or multiple table .We tried below query where i was able t…

  mytesting9

  1 replies

  8 years ago

  By: Sue_H

• Strange COALESCE issue

  All, I think it's correct to provide a table structure for any questions so I'll include that first…

  as_1234

  14 replies

  8 years ago

  By: as_1234

• from today to last one month data

  Hi, Need to select last one month( from today to last 30 days ).  'DATEOFPURCHASE'   …

  adisql

  13 replies

  8 years ago

  By: sgmunson

• Stored Procedure comparison -same SP with text changes

  We have 2 different same stored procedures in 2 different databases .We want to see the changes don…

  mytesting9

  1 replies

  8 years ago

  By: Eirikur Eiriksson

• select count of rows based on condition

  Hi, Need to select count of rows based on codition from a table. Tried with this query , but no luc…

  adisql

  16 replies

  8 years ago

  By: bartedgerton

• Current month to yesterday's date

  Hi Guys,I am using the following code to pull back data based on the start of the month and yesterd…

  craig.jenkins

  27 replies

  8 years ago

  By: sgmunson

• SSIS : Converting from string to be able to store in my DB decimal (28,12)

  Hello, I have an excel which as some columns with money amounts. I am importing as string (500) and…

  river1

  12 replies

  8 years ago

  By: river1

• SSIS : "31,123,322.23" inside excel csv file

  Hello I am using a flat file source to bring data into my SSIS package. This is a csv file, but in …

  river1

  2 replies

  8 years ago

  By: river1

• blank value behaviour ???

  Hi All, Question is related to sql server behavior. Suppose, if I am inserting, blanks into a colu…

  vsamantha35

  4 replies

  8 years ago

  By: vsamantha35

• SSAS Tabular Filtering displayed recordset

  I'm working with a tabular model in SSDT, just wanting to filter a currency column > $0 The only…

  bartedgerton

  3 replies

  8 years ago

  By: pietlinden

• Merge to upsert when target table might have legitimate duplicate tuples

  Am I correct in saying that it's no use to try to use the Merge statement for an Upsert (meaning, i…

  isaac_654135

  9 replies

  8 years ago

  By: sgmunson