T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Unique Error with convert function in update query

  Hi Friends, I am receiving below error when trying to execute an sql stmnt. UPDATE test1 SET …

  sundeep38

  4 replies

  13 years, 10 months ago

  By: Johan Bijnens

• Query help

  Hi I am trying to get TotalDue by Year,Quarter,Month format from Sales.SalesOrderHeader Table in A…

  Smash125

  15 replies

  13 years, 10 months ago

  By: Jeff Moden

• varchar(max) with QUOTENAME

  When I use QUOTENAME with varchar(max), it is giving me error DECLARE @test-2 VARCHAR(MAX), …

  krishusavalia

  2 replies

  13 years, 10 months ago

  By: krishusavalia

• FOR XML returned as result set instead of one stream. Alternatives?

  Morning all- I have a process that compares two tables (same structure) and finds the differences b…

  Rogman

  12 replies

  13 years, 10 months ago

  By: GSquared

• Does a non clustered index affect the order in which data in a query is returned?

  I am working on a performance project and one of the people I work with is not comfortable adding a…

  Mountain Steve

  6 replies

  13 years, 10 months ago

  By: Gail Shaw

• Most Recent Record

  The following script is returning all PO's within the last eighteen months. How do I filter it down…

  bpowers

  6 replies

  13 years, 10 months ago

  By: bpowers

• How to bring all Ids of my table in Order

  Hey Guy Please i have some request. i have a table Person with (Person_ID, Person_Name and Person_…

  inf1154

  8 replies

  13 years, 10 months ago

  By: Eugene Elutin

• how to get data between dates

  hi this is my DDL. declare @temp5 table ( Id int, FromDate datetime, …

  harri.reddy

  16 replies

  13 years, 10 months ago

  By: Steve Jones - SSC Editor

• How to convert a string into datetime, if fails return null

  Hi Guys, I am having a project need to convert a varchar(255) column from a table into datetime, if…

  mr.zl8888

  9 replies

  13 years, 10 months ago

  By: spaghettidba

• Query using date

  Hi Guys, Kindly please help me to pullout records using the date. I would like to pull out this rec…

  Kaniguan_SQL

  5 replies

  13 years, 10 months ago

  By: Sean Lange

• Using multiple counts to return results

  Hey guys, I have a table (MyTable) in the format; Person (varchar) Company (varchar) Flag (bit) (Th…

  McSQL

  6 replies

  13 years, 10 months ago

  By: McSQL

• T-SQL data retrival query

  Hi, I have scenario where table field names are in short terms. Field actual name is extracted usin…

  hunmunnar

  5 replies

  13 years, 10 months ago

  By: hunmunnar

• Delete data data older than 3 moths from a sql table having more than 16 millions of data

  I need to Delete data data older than 3 moths from a sql table having more than 16 millions of data…

  Giridhar A

  2 replies

  13 years, 10 months ago

  By: Ian_McCann

• To get the result without using joins (not subquery)

  Hi, I have 2 tables with below data and eid is the common column in both tables. I want to retrieve…

  NLV

  2 replies

  13 years, 10 months ago

  By: Gail Shaw

• SSIS

  Hi, I need to create a package in SSIS 2008 for the following task: I have a database name OMB. In …

  dsrapid

  2 replies

  13 years, 10 months ago

  By: Rock from VbCity