T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• CTE experssion to seperate comma delimited rows

  Hi, I have a table with data in columns that are delimited by commas . MyTable( gid varchar(5),user…

  EamonSQL

  1 replies

  17 years ago

  By: Kruti Kansara

• Need help in Query

  Hi.. I have two tables Temployee_leave_application, Tleave_type as Below, I need to get the leaves…

  swathi.g

  5 replies

  17 years ago

  By: swathi.g

• Get value from tables

  hi all, i have two tables, one table is contains all tables names,other table contains a…

  RockingAdmin

  11 replies

  17 years ago

  By: RockingAdmin

• Selecting orders based on orderline values

  Hi everyone, I'm in the process of creating some tsql to do various lookups and selections on some …

  timothy.merridew

  4 replies

  17 years ago

  By: tfifield

• select

  I have many databases in my server where the name goes something like mnfkasjh_PA hsdfgadsaffg_CA u…

  Tara-1044200

  5 replies

  17 years ago

  By: bc_

• Script Search

  Forgive me for the xpost. I only hit this and administration. I was wondering if anyone has a scri…

  john-902052

  2 replies

  17 years ago

  By: Paul White

• How try...catch works with nested procedures?

  Hi, I have these two sprocs. --------- CREATE PROCEDURE [dbo].[InnerSproc] AS BEGIN RAISERROR ('E…

  Senthil T

  2 replies

  17 years ago

  By: Mayank Khatri

• case when 'Holy' then 'Cow' else 'Going Nuts' end

  Ok... I've been banging my head against this one all morning and I admit I am stumped. I am develo…

  Nick-957131

  2 replies

  17 years ago

  By: Nick-957131

• Count Performance

  Hi everyone, is there to way improve count performance, i have a simple select count(columnA) from …

  sql_prodigy

  2 replies

  17 years ago

  By: Gail Shaw

• Igor Nikiforov's String Functions

  I've just read this article: http://www.sqlservercentral.com/scripts/T-SQL+Aids/31638/ And the func…

  Rob-350472

  3 replies

  17 years ago

  By: Rob-350472

• The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

  Hi, Whenever i run the below query in sql server 2005 Select * from OPENROWSET('Microsoft.Jet.OLEDB…

  bajoriasatyanarayan

  1 replies

  17 years ago

  By: john-902052

• SQL Query return value in a field if no results found..

  Hi I am looking to return a value in a column of my query if the query returns no results, figuring…

  dodyryda

  11 replies

  17 years ago

  By: The Dixie Flatline

• Change Identity

  I had created a table with primary key named 'qId'. when it was created the identity was 'no' (fal…

  gaurav-1079921

  3 replies

  17 years ago

  By: Joy Smith San

• Problem with Select Statement

  Hi all, I want to set where condition for the select statement only if the param for procedure is …

  ezhil-649633

  5 replies

  17 years ago

  By: Adi Cohn-120898

• Does this query look okay?

  Hi I've got the following query running on a forum and although it seems to run okay it looks a bit…

  Matt-1034261

  10 replies

  17 years ago

  By: Matt-1034261