T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Remove non alphabetic characters but retain (space, single quote and dash)

  Hi, This isn't my function but I've been playing around with it so it does what the title above say…

  Abu Dina

  4 replies

  12 years, 10 months ago

  By: Eugene Elutin

• Why same data/sp in different DB returns result in different order?

  Hi folks, This should not be a difficult question but it is driving me nut! I have two DBs, one cop…

  halifaxdal

  8 replies

  12 years, 10 months ago

  By: Phil Parkin

• Remove redundant data from address column

  Hi, Consider the folllwing two records: if object_id('test') > 0 drop table dbo.test create tab…

  Abu Dina

  16 replies

  12 years, 10 months ago

  By: GSquared

• Trouble with Left Join to Subquery

  I have a table that stores comment codes for a financial institution. When a request is made, a da…

  stphnlwlsh

  1 replies

  12 years, 10 months ago

  By: spaghettidba

• set timeout in openrowset?

  Hi all, Is there a way to set timeout in openrowset? My project requires to connect from a sql serv…

  nzhang6666

  2 replies

  12 years, 10 months ago

  By: nzhang6666

• subquery returned more then one value

  I have this query that used to work just fine..now it's giving me a "Msg 512, Level 16, State 1, Li…

  krypto69

  4 replies

  12 years, 10 months ago

  By: krypto69

• Select from stored proc for many records where single record ID being passed in

  I'm stumped.. I have a fairly complex sproc that is expecting a single record identifier to be pass…

  Robin Riversong

  9 replies

  12 years, 10 months ago

  By: Dwain Camps

• Use Variable as SQL column Name in query

  Hi all, Is it poosible to use a variable as a column name in SQL? EXAMPLE: DECLARE @ColumnName VAR…

  sql_learner29

  4 replies

  12 years, 10 months ago

  By: Lynn Pettis

• Datepart/Cast Issue

  Below is the codes that should pull all the list of Agents that has HPP data for the previous week.…

  skyline_android

  5 replies

  12 years, 10 months ago

  By: Ant-Green

• Trigger permissions

  A customer's database loses data from one specific table when a particular user logs on to the Appl…

  tcarter 24926

  8 replies

  12 years, 10 months ago

  By: tcarter 24926

• The multi-part identifier ERROR

  Hi, i want to write a function which do some calculate something in database. i write it but i am g…

  KcV

  3 replies

  12 years, 10 months ago

  By: Phil Parkin

• Flatten rows in a join

  I have a stored procedure that currently brings back one row per policy number. A new table has bee…

  tyson.price

  3 replies

  12 years, 10 months ago

  By: adrian.facio

• Working Out Exact Age with DateDiff

  Hi There, I am using the following in my SELECT Statement - DATEDIFF (year,dbo.[CORE_CO-PERSON].[…

  TSQL Tryer

  17 replies

  12 years, 10 months ago

  By: Lynn Pettis

• Select from stored proc for many records where single record ID being passed in

  I'm stumped.. I have a fairly complex sproc that is expecting a single record identifier to be pass…

  Robin Riversong

  4 replies

  12 years, 10 months ago

  By: chella.subramanian

• Compare Table structure in two databases in sql server 2005

  Hi, I have several databases which are having same tables and table structures, but recently we hav…

  Mpatel-962775

  13 replies

  12 years, 10 months ago

  By: solanki.ankit4u