SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Need help to write stored procedure with this scenario

  Hello, Let's say we have two tables A and B. Both tables have From Dates .i.e. A.FromDate and B.Fro…

  pushkarna.anuj

  2 replies

  9 years ago

  By: ChrisM@Work

• Multiple row data need to be convert as Coloumn

  HI All, I need to convert the Rows data into column for multiple rows in table. actual data in my t…

  pavanpala.vja

  8 replies

  9 years ago

  By: maruthi.vm

• Maximum number of CROSS APPLY functions

  I can't find a maximum number for CROSS APPLY lines in a single query. I know this has to be doc…

  The Dixie Flatline

  24 replies

  9 years ago

  By: The Dixie Flatline

• Assign result of dynamic sql to variable

  Hello Everyone, I have a problem This is the result what i get from my function ufn_GetHcmDesignFi…

  sanjaydut26

  10 replies

  9 years ago

  By: MMartin1

• while and if condition within a case statement t-sql

  I am trying to implement a while loop and if condition (with a function call) in a case statement. …

  dimpythewimpy

  13 replies

  9 years ago

  By: dimpythewimpy

• Get the salary based on empno and month

  i have table for each month which stores the employee's salary, i need SP which takes the input has…

  GA_SQL

  6 replies

  9 years ago

  By: Eric M Russell

• SSMS 2016 Losing/Ignoring Settings

  Quite often, I will find that when I open SSMS 2016, it has 'Outlining' turned on, even though it i…

  Phil Parkin

  5 replies

  9 years ago

  By: Thom A

• Read data row wise with multiple transaction

  Hi All, I have two table customerorder and customerorderdest. I wrote SP which load data from cust…

  latitiacasta

  8 replies

  9 years ago

  By: Ed Wagner

• T-SQL Stored procedure with multiple if-else conditions

  I have SQL server SP which moves the data from a temporary grid to the main grid. The main purpose …

  dimpythewimpy

  12 replies

  9 years ago

  By: Gail Shaw

• Multi value parameter

  How do i allow user to type in multi value parameter or leave blank then show all records in ssrs? …

  lein

  2 replies

  9 years ago

  By: Luis Cazares

• SSRS report connection Oracle Database as the source

  I was asked to write SSRS Report that connects to Oracle Database and I have not done it before. wh…

  SQL learner22

  5 replies

  9 years ago

  By: MMartin1

• Concatenation of 2 strings sql server

  I am tring to implement a inline tvf to concatenate two strings, the first one in uppercase and sec…

  dimpythewimpy

  9 replies

  9 years ago

  By: drew.allen

• t-sql procedure has no errors but need to be enhanced

  I have written a procedure in T-SQL which returns errorcount based on state code,fiscal year etc...…

  dimpythewimpy

  1 replies

  9 years ago

  By: Luis Cazares

• delete a row in t-sql using inner join with other table

  Hi folks, I am trying to implement a procedure to delete a row from the table which is joined to 2 …

  dimpythewimpy

  2 replies

  9 years ago

  By: drew.allen

• what affects the time it takes to create an index?

  I have an ETL process for which the processing time is varying wildly and with no apparent cause. I…

  dbodell

  8 replies

  9 years ago

  By: dbodell