Viewing 15 posts - 11,176 through 11,190 (of 26,486 total)
How can you work with MS Windows and not know this? This person is scary.
June 21, 2012 at 10:19 am
Assuming that you are doing this update in a stored procedure, I would do something more along the lines of this psudo code:
... prep work
set transaction isolation level serializable;
begin transaction
begin...
June 21, 2012 at 10:14 am
Please, I really hope this person was joking.
June 21, 2012 at 10:05 am
Charmer (6/21/2012)
anthony.green (6/21/2012)
2012 runs SQL Data Tools which is built on VS20120
2008+R2 runs BIDS2008 which is built on VS2008
2005 runs BIDS2005 which is built on VS2005
I...
June 21, 2012 at 10:03 am
JeffRush (6/21/2012)
June 21, 2012 at 9:52 am
I had to zoom in on the picture which made it harder to see (blurry), but from what I could make out, your sample code and data doesn't match what...
June 21, 2012 at 9:43 am
Actually, I wasn't too sure what the OP really wanted and we haven't heard anything from the OP.
June 21, 2012 at 9:33 am
Going to agree with Jason, hire a consultant. If I were being paid, I'd make time during the evenings and weekends (as long as I was also able to...
June 21, 2012 at 9:27 am
sivag (6/21/2012)
June 21, 2012 at 9:06 am
Check out this as well: http://www.sqlservercentral.com/Forums/FindPost1315529.aspx
June 21, 2012 at 8:57 am
I don't think Jeff meant that he would keep calling people back for more interviews, but that he would extend the current interview to learn more about the prospective candidate.
June 21, 2012 at 7:48 am
Proper forum etiquette would have you post your solution. Others may have a similar problem and seeing how you solved my help tham.
June 21, 2012 at 7:46 am
If you want to achieve application portablity and performance, you need to design for it, and such design usually requires two separate code bases. You need to separate the...
June 21, 2012 at 7:45 am
Please post the DDL (CREATE TABLE statements) for the tables Master_data and Transact. Do not include any of the extended properties if you are using those for documentation purposes.
June 21, 2012 at 7:34 am
The following will work with both mdy and dmy:
set dateformat mdy;
go
CREATE TABLE [dbo].[sss](
[Account] [varchar](50) NOT NULL,
[datetrans] [datetime] NOT NULL,
[uniqueID] [int] NOT NULL,
[TranAmount] [numeric](18, 2) NOT NULL,
[TranBal] [numeric](18, 2) NOT NULL
)...
June 20, 2012 at 4:09 pm
Viewing 15 posts - 11,176 through 11,190 (of 26,486 total)