WayneS

Forum Replies Created

Viewing 15 posts - 5,146 through 5,160 (of 5,588 total)

RE: Need to set Alwaysusedefaultcodepage as true?

And yet you still bothered to double-post.
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

June 24, 2009 at 2:04 pm

#1014916
RE: Returning the first value of a field in a grouped resultset

Try this out.
-- Notice how I built a table and populated it with your test data?
-- this makes it MUCH easier for people to help you out
-- all...
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

June 24, 2009 at 1:57 pm

#1014913
RE: Formatting data from two rows

NewBie (6/24/2009)
Arun.
Thanks. I tried your method. Did not work for my data.
Then it looks like you need to provide better details and sample data. See the link in my signature...
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

June 24, 2009 at 1:43 pm

#1014900
RE: Still "Restoring..." 5 days later

I have seen instances where the application (in this case, Enterprise Manager) appears to be frozen, especially after cancelling an operation. However, it's not; it's just that the screens didn't...
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

June 24, 2009 at 1:31 pm

#1014894
RE: Need to set Alwaysusedefaultcodepage as true?

duplicate post. post replies here
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

June 24, 2009 at 1:27 pm

#1014889
RE: Need to set Alwaysusedefaultcodepage as true?

duplicate post. Post replies here
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

June 24, 2009 at 1:26 pm

#1014888
RE: CAN I COPY A FILE FROM ONE SERVER TO ANOTHER SERVER GIVING UNC PATH AND USING FILE SYSTEM TASK

It sounds like you installed SQL Server using an account that does not have network permissions. You need to change the logon account for the services to one that does....
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

June 24, 2009 at 1:23 pm

#1014887
RE: Problem with trigger

SQL_Quest (6/24/2009)
BUt when the data is inserted using the application, there where the problem comes.
Note: If the trigger is disabled, then the data gets loaded perfectly OK.
Can any one please...
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

June 24, 2009 at 1:19 pm

#1014880
RE: Splitting Address Data from one field into 3

skailey (6/24/2009)
Hi Lynn,
Thanks so much for the response. That did work, however, I was able to simplify this for my needs with what you gave me... they key being...
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

June 24, 2009 at 1:04 pm

#1014865
RE: Problem with trigger

I tried your code out, then added this insert statement to test out the trigger.
It inserts about 2000 rows into your table, then selects everything.
insert into cnsmr_accnt
select CONVERT(varchar(5), 22 +...
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

June 24, 2009 at 11:08 am

#1014789
RE: Are the posted questions getting worse?

Gianluca Sartori (6/23/2009)
WayneS (6/23/2009)
Well, I let him know a solution is available, but... well, see for yourself... http://www.sqlservercentral.com/Forums/FindPost740549.aspx
LOL! What's your hourly fee, Wayne? I need to get the grass cut......
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

June 24, 2009 at 10:34 am

#1014777
RE: Retrieve XML Data as String

Gary Hines (6/23/2009)
Hi, I'm having a little problem writing a query against a table storing an XML data packet.
Background: We have a sales application that processes an XML packet sent...
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

June 23, 2009 at 3:03 pm

#1014281
RE: special way of inserting XML data

sridevi_mahalingam (6/23/2009)
Is there any special way of inserting XML data into SQL server / DB2 native XML database using XQuery? If so let me know. I tried with CAST function....
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

June 23, 2009 at 3:00 pm

#1014278
RE: Retrieve XML Data as String

Gary Hines (6/23/2009)
Hi, I'm having a little problem writing a query against a table storing an XML data packet.
Background: We have a sales application that processes an XML packet sent...
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

June 23, 2009 at 2:58 pm

#1014277
RE: Are the posted questions getting worse?

Florian Reischl (6/23/2009)
Roy Ernest (6/23/2009)
Florian Reischl (6/23/2009)
Roy Ernest (6/23/2009)
Did anyone see this request
He has some nerve...:-)
Yep. There is the second part of the story:
http://www.sqlservercentral.com/Forums/Topic740368-146-1.aspx
it is good that you put a...
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

June 23, 2009 at 2:28 pm

#1014257

Viewing 15 posts - 5,146 through 5,160 (of 5,588 total)