T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Exporting SQL data through OPENrowset into Excel numeric coming across as text

  Hi everyone, I have a stored procedure that gathers data and writes it to an excel file which in tu…

  NICOH99

  1 replies

  15 years, 4 months ago

  By: wz700

• Set Date & Time to Fixed

  I want to setting date&time of sql server 2008 fixed to exec unit test. How to set date &…

  nguyennd

  5 replies

  15 years, 4 months ago

  By: nguyennd

• Change SQL server Dateformat?

  Hi, By default sql server will accept date format of mdy.is it possible to change the format to d…

  kannabiran.b

  2 replies

  15 years, 4 months ago

  By: Paul White

• Capturing the first of two errors

  -SQL Server 2008 SP1- I know why this doesn't work. My question is about capturing the first of two…

  calvo

  3 replies

  15 years, 4 months ago

  By: Paul White

• INNER JOIN and WHERE: what is order execute?

  Hi all I have a SQL and I have a qusetion 😀 SELECT * FROM TABLEA INNER JOIN TABLEB ON ...(ALL join…

  nguyennd

  6 replies

  15 years, 4 months ago

  By: nguyennd

• xp_instance_regread

  I am running the following SQL script against my SQL Server 2008 installation: DECLARE @SQLErrorLog…

  Chris Scott-371584

  1 replies

  15 years, 4 months ago

  By: wz700

• Accounts that don't have prior transactions

  I have an account master table that has a start date, but this start date can be changed at any poi…

  kuyaglenn

  1 replies

  15 years, 4 months ago

  By: Lowell

• Only pull certain characters

  Ok, I have a database that was create way before my name. The person that created the db, put a fi…

  jordon.shaw

  4 replies

  15 years, 4 months ago

  By: Ben Teraberry

• Need Query

  Hi ! guys I have a table Hr.Employee in AdventureWorks database. The image of the Table, bein…

  Shintu

  5 replies

  15 years, 4 months ago

  By: Paul White

• T-SQL Query to Get SUM(COUNT())

  Hi, I am planning to get a report for a table with following table structure: ID Requ…

  jain.ashish21

  7 replies

  15 years, 4 months ago

  By: Paul White

• Need some help with query

  HI, I got two tables Table1: Col1 col2 col3 col4 col5 Table2: col6 col7 col8 n…

  neliii

  3 replies

  15 years, 4 months ago

  By: Paul White

• Dynamic Sql Query problem

  Hi i have query that have input parameters in the where condition of dynamic sql. the problem is, i…

  RockingAdmin

  13 replies

  15 years, 4 months ago

  By: RockingAdmin

• Finding duplicates + an extra column

  Hi, I am stuck with something I think is really simple to solve, but... In addition to the duplicat…

  Svante

  3 replies

  15 years, 4 months ago

  By: Paul White

• Not fully qualifying

  I have a 3rd party app which I have to support. When doing some performance monitoring I noticed t…

  timscronin

  4 replies

  15 years, 4 months ago

  By: Paul White

• Error:

  while executing this query i got an error stating that 'Msg 802, Level 17, State 20, Line 1 There i…

  neliii

  1 replies

  15 years, 4 months ago

  By: SQLRNNR