SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Why is my SELECT DISTINCT faster than a normal SELECT?

  Hi I have 2 queries selecting from the same view. Both queries return the same amount of rows (3171…

  SpitFireXVII

  1 replies

  14 years, 9 months ago

  By: Johan Bijnens

• Getting the query based on Cols

  Please provide a query which would be similar to......which would be helpful for table containing m…

  pawan.boyina

  7 replies

  14 years, 9 months ago

  By: Reo

• Subtotals using Custom code SSRS 2008

  Hello, I am having a problem which started after switching to 2008 Reporting Services. We have a c…

  jklein-783185

  1 replies

  14 years, 9 months ago

  By: kissan35

• Which Reporting tool supports adhoc reporting?

  Hi All, Our client needs a reporting tool which allows the end-users to create adhoc reports Backen…

  Suresh B.

  4 replies

  14 years, 9 months ago

  By: Suresh B.

• How to add cubes and dimensions in analysis services database....

  I am new to AS. I have created a new Database in Analytical services and i have to create new cube …

  id_vundadu

  1 replies

  14 years, 9 months ago

  By: id_vundadu

• How to code to delete count(OrderID )>1 and [City]=null?

  In Order table, how to code to delete count(OrderID )>1 and [City]=null? For example, second row…

  adonetok

  6 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Encrypting a varbinary(max) field

  Hi Everyone. I'm hoping someone can help me out in this. I have a requirement to store a small num…

  RaiderX

  1 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Breaking data into Subsets and Calculating Mean, Median, Mode

  Guys I need to break a data-set into around 900 subsets and then calculate mean, median, mode for e…

  Ghanta

  4 replies

  14 years, 9 months ago

  By: GSquared

• Parse HL7 message

  I need to parse HL7 messages and import data to a SQL table. Since it's very complex, i'm trying to…

  amns

  3 replies

  14 years, 9 months ago

  By: Jeff Moden

• Profiler Event: SP:StmtStarting with TextData but empty ObjectName

  Hello, Tracing a process in Profiler, but, I found for an event: SP:StmtStarting in the EventClass …

  mymail.default

  4 replies

  14 years, 9 months ago

  By: mymail.default

• Install an R2 instance on my 2008 machine

  I need to restore a 2008 R2 database to a machine that has SQL 2008 installed. Is it possible to in…

  Kevin

  1 replies

  14 years, 9 months ago

  By: UMG Developer

• View All Keywords in Full-Text Index

  In BOL, they give this wonderful example of what a full-text index contains including the Keyword, …

  Jeff Moden

  2 replies

  14 years, 9 months ago

  By: Evil Kraig F

• giving error for the calculation

  I am using Sql server 2008. I am writing the query with cte.its structure like below ;with cteA as …

  krishusavalia

  10 replies

  14 years, 9 months ago

  By: LutzM

• Running totals for the past 20 years

  I am needing to totals up payments for claims that started up to 20 years ago. I will be showing a …

  repent

  2 replies

  14 years, 9 months ago

  By: repent

• Create/Drop Excel table

  We recently updated to SQL Server 2008. After converting all the SSIS packages, one feature no long…

  Amy.G

  21 replies

  14 years, 9 months ago

  By: Amy.G