T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• MS Project and SQL

  Exists some method to import Ms Project to SQL I try to use the OLEDB but I can retrieve the data f…

  sbarbosa 99824

  1 replies

  11 years, 5 months ago

  By: john.kroneberger

• Pivots

  Happy holidays! I am having issues using PIVOT. I have never seemed to truly understand the syntax …

  DaveDB

  5 replies

  11 years, 5 months ago

  By: Luis Cazares

• Comparing datetime

  Happy holidays! Ok, I have a question that seems basic, but I am having major issues. I need to com…

  DaveDB

  5 replies

  11 years, 5 months ago

  By: Alvin Ramard

• Pivot issues

  Happy holidays! I am having issues using PIVOT. I have never seemed to truly understand the syntax …

  DaveDB

  6 replies

  11 years, 5 months ago

  By: Phil Parkin

• How to Pivot without an aggregate

  I have data like the following format: caseID Code 1 AAA 1 BBB 1 CCC 1 DDD 2 CCC 3 AAA 3 BBB 3 CCC …

  dndaughtery

  14 replies

  11 years, 5 months ago

  By: asheppardwork

• Get the DB Owner through T-SQL

  Hi All, Is it possible to get who is created a database through T-SQL? For Ex, if i see the Propert…

  SqlUser-529296

  7 replies

  11 years, 5 months ago

  By: dkamalkumardba

• Return Child rows on a poorly typed column :)

  I need to return all of the child values for linenumbers in a XML Document that is stored in a tabl…

  dmaslowski

  1 replies

  11 years, 5 months ago

  By: dmaslowski

• rollup with 1stdayofmonth, lastdayofmonth for yearly report

  It's hard to explain this: I have a table like this: value1 value2 date1 date2 & I want t…

  snomadj

  2 replies

  11 years, 5 months ago

  By: Dwain Camps

• Data Insert issue

  Hi, I working on migrating data from one MSSQL instance to another.This will be ongoing process so …

  thbaig

  9 replies

  11 years, 5 months ago

  By: Phil Parkin

• Need help on creating a view

  Happy holiday! I have a question on creating a view: There is a table called Document and there is …

  halifaxdal

  4 replies

  11 years, 5 months ago

  By: Jeff Moden

• Assistance with PIVOT

  I have looked through many examples on the web for PIVOT commands, but am still struggling to find …

  Mark Briscombe

  2 replies

  11 years, 5 months ago

  By: Mark Briscombe

• Rename SQL Server not working

  I used Following Statement to rename the server sp_dropserver 'PHLSQSLDR' sp_addserver 'PHLSQSLTEST…

  skb 44459

  6 replies

  11 years, 5 months ago

  By: lptech

• split column into multiple records based on substring fixed lenght

  I have seen posts to split column into multiple records based on delimited value. I need to split a…

  Richard Cranston

  14 replies

  11 years, 5 months ago

  By: Luis Cazares

• Need help on improving a where clause, thanks.

  Hello all, I have an existing select query with where clause as: and g.ID in (Select ID From Gro…

  halifaxdal

  3 replies

  11 years, 5 months ago

  By: halifaxdal

• Time issues

  Hello, I have a sql query(using 2005). Please see the grid below. I need to only show time on the h…

  DaveDB

  5 replies

  11 years, 5 months ago

  By: David Burrows