Hi, I have a table which includes a cost column & a date column. The dates are roughly one or two days apart. I need to sum the costs into weekly groups. How can I do this? Many thanks in advance for any ideas on this Ant...more >>

I'm a shareware programmer and I'd like to embed to my VC++ application some appropriate database. Since I have no database experience I'd like to hear references from professional programmers regarding the following- 1. Is sqlserver could be appropriate? 2. Is there any other commercial produ...more >>

I recently received a database schema to load. It contains a single child table with two parent tables. The child table contains mailing address columns (address, city, state, zip, etc). The two parent tables contain name parts. One table is for persons, and the other table is for busine...more >>

What is the easiest/best way to schedule a daily run of SQL update statement. I have read some posting on using the SQL Agent, but what is it, where is it, and how do I use it? I have a SQL statement that I am using to populate a table. ...more >>

Has anybody run into this? When I'm scripting a procedure in SMS, whether using right-click/[Modify|Script] or the wizard (sp2), none of the header comments appear. (i.e., comments prior to the CREATE) This was happening before I moved to sp2. I just noticed it today, and I'm not sure of t...more >>

How can I limit a query to = next month, I do not want to see any data for this month? ...more >>

Thanks in Advance, I have the following case statements in a query: CEILING(SUM((CASE WHEN MONTH(dbo.ConvMacDate(due_dt)) - (MONTH(GetDate()) + 3) = 0 THEN ms_qty ELSE 0 END))) AS ItemsPlanned3rdMonthAhead, CEILING(SUM((CASE WHEN MONTH(dbo.ConvMacDate(due_dt)) - (MONTH(GetDate()) + 2) = 0 ...more >>

Anyone: (and what really drives this question is question #2 below since I've not had an issue with slow queries yet, I just thought I'd throw it in for good measure) I have a subsystem that logs the same set of data to a table each time a job has completed. I use to have a wide table w...more >>

i need to do some action when an inserted or deleted record satisfies a certain criteria. and all i really want to do is say send an email. now if this process fails, i might want to log it but i don't want the trigger to abort. the changes should still persist! is there a way to do this? it s...more >>

Hello group, I have a puzzle that I am trying to solve and was hoping someone out there would be able to help. I am working as part of a development team that has inherited code initially written 12+ years ago and has not evolved well with the times. The product has used many versions ...more >>

I need to update table in SQL Server. When records have no value, value should be taken from the previous record were value IS NOT NULL. EXAMPLE: ID Value 1 1 2 3 8 4 5 9 6 44 7 8 9 10 11 33 AFTER update values should be as below ID Value 1 1 2 1...more >>

I'm trying to follow Microsoft's example of partitioning and sliding window in the Adventureworks database, but what I want to do is put the primary table and the archive table in different filegroups (because I just want to back up the archive file group nightly). There's no problems setting...more >>

My transaction log file is pretty big and am trying to run maintenance plan which is setup to clear the unused space etc. But it does not run. It keep erroring out saying administrator has no rights to run. Is there any other way of running or shirinking log file? ...more >>

Hi, I have several stored procedures, if I create them via a sql file together with some other stuff (create couple tables), the creating process always success, then the first time execution for the main store procedure which calls others always goes success, but after that first time one ...more >>

Hi folks, A SQL newbie guy here, so please point me to the straight and narrow... In the real world, I'm trying to build a Business Objects report that will find the new patients by month but I think I can learn from Northwinds at this point. If I decide that a new customer is born fro...more >>

I have abut 15 million records needed to be copy directly from one server to another what is the fastest way? I use select * into xx from xx.xx.xx thanks ...more >>

Hi, I don't have time to test it out. I am just wondering what is your experience on this. I have migrate data from server1.db1 to server2.db2 However, I only have read only permission from Server1.db1 In my process I must create a table to store data before moving to db2(can't use temp,...more >>

Hi I have 2 tables, Stories and StoryImages. I need to a random set of 10 images from StoryImages, but only 1 image from each story. The link field is StoryID - there can be many StoryImages to a Story. Here's what I have so far... SELECT TOP 10 Stories.StoryID, StoryImages.Image, Story...more >>

Hi, In Excel I can find the normal distribution with the formula: =NORMDIST(x, mean, standard dev, cumulative) How is this done in SQL 2005? I am having a difficult time finding this on the web so hopefully someone can assist me with this or at least point me in the right direction. ...more >>

Hi guys, Is there any way to do something like this? The idea is that I have some updates to do, and I would be passing a list of integers in a @VARIABLE. But I didn't find a way to do it... Thanks a lot! -- ____________________________ Carlos Sosa Albert...more >>

Hi, I got called in this morning to look at a trigger that was leaving a transaction open. From manual inspection there was nothing wrong with the trigger, but when run the trigger was failing at some point after creating a transaction but not producing any error messages. Which is weird as t...more >>

Hi I have store procedure that returns around 100 columns. I just want the 1st columns data of the proc. I cant change anything in the storeprocedure as it is req by other apps. create proc test @ID int, @subID int, @range Int as Begin select col1, col2, ...more >>

I want to connect to remote sql server via IP, but I am connecting to internet via proxy. How do that?...more >>

Hi, in my application a lot of simultaneous updates and selects are pondering on one table. Sometimes I need some data of this table in a delayed fashion only. To relax locking on that table I therefore copy (every hour) some columns into an helper table and execute many selects on that table...more >>

declare @var varchar(255) set @var =3D '78D6' if isnumeric(@var) =3D 1 begin select cast(@var as numeric(18,0)) end else begin select 'cannot convert data' end This cast convert varchar to numeric - throw error (error converting = data type varchar to numeric) becouse @var is not...more >>