SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• FOR XML PATH with two root nodes

  I have to generate an XML document that matches the following customer specification: <VENDOR_TE…

  mtlsql

  4 replies

  10 years, 8 months ago

  By: mtlsql

• Locating the mdf,log,and back up files?

  Hi I am trying to locate the mdf,log and bak files but I am not seeing folder (MSSQL10_50.MSSQLSERV…

  SQLPain

  13 replies

  10 years, 8 months ago

  By: SQLPain

• Remove duplicate row

  Hi, I have an issue where I need to remove a duplicate row based on a value. For e.g. if there are …

  pwalter83

  2 replies

  10 years, 8 months ago

  By: Ed Wagner

• SQL Server timing out

  We are getting SQL Server time-outs in one of our SQL Server. SQL Server will not respond to any of…

  SUBRAHMANYA HEDGE

  5 replies

  10 years, 8 months ago

  By: SUBRAHMANYA HEDGE

• SSRS: Catch/Replace #ERROR value in cell

  Hi, all I have tricky tablix, and when I'm doing final TOTAL = sum all cells, it's failes because "…

  mario17

  3 replies

  10 years, 8 months ago

  By: erika.butera

• Unable to shrink transaction log - could not locate files

  Hello folks, OK so I have done as much digging as I can on the net and haven't found a solution to …

  jpomfret7

  27 replies

  10 years, 8 months ago

  By: Jared

• SSIS 2008 r2: Transforming "2015-04-08T18:00:48.000Z" to datetime in SSIS

  Hello, I'm having a hard time trying to transform a date that comes in for import in this format: 2…

  monicaroman

  2 replies

  10 years, 8 months ago

  By: monicaroman

• question about complex 'Mode' (average) calculation

  Hi, I've been asked to find the Mode of the loads on trips we run. So I run a count on the [loads] …

  manssourianm

  1 replies

  10 years, 8 months ago

  By: Luis Cazares

• Parsing out XML on the same level

  Hi I’m trying to parse out <Discharge_x0020_Time> <time> <Hour>11</…

  jbalbo

  1 replies

  10 years, 8 months ago

  By: jbalbo

• Is this query possible?

  Hi, I work for a large transit agency and would like to know if this query is possible (in order to…

  manssourianm

  8 replies

  10 years, 8 months ago

  By: Jason A. Long

• Display the output of table in given format

  Hi Expert, I have a table Test123 having three column EmpID,AttribName,AttribValue. Please run the …

  dineshhp

  6 replies

  10 years, 8 months ago

  By: Luis Cazares

• Recommendation for Memory Allocation - Log Shipping

  I'm log shipping to AWS. Currently, we are shipping from a server with 64 GB RAM to one at AWS with…

  joshdbguy

  2 replies

  10 years, 8 months ago

  By: joshdbguy

• Multiple records on one row..

  Hi everyone I have a table of customer sales (dbo].[CustomerSales] which has a complete record od s…

  ByronOne

  4 replies

  10 years, 8 months ago

  By: J Livingston SQL

• adventure works sample database from microsoft

  I want to practice sql, I know MS has a same database. My questions are.. 1. Do I need to install M…

  wallywizard

  8 replies

  10 years, 8 months ago

  By: wallywizard

• BCP Command with headers

  Hi, I have a table which has few columns as Numeric value. I need to export the ouptut into a csv …

  vikramchander90

  1 replies

  10 years, 8 months ago

  By: Jeff Moden