SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Next row begins

  Ok so what I am wanting to do is fill in rows with information that is missing from a file. I read …

  cbrammer1219

  18 replies

  8 years, 4 months ago

  By: cbrammer1219

• Accidentally updated all records

  I have a small table in Dev (contains 38 rows) and I ran an update statement but forgot the where c…

  NewBornDBA2017

  4 replies

  8 years, 4 months ago

  By: NewBornDBA2017

• Windowing function - partition by .. finding the right partition

  Hi, I am trying to get a row_number windowing function to work the way I hope it could work .. Usin…

  bleroy

  2 replies

  8 years, 4 months ago

  By: bleroy

• Basic Trigger Amendment

  Hi folks, Please can you advise me on how to log an old value in a audit table via a trigger. I cur…

  DSC123

  5 replies

  8 years, 4 months ago

  By: DSC123

• How to get top and bottom rows from where condition

  Hi, Create Table Test(Id int,name varchar(80)) Insert into Test Select 1, 'A' union AllSelect 2, 'B…

  Sangeeth Raj

  13 replies

  8 years, 4 months ago

  By: Sangeeth Raj

• time - missing colon :

  i have received a legacy data files from vendor time values are sent without semicolon , can you he…

  mxy

  7 replies

  8 years, 4 months ago

  By: Jeff Moden

• dynamic table creation with set of columns

  Hi , I have a list of records that are actually list of columns and table name that are coming from…

  pnpsql

  1 replies

  8 years, 4 months ago

  By: sgmunson

• SQL mail

  i have a table  test , i need to send an email in HTML format provided in attachment.CREATE TA…

  mxy

  4 replies

  8 years, 4 months ago

  By: mxy

• How to better join my queries and prevent usage of functions

  Hello, I have this structure and these datas :For now, I use sub-queries, like this :Select dem2.Id…

  team.bernard

  5 replies

  8 years, 4 months ago

  By: drew.allen

• Case Statement Help

  CREATE TABLE #INPUT(ADDRESS_1 VARCHAR(200),IS_PO_BOX BIT) INSERT INTO #INPUT Values ('PO BOX 123',…

  koti.raavi

  4 replies

  8 years, 4 months ago

  By: jcelko212 32090

• Stored procedure is a lot slower than standard query

  Hi all I've got a query that runs (outside a stored procedure) in around 8 seconds to return 45609 …

  richardmgreen1

  11 replies

  8 years, 4 months ago

  By: richardmgreen1

• update column based on max date for each employee

  Kinl provide the update query for update column TeamId based on max date for each employee Sce…

  Shanmuga Raj

  22 replies

  8 years, 4 months ago

  By: Jeff Moden

• Is it possible to grant CREATE PROCEDURE with schema limitations?

  Can privileges be granted to create tables in several schemas while limiting the creation…

  Pete Bishop

  5 replies

  8 years, 4 months ago

  By: Pete Bishop

• Get total user session with client IP address

  Hi.The following script fetching number of user session. Is there way to get total user session alo…

  SQL Galaxy

  4 replies

  8 years, 4 months ago

  By: SQL Galaxy

• use exec(@sql) in if exists and get output parameters dynamic sql

  I have result set from @runtimequery like below .I want to set 2 parameters according to the in it …

  mnr123

  4 replies

  8 years, 4 months ago

  By: sgmunson