SQL Server

Page 2169




  • Topics
    Replies
    Last post
  • SUm Distinct
    by Damien fromOZ
    8 Replies
    Last post by Sarah2409
      • Hi people, I love reporting services 2005 BUT have struck a major limitation! Basically I need a sum distinct function. I have various duplicate details lines and just need to sum the unique values. Anyway this is not possible and a number of people a stuck with this. Yes you can write another sql statement using DISTINCT but then how can you easily integrate that into a table with scope you
  • help with xml.query()
    by rocky_don
    7 Replies
    Last post by Martin Honnen
      • declare @MatchData xml set @MatchData = '<ScheduleDefinition> <StartDateTime>2006-08-10T08:00:00.000-07:00</StartDateTime> <WeeklyRecurrence> <WeeksInterval>1</WeeksInterval> <DaysOfWeek> <Monday>true</Monday> <Tuesday>true</Tuesday> <Wednesday>true</Wednesday> <Thursday>true</Thursday> &
  • Slow Queries: Big Dimension on Axis and Measure Using Root()
    by David Beavonn
    14 Replies
    Last post by David Beavonn
      • Here's an odd perfomance problem related to Root(). I have two queries that are very quick. Query A: SELECT {[Measures].[Sales]} ON 0, NON EMPTY CROSSJOIN ([Product].[Product Code]. Members ,[Product].[Product Name]. Members ) on 1 FROM [Sales Activity for Projections] WHERE ([Time].[Time F].[Year].[Y 2005], [Product].[Product Type Name].[Special Produ
  • MSSQL Select Syntax Help
    by Bgordon
    4 Replies
    Last post by Bgordon
      • I have a table that has unit id, date, time, etc. I would like to select each unit id with the last date it has in the table. The result should have each unit listed once with the latest date in the table. For Example: unit id Date Time 00100 01/12/2007 8:00 00100 01/12/2007 8:45 00200 01/12/2007 8:50 00100 01/13/2007 13:30 00300 01/13/2007 13:45 00100 01/14/2007 11:00 00200 01/14/2007 11:30 the r
  • SqlDependency and FIPS
    by jar349
    14 Replies
    Last post by Remus Rusanu
      • Hello! I am developing with .NET 2.0 and SQL Sever 2005 on WinXP for a production system of Windows 2003 Server with FIPS enabled ( http://www.itl.nist.gov/fipspubs/ ). When our team tries to use SqlDependency, we get FIPS exceptions. I assume that this is because the inner workings use encryption algorithms that are not FIPS-compliant. Is there a way to configure my application (o
  • CROSS APPLY!
    by JRStern
    1 Replies
    Last post by Kent Waldrop Au07
      • OK, I finally figured out what all the hubbub is about with CROSS APPLY and XML! It lets you "cross" a parent node with its children, and I guess in a relatively efficient manner. I suppose lots of people already understood this, but my XML book hasn't arrived from B&N yet, and BOL hasn't been the best tutorial on this stuff. Anyway, right now I'm one fellow feeling smart.
  • dynamically creating a select statement
    by Michael Dawson
    3 Replies
    Last post by Arnie Rowland
      • I have a stored procedure in my database which will be used to search for records matching given criteria, such as within a date range or containing a keyword. The procedure stub is looking like this at the moment: ALTER PROCEDURE [dbo].[search] @file_id int, @title_includes varchar(50), @notes_includes varchar(50), @updated_after datetime, @updated_before datetime, @deleted_after date
  • queries take a long time after sp2 installation
    by blondedba
    5 Replies
    Last post by SamG3
      • Has anyone had thsi issue, if so what was the fix We installed service pack2, the day after 2 of our production jobs started taking a long time to complete and causing a ton of blocking. it went from running in 2 minutes to now taking 3 hours and 29 minutes to run. Can someone help
  • Data Conversion
    by shamen
    14 Replies
    Last post by shamen
      • I have single letters in a Flat file and it is in the string format,but now i want to convert it in to int format.I have tried doing this by SSIS but it is not working. I used data conversion and copy column transformation. I got a error message. it automatically correct the meta data mismatch. But when i run the package, it gives the following error message. Erro
  • Importing Selected csv data into SQL tables
    by Steve McCall
    7 Replies
    Last post by richbrownesq
      • Hi, I hope you can help me. I've got a csv that I need to import. It's about 74 columns wide and 2500 rows long. What I need to do is select the first 3 columns from the columns from the csv and put them into one table and then put every 7 columns (plus the 1st column as the primary key) into a different table. I've not explained that very well, basically it's like this... A B C D E F
  • EASY! Trim string?
    by tenchyz
    6 Replies
    Last post by Jarret
      • I have values in a matrix takin too much space. Since they are just used as the matrix column header, cant i trim it or something. To display just the first 3 letters of the the attribute, and not the whole string Whats the code for that =Fields!Collision_Type.Value thats my field right now. Please help! thanks!
  • SQL 2005 Uninstall/Install Problem WMI Configuration related
    by mroctober
    7 Replies
    Last post by Gray_
      • Hi, I'm the following encountering WMI error message when invoking SQL2005 setup. The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005). For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342 I've
  • One DB machine for Two WebSites
    by hkhk
    3 Replies
    Last post by GlennAlanBerry
      • When there is 1 DB machine for 2 web sites, is it better to have One DataBase-instance running with 2 DataBase-Initial-Catalogs or Two DataBase-instances running, each with 1 DataBase-Initial-Catalog using SQLExpress or SQLServer please only look at those possible, simple conditions. forget about read/write same tables, security issues.. Interms of Memory/CPU/ Pe
  • Command Line Arguments in Debug mode
    by DaveM
    3 Replies
    Last post by JayH
      • Hi, I am passing some /SET commands on the command line when I execute packages I created in SSIS and have run from the SQL Server Job manager. When I put these same /SET commands on the command line arguments section of the project properties page I would expect they would be passed into the executed package when it is run thru BIDS. But the variables still have their defined values when the p
  • Copy Wizard Failure when coping a database on the same machine
    by ewdunn
    3 Replies
    Last post by Satya SKJ
      • I am trying to copy the a database on the same machine (source and destination are the same). The wizard fails using the SMO method. I have attemped to turn on the "Save Transfer logs", but it does not appear to save a file: I have looked in C:\Documents and Settings\<user-name>\Local Settings\Application Data\Microsoft\SQL Server\SMO for all the users on the server. None of them h
  • Simple select statement gone wild!!
    by Tim1022
    10 Replies
    Last post by Tim1022
      • I am very new to sql and would like some help with a simple select statement. I am trying to pull birthdates using the following code. I can get the query to run but some of the dates are not between the parameters. What am i doing wrong SELECT Employees.EmployeeStatusID, People.FirstName, People.LastName, People.BirthDate FROM Employees FULL OUTER JOIN People ON Employ
  • Not present on the Subscriber.
    by davidmgray_de
    5 Replies
    Last post by Raymond Mak
      • Hi all, Publisher SQL 2000 Snapshot publication timed to run at 23:00 daily All tables & views are published articles. Snapshot agent runs and creates a snapshot of all articles. Subscriber SQL 2005 Pull subscription set to run continuously Manually run the SQL agent job and I get the following error... 2006-12-11 15:04:35.687 Agent message code 20164. Unable to replicate a view or
  • Create records in clr udf
    by wilsonjan
    5 Replies
    Last post by wilsonjan
      • We have a large amount of code that returns shredded data from an xml column via a table-valued function. In this table there are many function calls to resolve enumerations to an actual code. If the code does not exist then we wish to write out to a 'lookup_error' table. Any ideas on how to do this Thanks, Jan.
  • query values progressivly by month
    by mflancour
    2 Replies
    Last post by Alex118
      • I have a table with the following fields; sub_id (unique), insertdate, buy (bit), buydate I need to query to show count of sub_id for all fields inserted by month from this I need to then count all fields with buy = 1 by month with each subsequent month only showing values that were contained in the previous months dataset. The only way I can think to do this is to write a seperate query for eac
  • SSIS Updating Package variables from Stored Procedures
    by JGreen67
    1 Replies
    Last post by jwelch
      • I have been looking at the project Real reference implementation for doing auditing of data uploads. The tables and store procedures are in place using identical field and variable names. However, when running the package it does not update the relevant log entry with the end time and status. I have performed the process manually running the stored procedures, providing the values directl
  • Trying to simplify the where clause
    by windthorstking
    12 Replies
    Last post by windthorstking
      • I have the following where clause below which works fine. However, I have not been advised that the client also requires the range of codes: 1400-2089 and 2100-2299 which do not lend themselves readily to the IN statement. I realize I could add yet another OR statement, however, I would prefer to simplify this query without it getting larger and larger with future request. Can someone sugge
  • SP2 change to Aggregate function with Analysis Services datasource
    by furmangg
    7 Replies
    Last post by geertdeprez
      • There's a change in SP2 that I'm very happy about, but it took me by surprise since I haven't seen it documented or discussed: http://www.artisconsulting.com/Blogs/tabid/94/EntryID/1/Default.aspx Can somebody on the SSRS product team double check me that I've written that up right That seems like a pretty important change and I can't see it mentioned in BOL anywhere.
  • Unable to install SQL Server 2005 - "Removing Backup Files" hangs
    by Marc Mueller
    3 Replies
    Last post by SW11111
      • HELP! For the past several weeks, I have been trying to install SQL Server 2005 on a Win XP SP2 PC. Regardless of the options I choose (SQL Engine + Client Tools, Client Tools only, etc.) when the installation gets to the end of the Client Tools setup and the setup status displays " Removing Backup Files ", my PC appears to hang. For a period of time, there is a fair amount
  • Updates at the Subscriber...
    by Swapna.B.
    5 Replies
    Last post by Greg Y
      • Hi,              Can we use transactional replication with updatable subscriptions when we have more updates and transactional changes at the Subscriber side             We are using SQL Server 2005 SP1. We will be using 6 publications and 4 subscriptions for each publications,
  • How to insert multiple values to a column at a time?
    by Ephi
    5 Replies
    Last post by Rob Farley
      • Hi all, I was looking to insert multiple values to a single column at a time in SQl. Any help pleas! Thank you