SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Cast SQL Data using XML

  Can some one please tell what below query is doing specially the XML part in nested queries. I have…

  Redmond01

  1 replies

  8 years ago

  By: Thom A

• HOW TO MOVE FILESTREAM's FILES FROM ONE LOCATION TO ANOTHER LOCATION?

  Hi All, I have requirement File table directory need to be changed with another location and do not…

  manavairajan

  1 replies

  8 years ago

  By: Steve Jones - SSC Editor

• Update multiple columns using case

  I have a scenario where i want to update multiple columns of first table from multiple rows of seco…

  ramamurthy.raju

  3 replies

  8 years ago

  By: ChrisM@Work

• How to find Relationship between Tables ?

  Hello I have an SQL database with more than  500 tables.   How to find the rela…

  aloshya

  17 replies

  8 years ago

  By: Sue_H

• Grouping Multiple Lines to One

  Hello, Im trying to combine multiple lines to one like the below example.I looked at piviot but as …

  nicolestrain07

  3 replies

  8 years ago

  By: Jeff Moden

• Having clause

  Hi, Need to add having clause as tansaction_count>1 after group by clause in below query .Transa…

  adisql

  23 replies

  8 years ago

  By: sgmunson

• Alias / pivot issue

  All, Apologises if I'm asking too many questions at the moment. I am reading other posts to contrib…

  as_1234

  4 replies

  8 years ago

  By: as_1234

• Asymmetric key output

  Hi,I need to generate a public/private key for AES256.   This public key will be used in …

  leehbi

  4 replies

  8 years ago

  By: sgmunson

• mapping Redeemed miles to accrual bucket

  There are different accrual dates for miles and each redemption of mile is associated with accrual …

  only.ashish99

  8 replies

  8 years ago

  By: Thom A

• Datafeed

  I have an request to publish some xml for a webdeveloper to use to display data from my amazon host…

  Adam Sandler

  3 replies

  8 years ago

  By: Thom A

• single code

  Hi, Application is using below logic . (sum(CASE WHEN a.RESERVEDOLLAR > 0 THEN a.RESERVEDOLLAR…

  adisql

  1 replies

  8 years ago

  By: Curtis Martin

• format "Floor" should change to Round

  Hi, Need to get the integer values in results.i am using below FLOOR function , but i want to get t…

  adisql

  2 replies

  8 years ago

  By: adisql

• Can we use "Between" operator for a VARCHAR column?

  I have a table with serial # (which is a varchar column). If i have to find a range from this table…

  sathish802004

  2 replies

  8 years ago

  By: whenriksen

• Drop Constraint, Field is not a constraint

  I have a puzzle here.The initial problem is trying to import data from csv file and I haven't been …

  mjdemaris

  2 replies

  8 years ago

  By: whenriksen

• Query Help with 2 tables

  Hello guysI am new to SQL and need help with a query with 2 tables. tblASSESSMENT-AILMENT ASSESSM…

  pandayk 85384

  4 replies

  8 years ago

  By: Thom A