SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Causing the Job to fail based on a condition

  I have a package which loads a file to staging table and rename the filename.Now i am trying to wor…

  sarwar.ali490

  6 replies

  8 years, 6 months ago

  By: sarwar.ali490

• The formatmessage function requires 1 to 21 arguments.

  I have trying to use some cursor to read through a header and some rows, but the format message kee…

  ringovski

  2 replies

  8 years, 6 months ago

  By: ChrisM@Work

• Stored Procedure with optional parameters

  Hi, I have a table create table StudentBankDetails (AccountID nvarchar(10) not null , Name nvarchar…

  SQL-Learner

  8 replies

  8 years, 6 months ago

  By: Thom A

• Data file growth events and clustered index

  Hello Guys, I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple.…

  GroverVivek

  9 replies

  8 years, 6 months ago

  By: GroverVivek

• Stored Procedure for Approval

  Hi, I have a table CREATE TABLE [dbo].[Table]( [EmployeeID] [int] NOT NULL, PartnerID] [int] NOT …

  SQL-Learner

  1 replies

  8 years, 6 months ago

  By: Jeff Moden

• Need sql help

  Hi I have a following scenario. File has 4000 records.4(1,2,3,4) sets of records make one final rec…

  sarwar.ali490

  9 replies

  8 years, 6 months ago

  By: sarwar.ali490

• conditional where clause

  I have this problem I cannot solve. In a stored procedure I need to make a select query. A paramete…

  marc.corbeel

  19 replies

  8 years, 6 months ago

  By: MMartin1

• Must declare the scalar variable appears in SSMS and not in VS (SSDT)

  Baffled by this. I'm trying to create a dacpac and I had to add the @LogTable context variable to r…

  Robert Frasca

  5 replies

  8 years, 6 months ago

  By: Robert Frasca

• Mysteriously missing row

  I have a SQL view which vertically sums a few columns containing cash amounts. A matching set of c…

  dougie.lockhart

  5 replies

  8 years, 6 months ago

  By: ChrisM@Work

• Cursors and Dynamic SQL

  Hi, I'm working on a stored procedure that takes two parameters--the names of two databases--one th…

  Mike Scalise

  2 replies

  8 years, 6 months ago

  By: Mike Scalise

• Select query inside procedure taking long time, clustered indexes doing scans, need suggestion

  I have a procedure, which is running very slow, and is being timed out without returning any record…

  sqlandbiuser

  21 replies

  8 years, 6 months ago

  By: whenriksen

• Merge Output statement [Combine Deleted.* with Inserted.*]

  Hi All, I've created a merge statement which Deletes, Inserts and Updates a table, this is working …

  cstrati

  2 replies

  8 years, 6 months ago

  By: whenriksen

• Schema

  I created a user (User1) and Schema (shema1). Made schema1 as defult user schema. Now i cannot acce…

  padmakumark26

  9 replies

  8 years, 6 months ago

  By: whenriksen

• Long running SSIS packages gradually use up memory

  Hi, I am currently using a SSIS WMI task to watch a folder, which runs in a for-each loop, until a…

  kyagi.jo

  3 replies

  8 years, 6 months ago

  By: frederico_fonseca

• Schema

  Is it possible to create sqlserver objects with out schema like Test not like dbo.Test or Function …

  padmakumark26

  5 replies

  8 years, 6 months ago

  By: Thom A