T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL Mail Error

  I'm getting this error: xp_sendmail: failed with mail error 0x80040119 When trying to run this T-SQ…

  Ron-279530

  14 replies

  14 years, 7 months ago

  By: mark.fishlock

• How to query Extended Properties from multiple servers

  I have many SQL Server servers running in our shop. I have populated all the databases with Extende…

  rummings

  1 replies

  14 years, 7 months ago

  By: LutzM

• Invalid usage of the option filename

  Hi, 1. alter database DBMonitor add filegroup DBINDEX01 running successfully 2. alter database DBMo…

  SQL Galaxy

  1 replies

  14 years, 7 months ago

  By: Adiga

• how to replace multivalue

  my bank has change their account from 5 digit to 8 digit. every account has been changed by adding…

  diboy79

  1 replies

  14 years, 7 months ago

  By: Lowell

• Trace Table Query

  HI, select Hostname,SPID, startTime, EndTime, duration from Bribs_Trace_25032011 where loginname='B…

  SQL Galaxy

  7 replies

  14 years, 7 months ago

  By: Gail Shaw

• Order by columns NOT NULL

  Hello Need some help with one problem, i have a small table with 10 columns, the first columns it's…

  rootfixxxer

  9 replies

  14 years, 7 months ago

  By: rootfixxxer

• how to use filed derived from case in group by

  have following query select YEAR, '2', activity_id, CASE [function] WHEN 'OTH_LAB' THEN 'OLB'…

  scott.kitson

  2 replies

  14 years, 7 months ago

  By: Sergiy

• DateDiff with Months datepart - ILLOGICAL

  Hi everyone, We have developed an HR system and I need to determine the months of service of employ…

  anton.marais

  10 replies

  14 years, 7 months ago

  By: GSquared

• how to group datetime into daily/hourly

  If table has column: XDateTime with Values: 1/1/11 1:00 1/1/11 1:15 1/1/11 1:30 1/1/11 2:00 1/1/11 …

  Evolving

  1 replies

  14 years, 7 months ago

  By: andrewd.smith

• TSQL Short Circuiting

  I am trying to short circuit some code to help optimize a query and also to build a dynamic where c…

  Adam Parrott

  3 replies

  14 years, 7 months ago

  By: Bart Duncan

• How to select a list of values without adding into table

  I want to generate a dynamic query by selecting a list of values. The list is generated by a dot ne…

  mail2vz

  1 replies

  14 years, 7 months ago

  By: srikant maurya

• how to find out the sp query in the middle of execution

  Hi, i 'm having sp. it consits of update,select, insert query. i have executed this sp with parame…

  balaji.ganga 68339

  3 replies

  14 years, 8 months ago

  By: george sibbald

• Store Exec result in a variable

  Hi, I am wondering if anyone can help me please. As part of a bigger picture I am trying to st…

  Taggs

  2 replies

  14 years, 8 months ago

  By: Taggs

• IDENTITY_INSERT ON problem

  I am using the following query in sql server 2005 1) SET IDENTITY_INSERT NewDataBase.Extensions.Fie…

  nishant.sagar

  8 replies

  14 years, 8 months ago

  By: Gail Shaw

• Joining two tables via ODBC connection

  Is it possible to perform a multi-database join via an ODBC connection? I'm attempting to join tab…

  Marker

  3 replies

  14 years, 8 months ago

  By: Gosta Munktell