T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Dynamic SQL erroring when run using EXEC()

  I have some dynamic code that is using OPENQUERY (tried OPENDATASOURCE as well, same error) to get …

  rpriesing

  5 replies

  14 years, 8 months ago

  By: rpriesing

• Error while using "sp_spaceused" in "sp_MSforeachdb"

  Hi All, I am trying to execute the below script to get all database size in a single temp table. --…

  C.K.Shaiju

  8 replies

  14 years, 8 months ago

  By: C.K.Shaiju

• Need Help - Proportion of reads & writes per day

  Hi, As per below script working fine and display total number of Proportion of reads & writes …

  SQL Galaxy

  4 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• Help with two SQL issues

  The daycare where our kids go recently lost the husband/wife couple that owned and operated the cen…

  lionfan91

  5 replies

  14 years, 8 months ago

  By: ChrisM@Work

• Pivot Problem

  Hi, I have two tables with the following fields. tSite SiteID Int, DevloperID Int ,Site Char tPrope…

  Jay B-317395

  2 replies

  14 years, 8 months ago

  By: Jay B-317395

• Help on a query

  I've the following data Name Date Trend …

  sridharkannan7

  7 replies

  14 years, 8 months ago

  By: Shailesh Agarwal

• Insert random data in an extra column while transfering data (INSERT INTO ..FROM SELECT..)

  We have a table with two columns, we want to transfer this table to another table and add a column …

  Marco

  3 replies

  14 years, 8 months ago

  By: Ninja's_RGR'us

• T-SQL help on updating a table - perhaps (self updation?)

  I have a table with the folowing data record_id ptno Account hosp …

  Guras

  3 replies

  14 years, 8 months ago

  By: Guras

• T-SQL Help needed (Date / Time)

  Hi there Guys / Girls. Im having a issue here, I have the following defined in a Script (report) th…

  gareth.thompson

  4 replies

  14 years, 8 months ago

  By: gareth.thompson

• need help with the code

  Hi, Can any one help me please I have a column called Drive in a table A Contents of the table A ar…

  sql2k8

  9 replies

  14 years, 8 months ago

  By: Jannie-186227

• Load data from Sql Stored procedure to CSV

  Hi Everyone, I am gathering data from different SQL Server tables in my stored procedure and then l…

  krishusavalia

  5 replies

  14 years, 8 months ago

  By: Ron McCullough

• Need help

  Hi, I have below TableA in database under SQL SERVER 2008 R2 CREATE TABLE [dbo].[TableA]( [Serve…

  sql2k8

  5 replies

  14 years, 8 months ago

  By: Jannie-186227

• Turn negative numbers into 0

  Hello all, I have a select statement something like this. SELECT .... COALESCE ( here I take the fi…

  Chrissy321

  12 replies

  14 years, 8 months ago

  By: Paul White

• Aggregate Functions

  Hi Guys, I am trying to get this result, can anyone give a lead or clue how to achieve this? Rep …

  theomed

  10 replies

  14 years, 8 months ago

  By: theomed

• Convert Recursive Stored Procedure to WITH CTE PeopleSoft HCM

  We currently have the stored procedure setup to allow to lookup of a supervisor as of a particular …

  chellweg

  2 replies

  14 years, 8 months ago

  By: chellweg