Viewing 15 posts - 76 through 90 (of 138 total)
This happened to me this morning, I believe on the same question. The page did indicate that I had previously answered the question, and I do recognize the question...
December 29, 2003 at 10:43 am
My apologies - I'm following what you're saying now.
R David Francis
December 17, 2003 at 1:38 pm
If Brian's response is in reply to my suggestion/question, I'm not recommending dynamic SQL....
R David Francis
December 17, 2003 at 1:21 pm
I had a situation where my process was fast enough in getting from the COMMIT TRAN back to the BEGIN TRAN that queries weren't being processed.
My solution was to put...
December 17, 2003 at 11:20 am
In the real world, the situation you describe is common. You've never had a problem because most of the data in those varchar columns happens to be far smaller...
December 17, 2003 at 10:25 am
No idea whether or not this would work, but:
Create a user.
Give the user the permissions to do whatever needs to be done with the tables.
Create the stored procedure as belonging...
December 16, 2003 at 3:28 pm
Could this be as simple as a locking issue? I'm not sure how views operatr under the hood, but one would suppose that, if activity has a base table...
December 10, 2003 at 8:52 am
I think the issue is that, within the environment of your EXECUTE statement, the variables don't exist.
Try:
set @sql='update pivot '
+'set date_'+cast(@cnt as varchar(3))+'=''' + CONVERT(varchar,@date_) + ''','
+'flow'+cast(@cnt...
December 10, 2003 at 8:40 am
quote:
... it ignores multiple word last names (like mine). Of course, some people down South have multiple word first names.
December 10, 2003 at 8:26 am
At my former company, we had an Application Service Provider-style time and billing app. We designed that so that the application itself relied on the appropriate views to determine...
December 9, 2003 at 10:16 am
This looks like it should be as simple as a terminology change in the code.
Why can't you rename @JULY_ID to @MONTH_ID?
What are we missing?
R David Francis
November 6, 2003 at 12:03 pm
I am inclined to place surrogate keys (by which I mean an abstract unique ID, usually an int column with the IDENTITY property) on almost every table I create.
As others...
October 14, 2003 at 3:29 pm
I became dependent on Terminal Services/VNC during a period when our internet connection was a bit flaky. I had several long-running jobs to execute, and running them from a...
October 14, 2003 at 2:50 pm
Try running your procedure and returning the textnumber. You'll see that it's not translatable (for '1993-10-01, I got 1*274 as the answer).
Turns out DATEPART(yy,<date>) still returns a four-digit year.
If...
October 9, 2003 at 10:37 am
Often, in a situation like this, it's a good idea to go back to the English statement of the requirements. If the statements you've translated from English (or whatever...
October 6, 2003 at 10:52 am
Viewing 15 posts - 76 through 90 (of 138 total)