WayneS

Forum Replies Created

Viewing 15 posts - 4,186 through 4,200 (of 5,588 total)

RE: convert three fields into one datetime

PHXHoward (5/13/2010)
I came up with this as an if but it isn't working right now.
([YearE]== '00' ? NULL : (DT_DATE)
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 8:06 pm

#1167276
RE: Is there a quick way to list the contents of stored procedures?

You might want to look at sys.all_sql_modules... it's the replacement for syscomments
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 6:08 pm

#1167263
RE: 70-433 Study Tests Probable Errata (DELETE FROM FROM)

It's close. It should be:
DELETE FROM Products FROM Products AS P1 JOIN NewProducts AS P2 ON P1.id = P2.id
Note that the first FROM is optional, so it also could be:
DELETE...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 5:03 pm

#1167245
RE: convert three fields into one datetime

With variables Year (int32), Month (int32), Day (int32), use this:
(DT_DATE) (
(DT_STR, 4, 1252) @[User::Year] + "-" + ...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 5:00 pm

#1167244
RE: While Loop Much Slower than LOCAL FAST_FORWARD READ_ONLY Cursor

Robb Melancon (5/13/2010)
So in the end the QUpdate is about 75% faster than the Cursor.
Only 75%? I would have expected much better... closer to 90%. What else is...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 2:20 pm

#1167195
RE: Power designer or erwin

I've used both. Both are excellent products.
ERwin has continually increased their price to where, IMO, it's not worth it anymore.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 2:13 pm

#1167189
RE: Table columns in chronlogical order

h2sut (5/13/2010)
Hello: This worked!! I really appreciate your help on this i cant thank you a enough. Thanks again
be bless
I would caution you: if you can't explain...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 2:11 pm

#1167185
RE: Are the posted questions getting worse?

CirquedeSQLeil (5/13/2010)
Gianluca Sartori (5/13/2010)
I think Celko does nothing to be pleasant, but Peter's reply is terrific.
That is not uncommon. He carries his soapbox everywhere he goes.
That he does. But...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 1:13 pm

#1167161
RE: SET values to same as ID from another table, WHERE values match in another column - Is returning same value for all records, please help

First, if you're going to use the FROM clause in an UPDATE statement, you MUST include the table being updated.
Since the field being updated is coming from a PK...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 10:35 am

#1167046
RE: How can i bring this output

urzsuresh (5/13/2010)
This is my table structure
tag table
Tag TableName FieldName
abc wc s_name
lbl ...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 10:23 am

#1167038
RE: While Loop Much Slower than LOCAL FAST_FORWARD READ_ONLY Cursor

Robb Melancon (5/13/2010)
Ok so everything is working... almost. The first problem I am running into is that I need to reset some values when an asset changes. Should...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 10:10 am

#1167028
RE: Free Advice or Free Consulting

Lowell (5/13/2010)
TheSQLGuru (5/13/2010)
>>they're a last resort
No, forums are NOT the last resort!
TheSQLGuru is right! this forum is one of my first items on my list of resources!
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 9:39 am

#1167005
RE: Backup log succesful in 28 secs, but job is not complete after 4H40

Ninja's_RGR'us (5/13/2010)
Steve Jones - Editor (5/13/2010)
What's the code?
The move shouldn't lock of the server. That makes me suspect coincidence and there's another issue.
Glad to see I'm not insane :w00t:.
Here's...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 9:25 am

#1166996
RE: INSTEAD OF trigger and OUTPUT clause

Toreador (5/13/2010)
Interesting - it never occurred to me that the identity values wouldn't be available in the inserted table!
So how would you get the identity values of the rows you'd...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 4:52 am

#1166758
RE: INSTEAD OF trigger and OUTPUT clause

~~Good~~ Excellent question. Learned quite a bit in the 2nd link (INSTEAD OF trigger).
FYI, in the explanation, it should be the string 'AnotherString' to be replaced with 'Stub', not 'TestString'.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

May 13, 2010 at 4:49 am

#1166756

Viewing 15 posts - 4,186 through 4,200 (of 5,588 total)