Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• convert FOR XML as text

  hi, I would like to convert the result of a SELECT FOR XML query into a text field to be able to ma…

  frederic.leurs

  6 replies

  5 years, 9 months ago

  By: frederic.leurs

• MAXDOP vs CPU time and elapsed time

  I recently experimented with MAXDOP using a pretty huge statement. Here is a summary of the results…

  cmartel 20772

  2 replies

  5 years, 9 months ago

  By: Jeff Moden

• Difference between where and INNER JOIN comparing a value

  what is the difference between : Declare Phone varchar(50) UPDATE e Set e.[State]=2 FROM Events e I…

  developerlearn999

  8 replies

  5 years, 9 months ago

  By: Jonathan AC Roberts

• Help required creating an SQL PIVOT

  Hi, Im struggling to PIVOT SQL data in a single table which links to additional tables via the colu…

  Shabbaranks

  6 replies

  5 years, 9 months ago

  By: Joe Torre

• Reusable Variable

  hello, I know there's gotta be a way here, but I'm struggling.  Let's say I have a last name parsin…

  John524

  10 replies

  5 years, 10 months ago

  By: Jeff Moden

• How to know relations between tables after first relations ?

  I have SQL query based on relations between multi tables as followings : select t.PartNumber, t.Co…

  ahmed_elbarbary.2010

  1 replies

  5 years, 10 months ago

  By: Jonathan AC Roberts

• Incorrect Syntax near the keyword select , from

  Hi Below is the query SELECT T0.CardCode as CardCode,T0.CardName as CardName,(Select (Isnull(Sum(Cr…

  jsshivalik

  4 replies

  5 years, 10 months ago

  By: Sergiy

• Question on Index

  Hello, In my Datamart having FactTable like below and planing to create a index for hashkey column …

  sabarishbabu

  6 replies

  5 years, 10 months ago

  By: Jeff Moden

• Issue using ROWNUM

  THi sis just s snippet of the code, i think it is all that is relevant SELECT * INTO #TEMP_Entry FR…

  jeffshelix

  4 replies

  5 years, 10 months ago

  By: Eddie Wuerch

• Multiple Database record purge to 1 datbase table with x column- Query required

  I have Multiple databases ,All the databases same table data is migrating into 1 database same tabl…

  mytesting9

  1 replies

  5 years, 10 months ago

  By: Phil Parkin

• Using stored procedures/dynamic sql to add columns (SOLVED)

  I am trying to use stored procedures to join columns to one table. I am joining more than 1 table t…

  AWOODS8005

  3 replies

  5 years, 10 months ago

  By: AWOODS8005

• Query using fifo

  Hi I have below Data . Using Fifo i want to display output CodeDateDebit AmountCredit Amount…

  jsshivalik

  2 replies

  5 years, 10 months ago

  By: Jeff Moden

• Reset Sequences

  hi, what are the best procedure to automate the  reset of a sequence every  midnight.  

  nrdroque

  1 replies

  5 years, 10 months ago

  By: ScottPletcher

• How to get information about an AG group using powershell

  Hi Experts, Does anyone has a powershell script which displays below information: for a given AG li…

  vsamantha35

  2 replies

  5 years, 10 months ago

  By: Tom Uellner

• revering columns into rows in a specific way

  I have a table id    pid     aid    vid 8    1301    2      10 9    1301    2       11 10   1301   …

  sivaay1223

  3 replies

  5 years, 10 months ago

  By: John Mitchell-245523