Viewing 15 posts - 2,356 through 2,370 (of 2,452 total)
Lynn Pettis (8/20/2009)
Jeff Moden (8/20/2009)
"You can lead a horse to the water..."http://www.sqlservercentral.com/Forums/Topic774023-149-1.aspx
Persistant was she to get you to write bad code, hmm.
persistant...most defintely :w00t:
see here:
http://www.sqlservercentral.com/Forums/Topic774787-149-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 21, 2009 at 4:02 am
dunno...why dont you tell us:-D
does it give you the results you require?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 20, 2009 at 1:16 pm
And another option if this is the case:
select
cust.CustomerPK,
loc.LocationPK
from
dbo.Customer cust cross join dbo.Location loc
except
select
custloc.CustomerPK,
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 20, 2009 at 8:37 am
if you are saying that all customer / locations combinations should be in table CustomerLocation and you want to find the combinations that are "missing" then please try this
SELECT ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 20, 2009 at 7:35 am
Apologies for the link:
pls try this
Forum Etiquette: How to post data/code on a forum to get the best help
by Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2009 at 11:26 am
Forum Etiquette: How to post data/code on a forum to get the best help
by Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
hope this helps
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2009 at 10:28 am
Have you tried the Microsoft SQL Server Migration Assistant for Access...free download.
addendum:
I see there is a specific version for SQL 2008
SQL Server Migration Assistant 2008 for Access V4.0
Overview
Microsoft SQL Server...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2009 at 1:37 am
....
The goal is to have the report formated as follows:
cusid name product1 product2 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2009 at 11:55 am
[º Considered how hard it would be to explain to the people actually using it.
Seth, this comment maybe sums it up....no matter how clever you are in designing a system...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2009 at 3:26 pm
santosh.shrestha (8/17/2009)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2009 at 2:06 pm
another method that concatenates row values
SELECT p1.CusId,
( SELECT replace(type, ' ', '') + ','
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2009 at 1:47 pm
you can also use Query Designer in SSMS (Ctrl+Shift+Q)
Add your table
select the first column by clicking on its name (not the check box)
hold down shift key
go to last column and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 17, 2009 at 11:51 am
How “deep” does your hierarchy go?...you have given just two levels.
If you have many more nested levels, such as this for example:
Shirts
..........Sports
....................Tennis
..............................Men
..............................Women
.....................Golf
..............................Men
..............................Women
...........Casual
Then I think it gets a little bit more...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 16, 2009 at 4:14 pm
bpowers (8/15/2009)
How would I get this to work?SELECT EMP_ID, DATEDIFF(MONTH, START_DATE, END_DATE) AS HISTORY
FROM EMP_HISTORY
WHERE EMP_ID = '253'
DATEDIFF(m, start_date, end_date)
Suggest you look at BOL for DATEDIFF..and test out various date...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 3:19 pm
you're welcome
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 15, 2009 at 2:34 pm
Viewing 15 posts - 2,356 through 2,370 (of 2,452 total)