Viewing 15 posts - 14,176 through 14,190 (of 26,486 total)
Assuming that the source and destination tables have a common unique key, you would do a lookup in the destion table to see if the record already exists. If...
November 2, 2011 at 2:04 pm
I think I'm still a little lost. Given date 'x' what are you expecting regarding start date and end date for 2 months? Same for the week start...
November 2, 2011 at 1:58 pm
Have to ask, has anything changed since the last time everything ran okay?
November 2, 2011 at 1:25 pm
kramaswamy (11/2/2011)
Upon thinking about this a bit more, I realised that in order to get what I'm trying to do to work, I'll need...
November 2, 2011 at 1:21 pm
I find it easier if you show me what you are looking for, I figure things out better when I have a picture of what is needed. Think you...
November 2, 2011 at 1:15 pm
GSquared (11/2/2011)
Long Integer in Access = Integer in SQL Server.Memo = varchar(max)
IIRC, and this may have changed, converting an Access MEMO field to SQL Server becomes an NTEXT or TEXT...
November 2, 2011 at 1:12 pm
venoym (11/2/2011)
You need to add join criteria. so your query would be something like
...
FROM A INNER JOIN
B ON A.ID = B.ID
WHERE...
Sounds like an echo. I seem to remember...
November 2, 2011 at 12:55 pm
Martin Schoombee (11/2/2011)
Yes, you do need a "FROM"-clause. The CTE's can be used as tables in your final query.
Yes, and some how they need to link together unless a cartesian...
November 2, 2011 at 11:39 am
Edit: Never mind, I missed the flipping of first and last name as well.
This?
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
DROP TABLE #mytable
CREATE TABLE #mytable
( MyColumnName varchar(50))
INSERT INTO #mytable(MyColumnName)
SELECT 'LN1,...
November 2, 2011 at 11:37 am
The questions should be related to something else you really can't do much unless you develop your own schema to answer the question(s). Since we can't see your book...
November 2, 2011 at 11:29 am
You are apparently using SQL Server 2008 based on the forum you posted. Put the two queries into CTE's and then use those CTE's in the final query.
Here is...
November 2, 2011 at 11:18 am
And if this is homework (which it really looks like it), also show us what you have have tried so far and where you are having problems.
We'll help you help...
November 2, 2011 at 11:14 am
Start with what Gail suggested. Also, do you perform any scheduled database maintenance, such as defraging indexes, updating statitistics?
November 2, 2011 at 10:47 am
Not sure what you are asking. Please read the first article I reference below regarding asking for help. It will show you what we need and how to...
November 2, 2011 at 10:42 am
Would help if you provided us with the DDL for the table(s), sample data, and expected results based on the sample data.
Please read the first article I reference below in...
November 2, 2011 at 10:33 am
Viewing 15 posts - 14,176 through 14,190 (of 26,486 total)