SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SELECT CASE WHEN to avoid Divide by Zero

  Hello: I think I might be close here, but I need to return 0 if there is division by zero. SELECT  …

  stephen.aa

  6 replies

  5 years, 11 months ago

  By: stephen.aa

• update full path for record

  Hi, I have a table as you can see in codes below. Can you please help me with generating the last c…

  shogunSQL

  11 replies

  5 years, 11 months ago

  By: shogunSQL

• Longest Common Substring in an ITVF

  So as not to hijack an unrelated thread I started a new topic. This is a continuation of a discussi…

  Alan Burstein

  12 replies

  5 years, 11 months ago

  By: Alan Burstein

• File import

  Hi, I first have to say that I am not that knowledgeable on file imports, but this is really beyond…

  itmasterw 60042

  5 replies

  5 years, 12 months ago

  By: itmasterw 60042

• Full Backup Physical_device_name Guid using Native SQL Backup

  I am having issues with creating a backup (manually, via script, via Agent).  The backup file is fi…

  mike 57299

  2 replies

  5 years, 12 months ago

  By: Sue_H

• Split dates based on Start and End Dates

  Hi Team, I'm seeking help on date split, the dates can start between month also. below is the sampl…

  koti.raavi

  11 replies

  6 years ago

  By: Steve Collins

• Merging date based on start and end date

  I have tried to group/merge dates (Min/Max) but due to same data at line 1,2 and 4 , its not workin…

  koti.raavi

  3 replies

  6 years ago

  By: Mr. Brian Gale

• Need help formatting BCP output

  Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select …

  oradbguru

  3 replies

  6 years ago

  By: HanShi

• 'Too many parameters..' error

  Hi Friends, I am a Database-Design architect trying to write some stored procedures. I created an S…

  Arsh

  1 replies

  6 years ago

  By: Arsh

• Nearest Proximity For every record

  Hello! We have a query we are trying to build with a key component. All of our locations have a lat…

  marty.seed

  12 replies

  6 years ago

  By: jcelko212 32090

• Query now runs forever

  Any idea how this might run forever? It is running through 174,000 rows, but that usually takes sub…

  Jim

  9 replies

  6 years ago

  By: vinoth.chinnakulandai

• Large difference in Actual rows vs Estimated rows

  I have a small query between 2 tables that i can't seem to figure out why the actual vs estimated r…

  Jackie Lowery

  10 replies

  6 years ago

  By: Grant Fritchey

• Parse only specific part of XML field?

  Hi I have an XML fieled  that is storing a date and time range , the form its pulling from displays…

  jbalbo

  4 replies

  6 years ago

  By: jbalbo

• ? on Non-Clustered Indexes

  Hi Recently we moved to replication of a DB we receive. I noticed it was slow, long story short, th…

  jbalbo

  5 replies

  6 years ago

  By: jbalbo

• How to get data for 7 days Sunday to Saturday of the previous week

  I am trying to figure out how to get the previous 7 days (Sunday to Saturday) by each Shift 12hrs e…

  Tech

  8 replies

  6 years ago

  By: Jeff Moden