Forum Replies Created
Viewing 15 posts - 4,846 through 4,860 (of 5,103 total)
-
RE: Data Driven Query
AFAIK there is no limit in the number of rows unless you have explicitly set it on the option tab either by max error or max row
-
RE: Linked Server SQL 7 to 6.5 Problem
Check the Permissions of the security tab for the account you used in QA
HTH
-
RE: Whether to use or not a Stored Procedure
Let me add just this:
If RANGES are involved in the searches it might be GOOD to allow recompilation for the stored procedure! (this behavior is observed when the ranges vary...
-
RE: Sub-Select Wierdness
quote:
I see what you are saying, but the query does returns 7 rows. That is what makes it so strange. ... -
RE: Do the certifications add value?
quote:
... More than five years in the same position would be a warning sign to me, unless that person has continued... -
RE: GREAT 2004 and FORWARD MARCH
Happy New YEAR to ALL!!!
-
RE: SQL QUERY
WOW!!
That was funny. Three replies almost a once
-
RE: SQL QUERY
SELECT
TrackNmbr
, PolNmbr
From
Table
Group by
...
-
RE: SUM() returns exponent based value instead of 0
quote:
This SUM function/code that I am using for the above column/data "SUM(ISNULL(INDEMNITY_AMT, 0)) AS INDEMNITY_AMT"
Any ideas?
-
RE: How to Access the database off the network
I am not sure you want that, but if All you do is query linked tables then:
1.Delete the existing links
2.Goto File --> Get ExternalData -->LinkTables
3. Select ODBC DataSources on...
-
RE: New and old values
SELECT
Q.ProjectCode
, Q.LastLaunch
... -
RE: Resizing tables and rows to better fit into pages
You may want to run
DBCC SHOWCONTIG () WITH TABLERESULTS
It will Answer most of your questions!
-
RE: find who accessed
you can code that in the procedure!
otherwise --> Profiler or third party tools
-
RE: upgrading from Access to TSQL
The First is that instead of
where cnt > 1
Should be deleted and after "group by"
just write having count(*)>1
The Second is treaky but, why are you selecting * and...
-
RE: Insert month if missing
In this Case It is a good thing to have a Dates / Months Table And then
SELECT D as Date
...
Viewing 15 posts - 4,846 through 4,860 (of 5,103 total)