OK so I've downloaded and installed this 1.7MB wonder, but now what? I just wanted a nice easy to deploy db to use with my VB 6 app and although the size is now great it doesn't seem to be doing much else. Nothing in the start menu, sys tray, desktop, etc. Just a folder in my program files ...more >>

Hi, can someone please help me convert the two Access queries below to MSSQL 2000 queries? Note; there are only ever three categories 1,2 and 3 ============================ Query 1) TRANSFORM Sum(IIf([RESULT]="FINISHED",1,0)) AS Expr2 SELECT TABLEA.ATTRIBUTE1 FROM TABLEA LEFT JOIN TABLEB ON...more >>

I need to generate an XML document that takes the following format. The format has already been defined by a separate application. <Opportunity> <Name>Example Name</Name> <Customer Id="A"> <Name>Some Customer</Name> </Customer> <TotalValue>50.000</TotalValue> </Opport...more >>

I have a sproc which is called iteratively from an SSIS package. For debugging purposes, I've inserted in the sproc a PRINT statement that SELECTs some values . I can not think of a way to track and also PRINT the iteration number of the call to the sproc. Here's what I'd like to see in...more >>

Hi, I am a .net web developer and i'm developing a database driven web application. I have 2 questions about sqlserver database design. 1. Let's say it's a online store, i have several tables in my database, like SalesOrder, Production, CustomerInfo, ProductionDescription, etc., each time t...more >>

I hae a stored procedure that has been running for over 9 hours; I see a green rolling wheel and the status as 'Executing Query' I tried to get some info in Activity Monitor but couldn't find any info on this process; where do i go to check what is going on with this sp?...more >>

We have converted a few access DB's to SQL...they were not that large and it was to help with the new requirements requested by the business. Everything works, but in Access one of the columns was setup to capture alpha-numeric. Its not that big a deal, yet.. but woudl like to see is there any...more >>

1) Are aggregate functions allowed in CHECK constraints? Basically, I would like to use an aggregate function, like COUNT, with a CHECK constraint for a table. But when I try to do it via MS-SQL Mngmnt Studio Express, I get an error. Basically I right click on a table in the design view, ch...more >>

I need to walk through a table with many thousands of rows summarizing data by minute. If I use the DateAdd function to go to the next minute, I do not get the proper results for 3/11 when the time changed. I have since discovered that DateAdd is not DST aware even though SQL Server books on...more >>

Hi all, I'm trying to run a sproc like: CREATE PROCEDURE spGetGuests @GuestList varchar(50) SELECT * FROM Guests WHERE idGuest IN (' + @GuestList + ') But I get the following error: Syntax error converting the varchar value ' + @GuestList + ' to a column of data type int ...more >>

I am trying to use the built-in functions to calculate a standard deviation, and I am getting confused. Here is a runnable example: create table #t (i int) insert into #t (i) values (0) insert into #t (i) values (0) insert into #t (i) values (14) insert into #t (i) values (14) select a...more >>

Is there a way to view error log from Query Analyzer? Thank you ...more >>

Is there a command to rename MDF and LDF physical files of the db? The task is rename: 1) db name (sp_renamedb proc) 2) logical file name (alter database and mofify file command) 3) MDF and LDF files (can it be done using T-SQL command?) Thanks for your help. *** Sent via Develope...more >>

Hello all, I'm having a problem with calling a stored procedure via openquery/linked server between SQL Server 2000 and Oracle 9i. Here's an example of the query that's being run. In reality, the Oracle SP is returning more rows: SQL Server: select * from openquery(WAREHOUSE, '{CALL ...more >>

Hi, I am currently working with a client that has a database structure that is causing headaches in trying to create queries. Because the system is in place and functioning and can't change the architecture, so i was hoping for some assistance. Their structure has Top Level Global datab...more >>

Hi all, I need know if have same way to create one trigger ( I think that this trigger need be DDL, I don't know) that when any: INSERT, UPDATE OR DELETE is executed in any table, the thata is captured and send to another table, for audit. Have any way to do this? Thanks SQL SERVER...more >>

I have a stored procedure that either inserts a row or updates a row. There is a field in there that I would like to check for in the update section. If the incoming parameter (pPDF) is null, I do not want to even issue an update for that field. Can I cehck for this inline or do I have to wri...more >>

My objective is to register the Windows-LogonID in audit trail, but at this point the application is using a SQL-userID. From searching this group, it seems impossible to get the Windows-ID as a variable in the SQL server if connected with SQL-userID - so I'm trying to find alternative. Ques...more >>

This dynamic query frequently times out. I'm guessing it's because of all the udfs in the select and where clauses so I attempted to make the RevisionStatus and UsageStatus into fields in the EngineeringDocuments table and update them with triggers. This works fine but the RevisionStatus val...more >>

hey all, i have an employee table of the following: empID, Gender, Salary how do i get a count of male vs female? also, is it possible, in addition to the above, get the percentage of male and female, and avg of their salary all in one statment? thanks, rodchar...more >>

Hi, I have a Select statement that uses Coalesce with Nullif in the Where clause. I thought all has been working good. I found a row that it is not returning and have it narrowed down to this line in the Where: AND odColor LIKE COALESCE (NULLIF('%' + @Color + '%', ''), odColor) I pass ...more >>

select WorkflowNo, JobNo, step, max(WFDateTime) from WorkFlowHistory group by WorkFlowNo, JobNo, Step produces this: workflowno jobno step WFDateTime 34 512 1 2007-03-14 09:45:01.520 34 513 2 2007-03-14 09:54:01.300 34 514 3 2007-03-14 09:55:01.453 35 534 1 2007-03-14...more >>

Can a table function have an index or a primary key that contains 2 columns in SQL 2005? ...more >>

Hello, I stucked on strange problem with data order in dataset. Any clue or suggests will be appreciated. Let's start from the beggining. We have to tables: Table1: Nr1 21 22 23 24 25 26 27 28 35 37 Table2: Nr2 20 21 22 25 26 28 32 34 39 This is my result which d...more >>

Hi All How do you would handle the space between the folder name "Default Site" on the below SQL as it is part of the pathname to file DB20070314 to be deleted? I am getting the error that the path to the file is wrong? --------- declare @nqly nvarchar (356),@date char(10) select @date...more >>

Hello, I stucked on strange problem with data order in dataset. Any clue or suggests will be appreciated. Let's start from the beggining. We have to tables: Table1: Import Nr 18 19 20 21 22 23 24 25 26 27 28 29 32 33 34 Table2: Import Nr 20 21 23 25 26 28 29 32 34 ...more >>

Hi All, I noticed a strange behavior about Float data type. Declaring a variable with float data type, set the decimal number 19.44228 to the variable and Print the value of the variable. It prints the following number 19.4423. If I execute a select statement to get the value of the vari...more >>

I have a table with 2 fields - a Date/Time containing an appointment date and a VarChar containing an appointment time in a format such as 11:30 (I have inherited this arrangement from an existing structure. I could change the format of the time if necessary.) I need to create an UPDATE tr...more >>

Can someone tell me how to create tables with non nullable columns using SQLCmd(by executing db create scripts)...when I use the scripts to create the database all tables that get created have the columns as nullable i know that this can be done using create table and mentioning null or not...more >>

Thx in advance! ...more >>

Is need to make some IIS settings before install SQL server when endpoint feature is used? I only want use endpoint fwature, I discovered I cannot connect endpoint use IE, which return 404 error. Is it need to set some config on IIS to enable endpoint? ...more >>