Using Access 2003 Trying to join the following two tables: TABLE 1- this is a reference table that lists census block groups and associated zip codes within a...
3653
dinesh.mani@...
chennai_dina
Jul 1, 2008 4:58 am
Check if this works - SELECT Table2.Field1, Table1.Field2, Table2.Field2, Table1_1.Field2, Table2.Field3 FROM Table1 AS Table1_1 INNER JOIN (Table1 INNER JOIN...
3654
Stephen Allen
stevieraybond1
Jul 1, 2008 1:34 pm
thanks dinesh. i'll try this out. To: SQLQueriesNoCode@yahoogroups.com From: dinesh.mani@... Date: Tue, 1 Jul 2008 10:26:08 +0530 Subject: RE:...
3655
SQLQueriesNoCode@yaho...
Jul 7, 2008 6:41 am
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Monday July 7, 2008 All Day (This event...
3656
SQLQueriesNoCode@yaho...
Jul 8, 2008 6:41 am
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Tuesday July 8, 2008 All Day (This event...
3657
SQLQueriesNoCode@yaho...
Jul 9, 2008 6:42 am
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Wednesday July 9, 2008 All Day (This event...
3658
SQLQueriesNoCode@yaho...
Jul 10, 2008 6:41 am
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Thursday July 10, 2008 All Day (This event...
3659
Paul Anca
paul_anca
Jul 10, 2008 3:11 pm
Hi, I'm not sure why I got this everyday from this group, it is supposed to be sent every day? Best regards, Paul Anca www.ancasolutions.com ... "If you were...
3660
John Warner
john@...
Jul 10, 2008 3:40 pm
Something new I guess to 'sell beer'. I just delete them. I would write a rule to delete them for me, but I don't want to miss a legitimate post from the list....
3661
Charles Carroll
charlesmarkc...
Jul 10, 2008 6:49 pm
I will disable the calendar feature. That will end this. Thanks for letting me know....
3662
scottfisheruk
Jul 10, 2008 6:52 pm
Hi I'm working with DTS in SQL 2000. Once a week a CSV file is created with a name including the date. I.e. MYFILE12032008.CSV I need to run a DTS package...
3663
SQLQueriesNoCode@yaho...
Jul 11, 2008 6:40 am
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Friday July 11, 2008 All Day (This event...
3664
Noman Aftab
noman17pk
Jul 11, 2008 7:14 am
Dear All, IÂ have the following table script: Â CREATE TABLE [dbo].[SYS_MODULE]( [SYS_MODULE_ID] [int] NOT NULL, [MODULE_NAME] [nvarchar](512) COLLATE...
3665
Arnie Rowland
arnie1568
Jul 11, 2008 3:00 pm
Precede the CTE with a semi-colon. ; WITH ModuleHierarchy Regards, Arnie Rowland, MVP (SQL Server) "I am a great believer in luck, and I find that the harder I...
3666
John Warner
john@...
Jul 11, 2008 3:20 pm
You are kidding!! I looked at this for ten minutes, looked at the syntax in BOL a couple of times to see if I could spot the error and it was a silly piece of...
3667
Tim Mitchell
tdmitch
Jul 11, 2008 6:58 pm
Yes, CTEs are finicky that way. A CTE must be the first statement in a batch. ________________________________ From: SQLQueriesNoCode@yahoogroups.com ...
3668
yogi_raj_143
Jul 11, 2008 7:03 pm
Hello All, I need some help in creating query statement for mysql database I have database in below format Year Brand Count 1990 ABC 5 1990 PQR 3 2000...
3669
JoeFawcett
Jul 11, 2008 7:04 pm
... NULL, ... MODULE_LEVEL) ... ModuleHierarchy; ... Unless WITH is the first statement in the batch it needs to be preceded by a semi-colon: ;WITH... Joe...
3670
Noman Aftab
noman17pk
Jul 11, 2008 7:09 pm
Thanks Arnie for the reply. Amazingly that same query was running perfectly on a different machine. I then reinstalled MSSQL2005 on my machine and it...
3671
John Warner
john@...
Jul 11, 2008 7:32 pm
Oh sure rub it in <wink/> John Warner...
3673
YogS
yogi_raj_143
Jul 13, 2008 8:35 pm
All, Thanks for going through my post, Finally i have found the answer... +++++++++++++++++++++++ SELECT DISTINCT t1.Year AS Year, t1.Count AS ABC_Count,...
3674
Noman Aftab
noman17pk
Jul 14, 2008 10:22 am
Dear All, I have SQL Server 2005 installed on my machine. When I open the "SQL Server Business Intelligence Development Studio" it simply opens the visual...
3675
Joe Fawcett
JoeFawcett
Jul 14, 2008 11:03 am
Noman I've been told Visual Studio 2008 doesn't support BI development as yet. It should be added soon either via a service pack or a...
3676
Arnie Rowland
arnie1568
Jul 14, 2008 11:19 am
The latest (since early June) version of SQL Server (RC0) includes BI Development Studio. You may have a older version of the beta (CTP) that did not include...
3677
Noman Aftab
noman17pk
Jul 14, 2008 11:52 am
RC0 is SQL Server 2008 which we dont currently have or are willing to use. Now what I am forced to do is to manage "Report Server Project" on VS2005 and...
3678
cesar_rouillon
Jul 25, 2008 3:27 pm
I have a query and I get the next error: Error -2147217871 Timeout expired Before It doesn't show this error, but now I get this error, the query now must...
3679
John Warner
john@...
Jul 25, 2008 3:32 pm
Check available drive space and see how much free space you have on the server. John Warner...
3680
cesar_rouillon
Jul 25, 2008 9:44 pm
The space is: Filename : E:\Databases\Data\FEG2_Data.MDF Filegroup : PRIMARY Size : 192064 KB Max size : Unlimited Growth : 10% Usage : data only ... the ... ...
3681
John Warner
john@...
Jul 25, 2008 10:31 pm
Drive space, how much is free? Sometimes if the log or something consumes a lot of the drive SQL is using then queries that once ran fine will slow way down. ...
3682
John R. O'Brien
obrienjohn2002
Jul 26, 2008 4:48 pm
Try this; maybe you are having concurrency issues, maybe not. When you do a select into you lock the schema (systables … etc ) and no one can create a new...
