SQL Server

Page 2953




  • Topics
    Replies
    Last post
  • Explaining Importance to End Users
    by Davy579124
    1 Replies
    Last post by ggciubuc
      • Hello Experts at Microsoft. I am thinking of an easy way to explain importance to Marketers without going into the math. This is what i came up with so far. Does this sound correct to you guys Reasoning: IMPORTANCE = Log(Improvement) Improvement=P(X&Y)/(P(x)*P(y)) Improvement= (Probability 2 products are sold together)/(random chance 2 products are sold togethe
  • mising dll to play a pc game
    by trukutu
    1 Replies
    Last post by Erkan Yilmaz
      • hi cant i receive de direct page to downloads or upgrade de d3dx9_29.dll
  • Simple Todays date query question
    by Dan Rooney
    3 Replies
    Last post by Jarret
      • Hi, I have just started using SQL server 2005 reporting. But I am stuck on my select part of the report. I want to bring back all results from a table for todays date (whatever that would be). I have tried: Where ColumnA = Today() and a few other Today variations. Can anybody please help Also is there a good site / tutorial which helps with SQL syntax, statements, etc. Thanks Dan
  • Visual Basic 6.0
    by madskunk
    6 Replies
    Last post by ErikEJ
      • Greetings, Firstly, apologies if this topic is out of the scope of this board, but I am stumped. Basically, we have an old Visual Basic 6.0 application which currently accesses an Access database, but which we would like to upgrade to an SQL compact edition database. I have created the database, but have so far turned up next to no details reagarding how to connect to the damn thing in VB6.
  • Creating a 4-4-5 Time Period table
    by desibull
    14 Replies
    Last post by desibull
      • Hello: Very soon my company will be moving to a 4-4-5 reporting schedule. Basically, what this means is that the first month of the quarter will have 4 weeks, the second will have 4 weeks, and the third will have 5 weeks. Therefore, for the 2007 the dates for Jan, Feb and Mar will be as follows: Jan - 1 - 27 Feb - 28 - 24 Mar - 25 - 31 Currently, I have an SSIS package creating
  • Reliability during synchronization
    by the_chad
    13 Replies
    Last post by Mahesh Dudgikar - MSFT
      • I am using SS05 64 bit standard edition, SP2 on a 2.8 GHz dual core Xeon 2 GB RAM box with a 146GB RAID 10 data partition and a 36GB mirrored OS partition. I have 13 publications over 5 databases. Some of these publications are transactional, some are merge with updating subscribers. I have 35 pull subscribers that use Windows XP SP2 and Sql Express SP2, and connect through wireless
  • SQL 2005 & Visual Studio 2005
    by Liviuchan
    14 Replies
    Last post by Jens K. Suessmeyer
      • I installed SQL 2005 and then the VS2005 and I would like to have them communicate to each other just like VS2005 and SQL Express do. I do not have SQL Express installed on my machine. Any help would be deeply appreciated and I thank you in advance. Warm regards, Liviu
  • Problem with SQL SQLCECommand - Missing Parameter
    by ELugoL
    5 Replies
    Last post by Zero Dai - MSFT
      • Have a nice day. I'm developing for PocketPC using VB2005 and SQLMobile and need some help to solve the following issue: At runtime the following code throws an exception #25950 SSCE_M_QP_MISSINGPARAMETER Missing Parameter [Parameter ordinal = 1] Everything looks fine, but it still fails. In the same app I have a datagrid connected via a dataset and it works OK. Please give me directions!
  • Copy Flat File between two server; Help me please.
    by P.Chonnathan
    5 Replies
    Last post by Phil Brammer
      • Hello All, I want to copy flat file(.txt) from server to another server. server A(Source Folder) ====> server B(Achive Folder) Can I do it Please, help me. Thank you very much. Chonnathan
  • Creating a SQL statement store procedure
    by ljCharlie
    12 Replies
    Last post by Kent Waldrop Se07
      • I'm trying to do this: CREATE PROCEDURE [dbo] . [spStoryDisplay] -- Add the parameters for the stored procedure here @clsYear int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON ; -- Insert statements for procedure here SELECT *, "Class Year" = CASE WHE
  • Need Help for Query
    by Ankur.Bhardwaj
    5 Replies
    Last post by Louis Davidson
      • I have 2 tables -Table1 ( CountryID is primary key) CountryID Country US America UK England IND India AUS Australia Table2---- (G1 is number of goals by team1 and G2 by team2) Team1 Team2 G1 G2 US UK 2 3 US I
  • RIGHT OUTER JOIN
    by hrubesh
    5 Replies
    Last post by hrubesh
      • Hi, i need an equivalent code to RIGHT OUTER JOIN i do not want to use that. ex, SELECT dbo.Test1.a, dbo.Test1.b, dbo.Test1.c, dbo.Test.t FROM dbo.Test RIGHT OUTER JOIN dbo.Test1 ON dbo.Test.a = dbo.Test1.a thanks
  • BULK XML with value=......
    by FERNANDO2328
    1 Replies
    Last post by Monica Frintu
      • Hi, I have got a problem with the folowing XML < xml version="1.0" encoding="UTF-16" >< !DOCTYPE produkte [] > < produkte > < produkt > < produktid value= "4950065" / > < kombiniert value= "false" / >< artnr value= "45869" / >< kombipr value= &qu
  • Configuring merge replication for side-by-side SQL Server 2000 and 2005
    by LarryBB
    6 Replies
    Last post by LarryBB
      • I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can con
  • sqlserver 2005 standard edition unable to start mssqlserver service (access denied)
    by Dave Elliott Msdn
    2 Replies
    Last post by Dave Elliott Msdn
      • All, I have installed sqlserver 2005 using the standard msdn universal installation discs on my laptop running vista business. The mssqlserver service will not start automatically as the setup configures it and I cannot start the service manually because I get the 'Access Denied' error message I am logged on the the computer with adminstration privileges Thank for al
  • DrillThrough action is broken and returns no data
    by dork
    1 Replies
    Last post by Jeroen Alblas
      • I have a simple DrillThrough action which has been working for sometime. However, it has now stopped working and will not return any data... even if I invoke it from the highest level. I have re-deployed and processed the whole database from scratch. There is no conditional statement to this so I cannot see why it would not run. What could possibly been happening Has anyone had this proble
  • SP2 Replicating with Pre-SP2?
    by mabster
    8 Replies
    Last post by Vishal Gandhi
      • Hi gang, I'm 99% sure this is possible, but I wanted to confirm before I go upgrading one box in our replication scheme without having to do all the others (which are geographically dispersed): Can an SP2 box replicate (merge replication in our case) with pre-SP2 servers Most of our servers don't even have SP1 applied, and we're ready to upgrade, but I want to be sure I can do them o
  • Autofit table within a table
    by ajhuddy
    8 Replies
    Last post by ajhuddy
      • Hello, Does anyone know of a technique to 'autofit' the rows of a table within a table Once you start to add extra rows to the 'child' table, the rows start to shrink, making it fairly annoying, and manually resizing takes a while.
  • Which edition and which licensing to use?
    by Jianxing
    8 Replies
    Last post by Buck Woody - MSFT
      • Hi all, I would like to ask which edition and licensing type of SQL server 2005 should I use for the scenerio as described below. Please advice. I have an ASP.Net application, whereby there will only be around 4 to 5 users accessing to the application. On the same database server, there is another VB.Net Windows application accessing to the database as well. Which kind of edition and licensing
  • SubTotal with Reportitems in Table Group
    by Tof_94
    3 Replies
    Last post by kcon
      • Hi, Here is my problem, I want to sum a textbox in my table group using =Sum(Reportitems!txt_erreur_cmt.Value,"table1_Group3") but i always the same error as : Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope But my sum is the table group footer. I have no ideas how do that sum. Does anyone can help me Best regard
  • Connection string for PDA
    by vnj
    2 Replies
    Last post by Ilya Tumanov
      • Hello, I am using VS 2005 and developing PDA device application to run on SQL CE. The PDA has Windows CE 5.0 OS. Now I am using the following code for connection to database: I got this code from some website on Internet but do not remember which one: Try Dim FullAppName As String = [Assembly].GetCallingAssembly().GetName.CodeBase Dim FullAppPath As String = Path.GetDirectoryName(FullAppN
  • Easiest and performance effective way to store blob into varchar column
    by Fahad349
    11 Replies
    Last post by Fahad349
      • Hi, My package dumps the errors into a table. The problem is, it couldnt dump Error Output column to a varchar field. I have added an script component in between to transform to string but no success. I tried ErrorOutput.GetBlobData(0, ErrorOutput.Length) but when I query the database, it says "System.Byte[]' I will appreciate the responses to this post. Thankyou, Fahad
  • Deployment Error
    by paddygalway
    3 Replies
    Last post by ErikEJ
      • Error 1 Deployment and/or registration failed with error: 0x8973190e. Error writing file '%CSIDL_PROGRAM_FILES%\PDA\PDADB.sdf'. Error 0x80070020: The process cannot access the file because it is being used by another process. Device Connectivity Component Hi I get this error when I try and deploy the emulator but it only happens when I run the database on the emulator it works fine before I
  • display details only when printing
    by avitalk
    1 Replies
    Last post by kcon
      • Hi, I have reports in reporting services. I want to add an introductory page to the report that shows a logo, report name , date and a few other details. However, I want to show that page only when user prints the report. Is this possible and if yes how Thanks
  • Crosstab result
    by Vivek2
    5 Replies
    Last post by Vivek2
      • Hi there, I'm using sql2005. I've got a table in tabular form and I need to convert it to crosstab format. I've tried to use pivot operator but i can't get the result i want. Because pivot operator needs to aggregate a field but what i need is Dim values as column names and DimCode as values within those columns as it is, no aggregations. For example : This is tabular table.