T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• need help with the code

  Hi, I had SQL Server 2008 r2 Enterprise edition CREATE TABLE [dbo].[TableA]( [Server] [nvarchar](2…

  sql2k8

  3 replies

  14 years, 11 months ago

  By: The Dixie Flatline

• Multiple Full Joins

  Hi I have 2 tables: "Accounts" Table AccountId SecurityId Acct1 Sec1 Acct1 Sec2 Acct2 Sec3 Acct2 Se…

  deepa.devadas

  5 replies

  14 years, 11 months ago

  By: ChrisM@Work

• 2008 TSQL Upgrade Question

  So I found this link (http://technet.microsoft.com/en-us/library/cc721270(SQL.100).aspx) and have a…

  Brandie Tarvin

  5 replies

  14 years, 11 months ago

  By: spaghettidba

• 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, 11 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, 11 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, 11 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, 11 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, 11 months ago

  By: Jay B-317395

• Help on a query

  I've the following data Name Date Trend …

  sridharkannan7

  7 replies

  14 years, 11 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, 11 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, 11 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, 11 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, 11 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, 11 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, 11 months ago

  By: Jannie-186227