T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Msg 241 Level 16 (Conversion failed when converting datetime from character string)

  Hello everyone, I'm stumped right now. Here is the deal, I need to replicate data from one table t…

  David F

  19 replies

  13 years, 1 months ago

  By: Sean Lange

• Group by vendor & rate in po where vendor or rate changes

  --Table CREATE TABLE #PUR_HIS1 ( SL_NUM INT, VENDOR_CODE CHAR(18), VENDOR_DESC VARCHAR(55), PO_NO …

  goenka.vishal

  3 replies

  13 years, 1 months ago

  By: Dwain Camps

• Time and Attendance need help pls...

  Please can someone help me.... I have a query which query the min and max of time in and out...the …

  sharon_sfy2k

  11 replies

  13 years, 1 months ago

  By: sdhanpaul

• Not generating run time

  I have the SQL, listed below, what I would like to do is to get the fractions down to two places (0…

  dwilliscp

  5 replies

  13 years, 1 months ago

  By: dwilliscp

• how to insert image in sql server 2005

  how to insert image in sql server using sql query

  sanjay.dakolia

  1 replies

  13 years, 1 months ago

  By: Sean Lange

• T-SQL to call the SQL Parse "function"

  Does anyone know if it is possible to call SQL Server's Statement parser (syntax checking) via T-SQ…

  Jason Selburg

  18 replies

  13 years, 1 months ago

  By: Jeff Moden

• trying to export to .CSV with comma delimited AND double-quotes

  What I have is a simple table (in SQL 2005) that provides input to a mapping program. It has four c…

  hugh.hemington

  11 replies

  13 years, 1 months ago

  By: Phil Parkin

• SELECT DISTINCT AND ORDER BY CASE

  Hi i am trying to use select distinct with order by case but getting an error like "ORDER BY i…

  28.kanikasoni

  7 replies

  13 years, 1 months ago

  By: ken.willekens

• union and order by

  I had used 5 queries and union their result then appllied order by clause .but order by doesn't wor…

  28.kanikasoni

  1 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Getting Output value from sp_executesql for XML issue

  Hi, I am trying to get an xml blob into a var from dynamic sql. However, whenever I run this: DECL…

  lassell

  3 replies

  13 years, 1 months ago

  By: Dwain Camps

• Insert into stmt with parameters

  Hi, I have been checking all over for this solution and I know the follow: Server SQL will not refe…

  sdhanpaul

  3 replies

  13 years, 1 months ago

  By: T_Dot_Geek

• Job Instance ID

  Does anyone know if there is a function [like getdate()] that you can use to get the Job's instance…

  dwilliscp

  1 replies

  13 years, 1 months ago

  By: Sean Pearce

• try..catch and union all

  Hi all, I have the following construct: select name, value from ( select name, value from view1 …

  RightOnTarget

  6 replies

  13 years, 1 months ago

  By: Dwain Camps

• Calculating Yield

  Hi all, I'm running into an issue calculating yield. ;with totalcount as ( select cast(count(sn) as…

  kabaari

  5 replies

  13 years, 1 months ago

  By: kabaari

• exec @sql

  I'm trying to run a simple dynamic sql statment but am receiving the error below. Do I have to cre…

  Marcus Farrugia

  4 replies

  13 years, 1 months ago

  By: Marcus Farrugia