Viewing 15 posts - 151 through 165 (of 216 total)
The wrinkle is that "20111107070115" won't CAST to datetime as is. He has to first STUFF a space before the time portion and some colons between the HH:MM:SS.
Dang. You're...
November 29, 2011 at 11:42 am
I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the database is...
November 29, 2011 at 10:33 am
I am sorry, but your statement of the problem is very unclear. I (and many others) are very happy to help, but we need a better description from you.
Please...
November 28, 2011 at 5:00 pm
The very best solution to your problem would be to get more storage space. It is the lack of storage space that is causing you to jump through hoops.
If,...
November 28, 2011 at 4:50 pm
Without getting into the specifics of the execution plans for the two queries, I can say this has to do with how the query optimizer processes the TOP command. ...
November 28, 2011 at 4:28 pm
I agree with the other posts: if possible, change this to a real date type field. Then changing the display in a procedure or application is a simple...
November 28, 2011 at 2:30 pm
this is a test environment, but it mimics the production server, so we still want to keep the backups, although we keep only two weeks backup on disk vs production...
November 28, 2011 at 2:16 pm
Working with dates is always a challenge, and even simple questions like this don't have ready-made solutions available.
The answer, as the other respondents have stated, is to create a calendar...
November 28, 2011 at 1:33 pm
Let me restate the problem to make sure I understand it. You are copying table data from one database to another using SSIS. The table includes an identity...
November 28, 2011 at 1:05 pm
OK. This is interesting. You start a transaction somewhere else, update some data, and then check for an error condition inside a trigger. If the error condition...
November 2, 2011 at 4:55 pm
Account - Need to pull fields RepCode [this is the current rep code assigned to the account, need only those starting with Z, X or ending in XX]
Because of this...
November 2, 2011 at 4:01 pm
Here you go. Let me know if you have any questions.
;WITH [PreviousUpdate]
AS
( SELECT AccountNo
,MAX(RecordDate) AS [CurrentDate]
...
November 2, 2011 at 3:25 pm
Execution plans is 100% index seek on my_index
We would like to see the actual execution plan, if you wouldn't mind. (The ACTUAL plan, not the estimated plan.)
Right click anywhere...
October 28, 2011 at 10:09 am
Index rebuilds in full recovery are fully logged. Because of this, the index may be taking a long time because of transaction log issues. It might be running out of...
October 28, 2011 at 8:30 am
Viewing 15 posts - 151 through 165 (of 216 total)