T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Join using Charindex -- there's got to be a better way?

  I'm working with healthcare data, specifically with drug data. I've been supplied a reference table…

  peterzeke

  21 replies

  13 years, 7 months ago

  By: Matt Miller (4)

• How to retrieve NEW Jobhistories...

  I am struggling with an overview of jobhistory. I am so far as to convert job_runtime and job_runda…

  FreeHansje

  2 replies

  13 years, 7 months ago

  By: FreeHansje

• Covert style 120 vs 102

  Hi, I am in need of converting a datetime column into character type and then sort it once it is co…

  vick12

  18 replies

  13 years, 7 months ago

  By: vick12

• This query keep on executing , not ending

  Delete from t1 from account t1 join Resource t2 on t1.RID = t2.RID Hi All, The above query is del…

  trarunprasanna

  8 replies

  13 years, 7 months ago

  By: trarunprasanna

• How to get historys of users login in sql server 2008

  Hi all How to get historys of users login in sql server 2008 user login time and log off time Than…

  trarunprasanna

  13 replies

  13 years, 7 months ago

  By: trarunprasanna

• Sorting: Letters before numbers

  Hello, I would like to sort letters before numbers. A letter can appear anywere within the varchar …

  Maxime.Gagne

  15 replies

  13 years, 7 months ago

  By: Usman Butt

• Create table columns from table rows

  Not sure how to create this report most efficiently in SQL Server 2008 R2. I have a table Initiativ…

  tnpich

  4 replies

  13 years, 7 months ago

  By: tnpich

• ROWLOCK problem

  Hello I have a locking issue which I'm trying to resolve, we have a table which gets hit with a lot…

  matthew.peters

  2 replies

  13 years, 7 months ago

  By: bkubicek

• Records deadlock

  Hi all, Currently, I suspect that there are records deadlock issue in my application. So, I use thi…

  Chiang

  4 replies

  13 years, 7 months ago

  By: TomThomson

• Parallel Processing in SQL ?

  Hi, I wanted to know if there is any way in T -SQL where we can execute >2 queries (Insert/Delet…

  SQL_By_Chance

  11 replies

  13 years, 7 months ago

  By: MrBool.US

• Finding "Max" Value from subquery

  Hi all, Kinda stuck on finding a way to optimise this solution. Let's say I have a table which cont…

  kramaswamy

  12 replies

  13 years, 8 months ago

  By: VSP

• Query Help

  create table test (A1 int,A2 int) insert into test (A1,A2) select 100,1 insert into test (A1,A2) se…

  Ashwin M N

  7 replies

  13 years, 8 months ago

  By: VSP

• EXEC xp_cmdshell error : the system cannot find the drive specified

  I have a problem with one of my scripts. I need to put an error log file on a file share. Part of t…

  BenniePielaat

  3 replies

  13 years, 8 months ago

  By: Jeff Moden

• Usign MAX(DATE) function to select only the latest results

  I have a set of data from computer scans that I am storing in a single table. The data is cumulativ…

  c2k

  5 replies

  13 years, 8 months ago

  By: spaghettidba

• Is table variable stored in tempdb?

  hello guys, Is it true that when you created a table variable, and inserted a data on that table va…

  Teemo

  2 replies

  13 years, 8 months ago

  By: Jeff Moden