Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Not enough disk space error

  Hi,   I keep getting this error message saying that I don't have enough disk space whenever I …

  masterelaichi

  13 replies

  11 hours, 57 minutes ago

  By: Jonathan AC Roberts

• Insert dynamic results into table

  Hi All, I would like to insert the 2nd statement to a table. If I copy and paste to SSMS and run it…

  Saran

  3 replies

  3 weeks, 2 days ago

  By: Ed B

• Table row count for replication

  Hi All, I am trying to get table row count. Looks like it not not moving to next table. Can anyone …

  Saran

  2 replies

  3 weeks, 2 days ago

  By: Saran

• Opening and closing with date filter is not giving me correctly output

  I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value …

  akhterhussain80

  4 replies

  2 months ago

  By: akhterhussain80

• Opening and Closing Value calculate

  Below is data CREATE TABLE #Containerno(CID INT,Contno VARCHAR(50),ConWeight nvarchar(50),Entrydate…

  akhterhussain80

  4 replies

  2 months, 1 week ago

  By: Jeff Moden

• Weekly sales report

  I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate InvDetail…

  mailramk

  4 replies

  2 months, 2 weeks ago

  By: Jeff Moden

• when execute multi query on same time on sql serv using threading get error 40 ?

  I work on unity csharp . i try to execute multi query on sql sever database using async await threa…

  ahmed_elbarbary.2010

  4 replies

  3 months ago

  By: Jeff Moden

• Replace bad characters

  Hi all I need help to replace bad characters with space  in string. select col1, patindex('%[^ !-~…

  Barcelona10

  1 replies

  3 months, 2 weeks ago

  By: ratbak

• Need to find max items within each set

  In batches a certain action is done on each order# following specified sequence. Action is marked a…

  migurus

  6 replies

  4 months, 3 weeks ago

  By: Jeff Moden

• QUERY HELP

  Hi all I have the following table DECLARE @T table (A int ) insert into @T values (1) ,(0) ,(1) ,(0…

  Barcelona10

  6 replies

  4 months, 3 weeks ago

  By: Barcelona10

• Column Pivot

    Hi , I need to do one of these ghastly pivots again... and looking for some help. Here is my…

  gjoelson 29755

  8 replies

  5 months, 1 week ago

  By: Jeff Moden

• Finding a particular date in all tables

  HI all, The famous SearchAllTables proc failed to find date values I know exist in my (DateTime) co…

  JaybeeSQL

  10 replies

  5 months, 1 week ago

  By: Davis H

• How can l group row data by date using window function?

  Hi In my code below the row data are not grouping into month by month name. I want to group row dat…

  Merry_U

  4 replies

  5 months, 1 week ago

  By: jschmidt 17654

• Dirty Reads with Read Committed?

  Hey everyone! I have a SQL agent job that deletes data then inserts data into the same table hourly…

  AVB

  11 replies

  7 months ago

  By: Jeff Moden

• TVF - Table Variable - Query takes 52 minutes...........

  Hello. We have inherited a system and some code and this has been flagged as a performance issue. I…

  SteveOC

  13 replies

  7 months ago

  By: SteveOC