SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Is it SQL Server or is it Windows causing the problem?

  Snapshot of a virtual server with SQL Server instance 2008 already installed is copied to alternate…

  steve smith-401573

  8 replies

  13 years, 10 months ago

  By: steve smith-401573

• Sorting query results

  I have a query result which i want to sort in an unusual way or at least a way I have yet come accr…

  sonny.powsey

  10 replies

  13 years, 10 months ago

  By: calvo

• Need help in viewing data as pivot

  Hello everyone. I've been struggling with this procedure for about two weeks now. I have some infor…

  troe_atl

  3 replies

  13 years, 10 months ago

  By: CapnHector

• Help needed transforming source table to result table; DDL attached

  Hi, I revised the data in the source and result tables, as what I originally posted did not accurat…

  Doc Brian

  4 replies

  13 years, 10 months ago

  By: sknox

• Need help grouping data

  This seems like it should be simple, but I have not found the solution. The images attached are vi…

  bcaslow

  10 replies

  13 years, 10 months ago

  By: CapnHector

• Transpose Row into columns

  HI, I have a phoneDetail Table of my customers CustomerIDRowPhone Type DefaultFlgContactP…

  naseer78_pk

  1 replies

  13 years, 10 months ago

  By: spaghettidba

• Cannot start any SQL server services

  Hello, Due to problems on our network we have had to demote a Domain Controller that was running ou…

  office 18838

  13 replies

  13 years, 10 months ago

  By: office 18838

• Sql server 2008 r2 Upgrading to 2012

  Hello, I would like to know if I could use sql server 2008 r2 evaluation edition and practice to up…

  MaxDD

  1 replies

  13 years, 10 months ago

  By: rraja

• Don't get Profiler's CPU figures

  I'm trying to diagnose and fix recurrent slowness in my SQL Server 2008 database. Periodically, gen…

  dzoll

  2 replies

  13 years, 10 months ago

  By: dzoll

• Need Help: Filter records with a combination of values

  Good Day, I have a doubt regarding one of my query statement. My requirement is to get minimum valu…

  iam777here4u

  6 replies

  13 years, 10 months ago

  By: Jim Mackenzie

• SQL Demo App

  Hi All I attended the SQL 2012 launch in Cape Town SA. For the High Availibility Demo, they used an…

  SQLSACT

  7 replies

  13 years, 10 months ago

  By: SQLSACT

• exec ('select * from property') at rm_linked error

  i am using sql 2000 and i am trying to use the following select * from openquery(rm_linked,'select …

  zwheeler

  1 replies

  13 years, 10 months ago

  By: Vedran Kesegic

• openquery and sp_help tablename

  Hi I am trying to do a describe (list column names) for a table. I have to use the openquery syntax…

  zwheeler

  3 replies

  13 years, 10 months ago

  By: Vedran Kesegic

• OLE DB error trace [Non-interface error: OLE DB error trace [Non-interface error: OLE DB p

  {Resolved} HI The following query was working and then the IT maintance team changed the Client (up…

  zwheeler

  3 replies

  13 years, 10 months ago

  By: spaghettidba

• User does not have permissions to view reports

  Hi there. I am trying to setup SSMS and SSRS on my local computer so I can learn how to create rep…

  teahou

  6 replies

  13 years, 10 months ago

  By: Ant-Green