T-SQL

• Topics

  Started by

  Posts

  Last post

• update datetime with another datetime field

  i have thousand records in my tablei.e: having_date2/1/2017booking_date31/12/2107 i want to update …

  queenside666

  1 replies

  7 years, 6 months ago

  By: Eirikur Eiriksson

• can I query for a list of linked servers?

  I have a set of related dbs and I need to do some cross-db queries and I want to do them genericall…

  kevinH-1006814

  4 replies

  7 years, 7 months ago

  By: Jeff Moden

• Find Affected Row Count from a Dynamic Query

  Dear Gurus, Following is my procedure CREATE PROCEDURE prg_SHOW_VIEW_RUNNINGTIME ( @strViewName NVA…

  shamshudheen

  13 replies

  7 years, 8 months ago

  By: Gail Shaw

• Exporting A File To A Network or Local Path Using BCP

  A problem might appear if you have more than one instance running on the server or on your local ma…

  Maysarah

  2 replies

  7 years, 8 months ago

  By: Gopi S

• File with Datetime

  Hi, I have a value stored in a column, which is the name of the file and time. e.g  Generic20…

  hoseam

  2 replies

  8 years ago

  By: Jeff Moden

• T-SQL standard way to get current and previous rate situation

  Hi all, can you help out. I would like to get this : ID Current Rate Previ…

  d_martins

  9 replies

  8 years ago

  By: Avi1

• FOR XML - getting a column into a root element attribute

  Greetings!I have a table:CREATE TABLE [dbo].[xdOthPay](    AccountNo  …

  Torin

  2 replies

  8 years, 1 month ago

  By: Mr. Brian Gale

• Problem with NEWID (point of evaluation)

  OK How do I get this code to work? The final 'select' results in different GUID values for [group].…

  pcd_au

  6 replies

  8 years, 1 month ago

  By: Gail Shaw

• Function giving subquery returned more than 1 value, this is not permitted.....error

  I am getting this error:subquery returned more than 1 value, this is not permitted when the subquer…

  Newbi

  6 replies

  8 years, 1 month ago

  By: John Mitchell-245523

• Extract filename from fully qualified path

  I have a varchar(255) column that contains the fully qualified path for a file. For example: C:\Pro…

  Joe B-478020

  10 replies

  8 years, 1 month ago

  By: btzobyd

• How to give Parameter value to the function

  Input parameter is EmpID, it will be inserted from C# application.I am  not  sure on how …

  Newbi

  7 replies

  8 years, 1 month ago

  By: Ed Wagner

• How to give calculated Input paramter in SP when calculation is necessary

  This is my stored procedure for calculating total net pay based on conditional statement. I am tryi…

  Newbi

  1 replies

  8 years, 2 months ago

  By: Ed Wagner

• How to consolidate employees from different databases into single database

  Hello Folks, In one of my project, requirement is to consolidate all employee and their related tab…

  BigB

  1 replies

  8 years, 2 months ago

  By: bonggaspar

• Extracting specific data range

  How can i extract last 12 months from the given dates? I can get the desire result if I give a…

  Newbi

  2 replies

  8 years, 2 months ago

  By: Newbi

• List of scheduled sql jobs

  Hi, Is there any query which can provide me with the list of scheduled job names, run time and freq…

  Ak-763166

  10 replies

  8 years, 3 months ago

  By: Sue_H