I have a function that adds line item numbers for courses grouped by Identification number (NUID) Right now it returns the following: NUID | CourseIndex 12345 1 12345 2 12346 1 12347 1 12348 1 But it actually needs to take into consideration one more item RequiredDate: so ...more >>

Is there a relatively painless way to manipulate graphic images from within SQLCLR? ...more >>

I have an SQL query that is as follows: SELECT headline,url,summary,updated FROM worldnews EXCEPT (SELECT headline,url,summary,updated FROM worldnews WHERE newssection='Archives' UNION SELECT TOP 5 headline,url,summary,updated FROM worldnews WHERE newssection='Archives' UNION SELECT TOP 5 h...more >>

Hi everyone From within an application I execute the command BACKUP DATABASE MyDatabase TO DISK = 'C:\MyBackups\MyDatabase.bak' WITH INIT This backup runs smoothly without problems as long as the TO DISK clause points to a local drime. But as soon as it points to a network mapped drive, ...more >>

Hi, I have a column with the values of 'Enabled', 'Paused' or 'Paused'. Is it possible to sort it so that the 'Enabled' shows first, then 'Paused', and then 'Disabled', and NOT alphabetically? Thank you ...more >>

Hi all, I'm have a query which return a value from a dynamic column name . Declare @amount numeric(25,0) Declare @ColumnName varchar(20) Set @ColumnName= 'SaleCol1' SELECT @amount = SaleCol1 FROM Sale WHERE year=1998 --- is running fine SELECT @amount = @ColumnName FROM Sale WHERE yea...more >>

hi, is it safe to assume that BINARY_CHECKSUM will return the same result ONLY if the parameters passed to it are the same? i.e. if i have a table Contact with the following columns ( Firstname varchar(50), lastname varchar(50), email varchar(80) ) Should i assume that BINARY_CHECKSUM( Fi...more >>

Hi. I've posted this to the SQL wish center (Connect/sqlserver/feedback) as a suggested new feature. (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281531). Would appreciate your comments and thoughts towards feasibility and usability. Suggested feature ...more >>

How do you make a t-sql parameter an input and output (bidirectional) parameter? thanks! ...more >>

After deploying my SSIS package into our production server running what I think is a 64 bit version of SQL Server Integration Services, I am unable to execute the package. During validation I get the error: Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER .....etc....more >>

/* Subject: How to get last value from a group, eliminating duplicates i know this question has been posted before, but i can't find one that deals with the problem case of non-unique "last" entries NOTE: This can all be pasted into QA i want the information about the last entry from gro...more >>

I wrote a query that works and does as expected. One of pieces of information I have is the date/time in the table. I want to find out how many times during the hour the event occurs. The format in the table for date/time is: 2007-06-01 16:15:18.000 2007-06-01 16:32:00.000 2007-06-01 17:...more >>

I'd like all users to be able to create views that are owned by dbo. I have already granted them CREATE VIEW ... but what permissions do they need so they can create them so they are owned by dbo ? ...more >>

Hi all, I am try to write a query and get the result show below but get stock. Any help would greatly appreciate. drop table #temp go CREATE TABLE #temp ( Agent_nb INT NULL, LastName VARCHAR(15) NULL, FirstName VARCHAR(15) NULL, Auto_nb INT NULL,...more >>

Hi all, I am try to write a query and get the result show below but get stock. Any help would greatly appreciate. drop table #temp go CREATE TABLE #temp ( Agent_nb INT NULL, LastName VARCHAR(15) NULL, FirstName VARCHAR(15) NULL, Auto_nb INT NULL,...more >>

I have 2 tables, both of which contain a zipcode. Table A Table B ZipCode char(5) ZipCode char(5) I would like to generate something like this: select distinct(distinct(a.ZipCode) + distinct(b.ZipCode)) ZipCode but I don't have a clue how to do this. I want a...more >>

I can - from within an application - execute the SQL Command: BACKUP DATABASE MyDatabase TO DISK 'C:\MyBackup\MyDatabase.bak' WITH INIT This works fine as along as the "to disk" clause points to a local drive However, If it points to a network drive, the backup fails Any hint? Regards An...more >>

Is there a function I can use to search for a text string within another text string? For example: search("-","1234-5678") Would return 5 because "-" is found in the 5th position of "1234-5678" Thanks, -- Regards, Dave...more >>

Is there a function I can use to search for a certain string within some text? For example, something like: search("-","1234-5678") would return 5, because the "-" shows up in the 5th position of "1234-5678". Thanks, -- Regards, Dave...more >>

I am using sql server 2000 with the default instance (if that matters), and I would like to save backups to a network drive however I can't see anything more than the local disks from Enterprise Manager. How can I get around this? thanks Andre...more >>

Hello everyone. I'm having trouble with this select statement I need help with. sample table: date1 order_no p_amt 8/11/06 123 800 3/27/07 123 800 3/28/06 123 800 9/11/07 123 0 I want the output of min date with p_amt <=0. Whe...more >>

SQL Server 2000 I have 2 date columns formatted as yyyy-mm-dd hh:mm:sec. What is the best way to calculate the difference between the 2 columns and have the result fomatted in hh:mm - even if the difference is greater than 24 hours? Thanks in advance. ...more >>

I have a small SQL database running on my web site. I want to back it up on a weekly basis to an Access file and then download that file. I can write code to open both the SQL connection and the Access file and copy data in a loop, but someone told me there is a more efficient way to do it. ...more >>

Hi, How we can detect deadlock from a database. Rahul ...more >>

Hello, Does anyone have a method where by I can set up the situation where I will get one execution plan using estimated and a different plan from the actual execution? I need to make it repeatable for demonstration purposes. I just haven't been able to come up with one on my own. Thanks, ...more >>

Hi. I created a view and I compiled, changed from Create to Alter. Every time close it and re-open it opens as Create instead of Alter. Any thoughts?...more >>

Hi , I would like to use a column name in a variable as follows: Declare @amount numeric(25,0) Declare @ColumnName varchar(20) Set @ColumnName= 'Amount1' SELECT @amount = @ColumnName FROM Sale WHERE year=1998 ---error: convertion from varchar to numeric SELECT @amount = Amount1 FROM Sale ...more >>

Hi, Imagine that I have a partitioned table, half of rows on one disk and the other half on other disk. when I query like this: SELECT * FROM MyTable Can I expect to get the result faster comparing with the situation that whole of table resides on one disk? Will these two partitions be s...more >>

Is there any way to import a users Exchange contacts into an SQL Server 2005 database? I looked at the Import Data option but I didn't see anything there. Thanks. David ...more >>

Hello all, I've been doing a lot of research on column encrypting/decryping in SQL Server 2005. I definitely understand it a lot better than I did, but I'm still hazy on some issues. If I have a column which is normally char(9) (say for storing an SSN), with encryption, I need this colu...more >>

Hi, Can anyone tell me where I can get information [in SQL2000] about transactionId started in particular session? In MSSQL 2005 there is nice system view sys.dm_tran_session_transactions, which I can use. I can get this information from locks table, if session put some locks, but this...more >>

DECLARE @TempPersonID uniqueidentifier -- Insert statements for procedure here INSERT INTO People (FirstName,LastName,MiddleInitial,Prefix,Suffix,Birthdate,Gender,SSN,WebsiteURL,Email1,Email2,EMail3) OUTPUT INSERTED.PersonID INTO @TempPersonID VALUES (@FirstName,@LastName,@MiddleInitial,...more >>

I got a problem where in SQL Server a table has a column of type REAL & size (precision) 4. It's meant to store double types for C++ variable values. In SQL Server, the value 1E+10 translates to 10000000000 in C++ fine, via MFC's CRecordset class (DBCORE.CPP). However any numbers above this v...more >>

How can I safely reduce the size of the .LDF file that SQL Server 2005 Express creates for a database? Many thanks. ...more >>

I am hoping that somebody may be able to assist me with a query I am trying to construct but not really getting anywhere. I have 3 tables in the query, one holds staff details, the other a list of jobs and the third a list of exlusions (e.g. holidays). I am building a wizard that will walk ...more >>

Hi, I have for example following table: ID Col1 Col2 --------------------------- 1 A Date1 2 A Date2 3 B Date3 4 B Date4 5 B Date5 i want select every Col1 wit...more >>

Is it possible to do the following in one statement: SELECT ID INTO #ProcessList FROM MyTable WHERE Processed = 0 UPDATE MyTable SET Processed = 1 WHERE FeedID IN ( SELECT ID FROM #ProcessList ) SELECT ID #ProcessList DROP TABLE #ProcessList TIA MattC ...more >>

Friend, Today i have new issue, I want to track, Which 'Application User' has make some changes in database. Here i have a user table, contain userid and there password information for an application. for any updation i have also loged in a log table. Now I also want to trace, that changes...more >>

Hi, I do use SQLOLEDB provider V 2.82 to connect to MSSQL Server 2005. I try to get row data in XML form. The code is the following CCommand<CXMLAccessor> cXMLCmd; CStringW so,sot; cXMLCmd.Create(session, "select * from tmp for XML RAW('item'), root('records')") ; cXMLCmd.Open(); cXM...more >>