Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• View works for me ...but doesn't return results for a user in SSMS but no errors

  Hi I have this view to check if a job is running:   SELECT job.NAME ,job.job_id ,job.o…

  krypto69

  3 replies

  7 months, 4 weeks ago

  By: krypto69

• “user_scans” of table “sys.dm_db_index_usage_stats”

  I am trying to find answer to the below. What exactly the scan means for the field "user_scans" bei…

  Meera

  3 replies

  9 months, 1 week ago

  By: Grant Fritchey

• Outer join table where there is 2 foreign keys to join

  I am asked to provide a date in a query from a table that may or may not have a record.  Thus the …

  mjohnson 71479

  3 replies

  12 months ago

  By: ScottPletcher

• Reg: Dynamic SQL Query from row to column in SQL server

  Dear all I have following scenario change the rows to column in dynamically. I have tried  But not…

  vs.satheesh

  8 replies

  12 months ago

  By: Phil Parkin

• How to suppress the info of queries execution in Stored Procedure.

  I inherited the Stored procedure the whole purpose of it is to populate our catalog table by data f…

  rkordonsky 63916

  9 replies

  1 year, 1 month ago

  By: rkordonsky 63916

• 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

  1 year, 3 months 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

  1 year, 4 months 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

  1 year, 4 months 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

  1 year, 5 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

  1 year, 5 months 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

  1 year, 6 months 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

  1 year, 6 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

  1 year, 7 months 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

  1 year, 8 months 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

  1 year, 8 months ago

  By: Barcelona10