Viewing 15 posts - 286 through 300 (of 345 total)
Combine? Try:
select * from
( <your 1st query>) a
inner join
( <your 2nd query>) b on 1=1
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 18, 2011 at 11:30 am
Why don't you just replace the function with a procedure that gets the next box# and updates it in one shot? You don't need to join to the tblOrders table...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 18, 2011 at 10:35 am
Lowell (4/14/2011)
toddasd (4/13/2011)
There is no importing an Access database in SQL Server.
not sure what you mean by that... a data source is just a data source.
maybe you mean the...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 14, 2011 at 12:24 pm
shank-130731 (4/13/2011)
What I'd like to do is on insert, if there's a primary key violation, edit the [PKGNO] field to reflect [SHIPMENTNO]+[ID].
That's a bad idea. Why not make ID the...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 14, 2011 at 12:09 pm
Thanks for the links and info. I hope I never have to migrate an Access database again, but I'll definitely put SSMA into my toolbelt.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 14, 2011 at 10:00 am
suryagiri (4/7/2011)
how to import access Data Base file in sqlserver ?
the problem is Import access database file extension is ".accdb" in Sqlserver .
if any one knows plz help me...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 13, 2011 at 3:01 pm
Any luck with solving this, PaulSp? It would be useful to know since my organization will be upgrading to Win7 soon and I'm supporting an Access2003 to SQL app.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 13, 2011 at 2:55 pm
We can't know that from the information we have. All we know is what types of villas are taken, but not which particular villas are taken. We can't know how...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 8, 2011 at 10:40 am
This isn't the whole trigger, is it? What are you doing with the variables @ptFlagIndicator1Var, @ptFlagIndicator2Var, etc., after you set them?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 8, 2011 at 10:21 am
What is the relationship between guest_reservation and reservation? It looks like a one-to-one so it should probably be combined to one table.
smallville69 (4/8/2011)
To be able to find out a list...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 8, 2011 at 10:00 am
webrunner (4/8/2011)
UMG Developer (4/7/2011)
Steve, oh Steve, Cleanup on...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 8, 2011 at 7:31 am
If you want to group it by year, as in your original post, then you can get the year from the date with the year() function. Also remember to group...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 7, 2011 at 10:17 am
I think this is what you want. The case expression is very powerful addition to your sql arsenal. Thanks for posting the useful DDL.
SELECT
G.DeadlineDate,
E.Name,
Sum(Case when S.GoalStatusDesc = 'Complete' then...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 6, 2011 at 3:54 pm
Try this:
create table A (ID int identity(1,1), col1 int);
insert into A (col1) select 100 union select 200 union select 300;
create table A_audit (A_ID int, col1 int, date_changed datetime);
go
create trigger A_changes...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 5, 2011 at 10:29 am
repent_kog_is_near (4/1/2011)
the trigger, ideally, should be fired only when there is a new row...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
April 1, 2011 at 9:20 am
Viewing 15 posts - 286 through 300 (of 345 total)