General

• Topics

  Started by

  Posts

  Last post

• Backups - scripts vs app

  Hi, Just a question regarding backups - for a smaller SQL database < 10 gb... would it be genera…

  Jason Toews

  2 replies

  7 years, 10 months ago

  By: Sue_H

• Convert YYYY-MM-DD into Interger in Select, and still recognize INT date in the Join

  Hello, I'm able to convert a yyyy-mm-dd formated DATE column into an Integer, but when I reference …

  quinn.jay

  5 replies

  7 years, 10 months ago

  By: ChrisM@Work

• Left Join bring in data except for FK column, why?

  Hello, I'm needing help, again. I have a stage table, gets populated, has two columns name1, and na…

  quinn.jay

  1 replies

  7 years, 10 months ago

  By: quinn.jay

• Error w/ Auto_Increment for Creating new PK values

  Hello, Below is my code to create a table, and then insert from one table data from another, howeve…

  quinn.jay

  2 replies

  7 years, 10 months ago

  By: quinn.jay

• How to convert varbinary to date

  How to convert varbinary to date with time?I tried like thisSELECT CONVERT(datetime2, 0xB490E37742D…

  ravikaliappan

  11 replies

  7 years, 10 months ago

  By: Thom A

• Date Range in Table A also contained in Table B

  Table A: Has a start date and an end date in it, for example, 01/01/2017 and 12/31/2017.T…

  thelenj

  6 replies

  7 years, 10 months ago

  By: thelenj

• How to I convert this code from Oracle to SQL Server?

  I haven't been able to successfully update this code. OracleREPLACE(TO_CHAR(PRAC.DATE_OF_BIRTH,'MM…

  kawi6rr

  3 replies

  7 years, 11 months ago

  By: Luis Cazares

• The size necessary to buffer the XML content exceeded the buffer quota

  Anyone come across this error before? “The size necessary to buffer the XML content exceeded the bu…

  ldorian81

  1 replies

  7 years, 11 months ago

  By: den(i)s

• Frustrating Programming Policies

  I'd like to have a more light-hearted post this Friday--maybe a bonding experience.  At my pos…

  gdpollock

  7 replies

  7 years, 11 months ago

  By: Jeff Moden

• First try at Pivot Table

  I am trying to create a query with a pivot table which is not something I have done before.The quer…

  mjohnson 71479

  4 replies

  7 years, 12 months ago

  By: mjohnson 71479

• question on best way to set up table or procedure

  I am creating a survey for us to use on our clients. I have my current table structure shown below…

  mjohnson 71479

  3 replies

  8 years ago

  By: mjohnson 71479

• How can I relate retries with the original send in SQL Server Database Mail?

  I'm using SQL Server Database Mail configured with 1 retry. The first send attempt produces a row i…

  chris-howard

  3 replies

  8 years ago

  By: chris-howard

• Change in Salary

  Hello all, Can some guide me please.  I need a script that will show me changes in a person's …

  ajspencer

  5 replies

  8 years ago

  By: Ed Wagner

• Finding the cause of blocking between processes

  We are using the following codeSelectER.Session_ID SPID,ER.Blocking_Session_ID BlockedBySPID,ER.Sta…

  julian.fletcher

  9 replies

  8 years, 1 month ago

  By: julian.fletcher

• Query to fill in parent

  Hi,I have table as follows KeywordID Keyword   IsCoreKeyword keywordorder adgroupid-----…

  CH-328334

  4 replies

  8 years, 1 month ago

  By: CH-328334