Viewing 15 posts - 9,031 through 9,045 (of 9,643 total)
This sounds like a good candidate for a fuzzy lookup or fuzzy grouping transformation. You would set it up for an exact match on Last Name and a fuzzy...
March 11, 2008 at 7:42 pm
I suggest configuring the error output to redirect row and outputting the data to a table or file so you can see what row(s) are being rejected. You are...
March 11, 2008 at 7:35 pm
Thanks for the input Jeff. Needless to say I learned a lot about international phone numbers recently. I am pretty confident I have the right codes. I...
March 11, 2008 at 5:53 pm
The solution in my last post appears to be working just like I want it to. Might not be the prettiest code in the world but it is getting...
March 11, 2008 at 3:05 pm
What you want to do is not easily done in T-SQL. Usually something like this would be done in SSIS or another package. What about Jon and John...
March 11, 2008 at 3:02 pm
Yes you can run SQL 2000 and SQL 2005 on the same server. One will have to ba named instance.
You can also run different SP levels on one...
March 11, 2008 at 2:59 pm
Got this in my SQLServerPerformance.com newsletter today:
Ad hoc updates to system catalogs are not allowed.
Error Message:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs...
March 11, 2008 at 2:55 pm
You mean to say you added columns to a table IN the ReportServer database? Why?
March 11, 2008 at 2:50 pm
Select
Convert(varchar(10), user_id) + ' ' + user_name + ' ' + comment as row
From
source
For XML AUTO
Will give you one row...
March 11, 2008 at 2:47 pm
Check out this link, http://www.systemwebmail.com/faq/4.2.2.aspx#4.2.2. Looks like you need to explicityly set the smtp server.
March 11, 2008 at 1:06 pm
Where are you setting the value of @extract_start_date and how is it being set? Could be that the error is happening at this point.
March 11, 2008 at 9:52 am
Nobody had posted the brainbench test yet. I took it and my score was better than I anticipated as I took the test. When I entered the test...
March 11, 2008 at 9:50 am
Glad I could be of help. I wouldn't recommend using sa as the account though. You should have an account that just has the necessary permissions. You...
March 11, 2008 at 8:53 am
Could you post the the query, with any proprietary stuff removed of course? It might help me, and others, understand what is going on. I have not worked...
March 11, 2008 at 8:52 am
Bob Fazio (3/11/2008)So far, it looks like everyone is agreeing with me. Can anyone give me a good reason to use delete instead?
To keep your developers happy:P
March 11, 2008 at 8:27 am
Viewing 15 posts - 9,031 through 9,045 (of 9,643 total)