Is this possible on all databases or only in SQL Server? Also in SQL server, is this available in all versions of SQL Server or only on SQL Server 2005/2008??...
Works in SQL Server 2K because that is the target for the query I'm trying to make this work on. Can't say for DB2, no way to test. John Warner...
John Warner
john@...
Jun 30, 2008 12:28 pm
3650
Then it must have been something to do with some other part of the query then. No scope to verify the cause for the issue, so assuming that this was not the...
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...
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...
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...
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Monday July 7, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 7, 2008 6:41 am
3656
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Tuesday July 8, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 8, 2008 6:41 am
3657
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Wednesday July 9, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 9, 2008 6:42 am
3658
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Thursday July 10, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 10, 2008 6:41 am
3659
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...
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....
John Warner
john@...
Jul 10, 2008 3:40 pm
3661
I will disable the calendar feature. That will end this. Thanks for letting me know....
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...
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Friday July 11, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 11, 2008 6:40 am
3664
Dear All, IÂ have the following table script: Â CREATE TABLE [dbo].[SYS_MODULE]( [SYS_MODULE_ID] [int] NOT NULL, [MODULE_NAME] [nvarchar](512) COLLATE...
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...
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...
John Warner
john@...
Jul 11, 2008 3:20 pm
3667
Yes, CTEs are finicky that way. A CTE must be the first statement in a batch. ________________________________ From: SQLQueriesNoCode@yahoogroups.com ...
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...
... NULL, ... MODULE_LEVEL) ... ModuleHierarchy; ... Unless WITH is the first statement in the batch it needs to be preceded by a semi-colon: ;WITH... Joe...
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...
Reminder from: SQLQueriesNoCode Yahoo! Group http://groups.yahoo.com/group/SQLQueriesNoCode/cal Computer PC Tips Saturday July 12, 2008 All Day (This event...
SQLQueriesNoCode@yaho...
Jul 12, 2008 6:41 am
3673
All, Thanks for going through my post, Finally i have found the answer... +++++++++++++++++++++++ SELECT DISTINCT t1.Year AS Year, t1.Count AS ABC_Count,...
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...
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...
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...
