T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Error converting data type varchar to numeric.

  hi am geting Error converting data type varchar to numeric. SELECT E.CRT_Cod,C.CP_Nm,R.Ret_MDN,E.Re…

  sabareeswaran.sundram

  4 replies

  14 years, 7 months ago

  By: LutzM

• Error converting data type varchar to numeric.

  Select A.CRT_Cod,A.CP_Nm,A.TSM,A.TSM_No,A.Lead,A.DSR_NM,A.DSR_no,A.Business_category as 'Trans_Typ'…

  sabareeswaran.sundram

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Write query results in tab delimited file and push the file to ftp

  Hi, How do I Write query results in tab delimited file and push the file to ftp on daily basis …

  ramadesai108

  1 replies

  14 years, 7 months ago

  By: SQLRNNR

• random select

  I would like to know how to select random records from data in both sql server 2005 standard editio…

  wendy elizabeth

  4 replies

  14 years, 7 months ago

  By: Orlando Colamatteo

• Current job name from within scheduled job

  Let me explain what I hope to be doing. I plan on using the sp_send_dbmail stored proc to send out …

  JustMarie

  3 replies

  14 years, 7 months ago

  By: Orlando Colamatteo

• Ugent!!! Why sp works but failed after it is packed into a job? Thanks.

  I have a sp, tested with no any problem, I packed it into a job, failed with the following reason: …

  halifaxdal

  10 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Single quotemark in fieldname in my Access LinkedServer

  Hello there, goodmorning, Currently I am involved in a project moving an Old MS-Accessdatabase to S…

  yuri.eijk

  7 replies

  14 years, 7 months ago

  By: Phil Parkin

• Indexes issues

  Hello I have a query hitting my database quite frequently which performs 2 index scans on the same …

  matthew.peters

  3 replies

  14 years, 7 months ago

  By: Gail Shaw

• Removing duplicate records from a table

  I want to Remove the Duplicate Records from a table without using any temporary table. Table struct…

  gaurav-404321

  3 replies

  14 years, 7 months ago

  By: Rob Schripsema

• Regarding Views

  hi friedns, I have one situation...we have here more then 250 views directed to database db1 like…

  mithun.gite

  7 replies

  14 years, 7 months ago

  By: KoldCoffee

• Data loss from trigger firing before its previous execution is done.

  I have a trigger set to populate a project list - determined by a comma-delimited string of IDs (ci…

  Mindy Hreczuck

  5 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• Conditionally reorganize indexes for all databases

  Hi All We're currently using this script to conditionally reorganize our indexes in SQL Server 2005…

  Phineas Gage

  11 replies

  14 years, 7 months ago

  By: TheSQLGuru

• How to create a comma delimited string

  Hello, Here is a sample data I am using. CREATE TABLE #temp (ae1 varchar, ae2 varchar, ae3 varch…

  marty.seed

  4 replies

  14 years, 7 months ago

  By: marty.seed

• Insert into table using XQuery and XML document

  I have the following xml document. DECLARE @doc XML SET @doc = N'<?xml version="1.0" encodi…

  qbrt

  6 replies

  14 years, 7 months ago

  By: mister.magoo

• Need To Pull Data from the Middle of a Column

  I have a table with an order description, order number, and order line in one column. --===== If th…

  ducksql@gmail.com

  7 replies

  14 years, 7 months ago

  By: WayneS