Viewing 15 posts - 481 through 495 (of 594 total)
quote:
I poor solution I've come up with is to find the MAX value of the CityData_SK in OldData. Create a temp...
March 14, 2003 at 1:13 pm
If you're talking about the report query, then bring the SQL over (slightly modified to work with T-SQL) into a stored procedure. If you need help doing this, post...
March 13, 2003 at 11:32 am
I don't have adequate experience with the .NET to comment on your code, however, I would first analyze the difference between you client-server code-base and your ASP.NET code-base. I...
March 12, 2003 at 9:17 am
My guess is that you are using a connected recordset in the Crystal Session object? Am I correct? Can you post some snippets of the ASP code you...
March 12, 2003 at 7:02 am
how wide is the table? can you post the schema? is the table used more on an OLAP or OLTP level?
March 7, 2003 at 1:29 pm
quote:
...Primary key (non unique)---->1.prodcode
---->2.barcode
...
It is not possible to have a non-unique primary key.
Suggestion:
Think about having...
March 7, 2003 at 8:14 am
If you don't want SQL Server to put anything in the field, then make the field NOT NULL. There is a default set either at the table schema level...
March 7, 2003 at 7:45 am
quote:
Consider replacing a stored procedure with a user-defined function that returns a table...
Good suggestion....
March 5, 2003 at 2:19 pm
You can do an:
INSERT INTO #temptable EXEC your_sp
and then use the #temptable in the other procedure.
However, there have been performance problems noted with recompilations of INSERT...
March 5, 2003 at 12:51 pm
Try something like this:
SELECT
SUBSTRING([EXT_DATA], CHARINDEX('@1', [EXT_DATA]) + 2, (CHARINDEX('@2', [EXT_DATA]) - CHARINDEX('@1', [EXT_DATA])+2))
FROM [SELMLOG4].[dbo].[EVENTS]
WHERE [EVENTID] = '627' AND [USERNAME] = 'BTSINC\SANCHEZJU'
editing: oops, forgot...
March 5, 2003 at 10:15 am
The function you are looking for is PATINDEX, as in:
WHERE PATINDEX('%Closed%', FieldToLookIn) > 0
edit: sorry, forgot the wildcard characters...
Edited by - jpipes on 03/05/2003 09:57:08 AM
March 5, 2003 at 9:56 am
Import the text file into SQL Server using DTS, then join on the newly created table onto the regular SQL table using standard join syntax.
Column layout for fixed length field...
March 3, 2003 at 12:16 pm
I'm not sure, but I would find it unlikely since you'd be joining on, presumably, an indexed foreign key field relationship. Just another option, I guess. Good luck!
...
March 3, 2003 at 5:26 am
quote:
...Never split a table on columns unless you cannot fit it in 8K wide (not counting text)...
February 27, 2003 at 1:55 pm
READING A BOOK ENTIRELY IN UPPERCASE WOULD BE EXTREMELY ANNOYING BECAUSE YOU COULDN'T FIGURE OUT WHAT WAS BEING EMPHASIZED. LIKEWISE, READING SQL STATEMENTS AND STORED PROCEDURES WHEN EVERY TABLE...
February 27, 2003 at 12:00 pm
Viewing 15 posts - 481 through 495 (of 594 total)