Forum Replies Created
Viewing 15 posts - 58,996 through 59,010 (of 59,048 total)
-
RE: Query Time Out
Howdy,
It is and always has been a "bug" with Enterprise Manager. I don't think you'll find a fix for it even on the Microsoft site (I've look for this fix...
-
RE: "IN Clause" Stored Procedure
Steve,
To answer your first question, I've found that PatIndex is a wee bit faster than LIKE. In either case, both take a toll on speed when it comes to large data...
-
RE: Auto-Reporting all constraint violations in an import
My thoughts are that if you are trying to import data that is either delimited, fixed field, or a combo of both, you should probably take the time to use...
-
RE: questions about string value
Sometimes ya just gotta do with the data ya got...
The REPLACE answer is a good one. Thanks. -
RE: date range query
SELECT * FROM DBO.pt_vCheckSupport
WHERE supp_startdt>='07-MAR-2004' AND supp_startdt<'20-MAR-2004'
-
RE: "IN Clause" Stored Procedure
The PATINDEX example works. Try it.
-
RE: "IN Clause" Stored Procedure
- Using your stored procedure...
- ALTER PROCEDURE sp_RevByGeo
- @mon varchar(255),
- @year int
- AS
/* SET NOCOUNT ON */
SELECT GEO , CustomerType,
-
RE: Need help creating dynamic "USE" statement... Thanks.
Got the same result... no error but no change. Thank you for trying.
-
RE: How do view execute?
>(select count(*) from myview where ...) as field1
>(select sum(field) from my where ...) as field2
Your last post said that you used aggregate functions for each field. Looking at the code...
-
RE: Challenging T-SQL Requirement
First, thank you for the table and data code...
always a pleasure to NOT have to write code just to do a test setup... -
RE: variable must not be combined with data-retrieval operations.
- Your problem, I believe, is with the following section of code...
- A.zcmSBA_V_SUBSTATIONID=B.zcmSBA_V_SUBSTATIONID AND
A.zcmSBA_V_WONO=B.zcmSBA_V_WONO AND
A.zcmSBA_N_JONO=B.zcmSBA_N_JONO AND
A.zcmSBA_V_TRXNO=B.zcmSBA_V_TRXNO
- Looks more like part of a WHERE clause... anyway, THAT's what...
-
RE: How do view execute?
Worse than that, it's been my experience (in SQL Server 7) that a SELECT such as yours will create a separate instance of the view, in memory, for each named instance...
-
RE: TABLE TO SP
Kokyan is correct... temp tables are always unique per session. You can see the actual name of a temp table in the tree view (press f8) of Query Analyzer. They...
-
RE: Taking parsed string and assigning variables without using a temp table
Actually, there is! It comes in the form of the PARSENAME command which was specifically developed to break apart the parts SQL object names "at the dots". Since your example...
-
RE: delete from duplicate records
Thought AH did a pretty good job!
Viewing 15 posts - 58,996 through 59,010 (of 59,048 total)