WayneS

Forum Replies Created

Viewing 15 posts - 4,051 through 4,065 (of 5,588 total)

RE: Multi Value Parameter

Glad I could help.
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 3, 2010 at 8:18 pm

#1176283
RE: Un-concatenate field imported from event viewer.csv file

Of the 2942 lines in that file, there are only 3 where Field9 starts with "User Account Enabled". Do you only want to run this for just those lines?
If so,...
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 3, 2010 at 8:04 pm

#1176282
RE: Multi Value Parameter

TriggerMe (6/3/2010)
WayneS,
It works. Your modified IN CLAUSE is what the problem was. Thank you.
Actually, your original code only had one closing parenthesis also.
Just one question though, in this case the...
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 3, 2010 at 7:49 pm

#1176276
RE: Cannot install SQL Server 2008 Ent on new laptop

I don't know if you can install it on a Pro version... I had to upgrade my Vista laptop from Home to Ultimate to be able to install Dev (Ent...
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 3, 2010 at 7:28 pm

#1176271
RE: Multi Value Parameter

You have a parenthesis mismatch... make the final ")" be "))".
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 3, 2010 at 7:22 pm

#1176270
RE: Un-concatenate field imported from event viewer.csv file

Provide additional rows of data - especially the ones that aren't loading.
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 3, 2010 at 7:17 pm

#1176269
RE: Merge Membership Effective Date and Expiration Date

stewartc-708166 (6/3/2010)
Please provide the DDL for the table and some sample data, so we can provide you with a workable solution.
Qjlee, apparently you don't know how to do this in...
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 3, 2010 at 7:07 pm

#1176266
RE: Multi Value Parameter

TriggerMe (6/3/2010)
I have the following query as an expression in the dataset properties.
="SELECT A.AssetID, A.ComputerName, A.AssetNumber, A.SerialNumber, VIT.VendorItemTypeID, VIT.ItemTypeDescription AS AssetType, V.VendorName AS Vendor, VI.VendorItemDescription AS...
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 3, 2010 at 7:00 pm

#1176265
RE: Find Previous Version Record Value

Anan,
With 380+ points, you should know how to post data here in a readily consumable format so that all of us volunteers can just cut-and-paste it, and start working. Seems...
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 3, 2010 at 6:55 pm

#1176263
RE: Please help with the code

Please check out the first link in my signature, and then try posting your data in that suggested format. Then, based on the sample data you provide, show what the...
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 3, 2010 at 6:04 pm

#1176258
RE: Un-concatenate field imported from event viewer.csv file

Okay, with all of this new information, you won't need the DelimitedSplit function.
Change to a temp table, and then use this code:
-- drop the table if it already exists
IF object_id('tempdb..#CSVTest')...
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 3, 2010 at 5:49 pm

#1176256
RE: Unble to connect named clusterd instance from SSMS of SQL Server 2008 R2

Thanks for the followup.
A clustered instance (named or not) has it's own computer name, and you should be able to connect to that instance with just that.
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 3, 2010 at 5:12 pm

#1176249
RE: Best book on SQL Server database design

I'd recommend this one
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 3, 2010 at 5:09 pm

#1176248
RE: Are the posted questions getting worse?

Jeff Moden (6/3/2010)
Steve Jones - Editor (6/1/2010)
There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth 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 3, 2010 at 4:36 pm

#1176240
RE: Removing Duplicate Records from a Report

I agree with Jeffrey. It sounds like you are joining on just the analyst id, when you should also be joining on the company id. Also, make sure that you...
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 3, 2010 at 2:36 pm

#1176199

Viewing 15 posts - 4,051 through 4,065 (of 5,588 total)