Viewing 15 posts - 1 through 15 (of 97 total)
Hello prb88,
why you should do that?. Your lookup table plays a role, it serves to maintain the description out of the main table, and your request just negates the meaning...
April 30, 2013 at 2:40 am
Kelvin Phayre (4/17/2013)
Excel VBA code
...
April 18, 2013 at 1:59 am
Hello,
maybe you can try to delete rows in small blocks, replacing your DELETE instruction by something like (I cannot check the syntax now)
Delete TOP 1000 Products where instance = 'XXXX-xxx-xxx-xx'
WHILE...
February 26, 2013 at 5:22 am
Hello,
my first thought is create a temp table or var table including these relations, then join.
CREATE TABLE #T (ProdGrpCode varchar(10), ResultCode VARCHAR(10))
INSERT INTO #T
SELECT '500', '82' UNION SELECT '510', '82'...
October 2, 2012 at 3:48 am
Hello,
you can do it in an iterative way:
Find the first colon, keep the left half into Col1 and move the right half into Col2.
Find the first colon in Col2, keep...
October 1, 2012 at 5:00 am
Hello raghuldrag,
I think your first need is help analyzing what the problem is.
Your process proceed in three steps:
- Summarize data from @table into #temp1.
- Summarize data from @table into #tempr.
-...
July 31, 2012 at 8:54 am
Hello schauhan13,
I think your Stored Procedure is 'perverted' by some kind of procedural thinking, and a set-based approach could be better. Lets me explain:
Your CASE statement tries to calculate a...
July 30, 2012 at 2:59 am
Hello Nathan,
have you discarded the obvious option?, maybe your Types table contains a duplicate TypeID.
Francesc
July 12, 2012 at 3:42 am
Hello Sachin,
I think the easiest way to go through this problem is creating a month table and left-joining it with your query, maybe something like (I have'nt checked it)
WITH MonthList...
May 25, 2012 at 7:37 am
Hello,
you can try to do it without using cursors, that should speed up your process.
I think in a solution using intermediate tables, let me explain:
You coded a query to strip...
February 15, 2012 at 2:09 am
Hello,
once I had a similar request and I decided to create a ROW_NUMBER function in Access, like
Private last_Row_Number As Long
Private key_Row_Number As String
Public Function Initialize_Row_Number() As Long
...
February 14, 2012 at 1:15 am
Brandie Tarvin (1/27/2012)
January 27, 2012 at 7:21 am
Hello jennigirl,
you coded three queries and now you only need to combine them using JOIN like that:
SELECT UserId, [Total Asset], [Total Inventory]
FROM User
LEFT JOIN (
SELECT UserIdCreated, COUNT (TimeCreated) AS [Total...
January 27, 2012 at 2:44 am
Hello,
try it:
WITH CTE(x) AS (
SELECT ', Clayton' UNION SELECT 'Township,' UNION SELECT 'Clayton, Dept')
, NoRightComma (x) AS (
SELECT CASE RIGHT(x, 1) WHEN ',' THEN LEFT(x, LEN(x) - 1) ELSE x...
January 25, 2012 at 2:29 am
I was believing that a LEFT JOIN was better in performance that a NOT IN clause, more generically, I accepted that a JOIN is generally better in performance than a...
January 16, 2012 at 4:01 am
Viewing 15 posts - 1 through 15 (of 97 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy