Viewing 15 posts - 76 through 90 (of 139 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...
R David Francis
December 29, 2003 at 10:43 am
My apologies - I'm following what you're saying now.
R David Francis
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
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...
R David Francis
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...
R David Francis
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...
R David Francis
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...
R David Francis
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 as varchar(3))+'='...
R David Francis
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.
R David Francis
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...
R David Francis
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
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...
R David Francis
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...
R David Francis
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...
R David Francis
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...
R David Francis
October 6, 2003 at 10:52 am
Viewing 15 posts - 76 through 90 (of 139 total)