Development

• Topics

  Started by

  Posts

  Last post

• Using Excel as A Front End to A SQL Server Database Table(s)

  I'm curious if anyone on the forums here has done this or even read about it; using Excel as a fron…

  YSLGuru

  11 replies

  15 years ago

  By: manub22

• Need to merge multiple rows into one with carriage return

  DECLARE@Sample TABLE ( ID INT , Description varchar(100) ) INSERT@Sample SELECT1234, 'I' UNION…

  tan110

  8 replies

  15 years ago

  By: tan110

• Stored PRocedures vs T-Sql - HELP!

  I have a stored procedure that takes forever to run. In most cases over 30 minutes. If I take all…

  David Paskiet

  11 replies

  15 years ago

  By: j-1064772

• Single SELECT

  declare @t table ( id int , Class varchar(20) ) insert into @t select 1, 'ADS' union select 2, 'g…

  Bhuvnesh

  6 replies

  15 years ago

  By: Bhuvnesh

• trigger taking forever

  This trigger is taking forever and query times out. after update this trigger causes data entry in …

  ekant_alone

  6 replies

  15 years ago

  By: GSquared

• BCP Operation with Currency Codes

  Hello all, I am doing BCP Out operation out of a sql table on SQL Server 2005. I have two columns i…

  Bajrang

  3 replies

  15 years ago

  By: balde

• Warning in Scheduled job

  Hi, When I am trying to run a scheudled job in SQL SErver 2005, getting the below error and job get…

  ekknaveen

  6 replies

  15 years ago

  By: vinurvk

• Select second highest wage

  select * from EmpDetails EmpIDEmpname ManagerId EmpWage 1001Lucky10110051000.00 1002Lu…

  luckysql.kinda

  9 replies

  15 years ago

  By: Subbu S

• Send Mail Task - Record counts + Message Source

  Hello all, If I have posted this question in wrong forum , I apologize. I am creating Flat file fr…

  nshah6

  5 replies

  15 years ago

  By: LutzM

• Query Tweak

  create table #tfield ( id int , Fields nvarchar(200)) insert into #tfield select 1, 'name' unio…

  Bhuvnesh

  2 replies

  15 years ago

  By: Bhuvnesh

• convert a varchar yyyymmdd to yyyy-mm-dd

  I have a stored proc which accepts the parameter. parameter is in varchar type. e.g. sd varchar(8) …

  Karan_W

  2 replies

  15 years ago

  By: SwePeso

• How reformat the date - Newbee

  All, Thank you for your time. Please note, I didn't know if this is the right forum to post my ques…

  nshah6

  14 replies

  15 years ago

  By: WayneS

• Add Space between text and number in same field

  I have data in a column of our database... CHEM0109 MGMT532 MECH5100 TRAN100 TRAN100 BIO1323 ENG121…

  Melissa Manning

  7 replies

  15 years ago

  By: ChrisM@Work

• Create Job and Schedule in MS SQL server 2005

  i m fresher developer and now using MS SQL Server 2005, Any one Can tell me how to create proxy age…

  prafulpankhania

  1 replies

  15 years ago

  By: Bhuvnesh

• Trigger - ntext column value

  I have table "FAQ" which has ntext column. I want to capture raw that has been inserted/updated/de…

  ruchir 71291

  10 replies

  15 years ago

  By: Gail Shaw