Viewing 15 posts - 11,356 through 11,370 (of 15,381 total)
Now we can all see the code. However as already stated you need to post ddl, sample data and desired output before anybody has a chance at helping.
Why all the...
July 13, 2012 at 1:01 pm
For those of you too nervous to open a text file...
CREATE Procedure [dbo].
--@evt_keys nvarchar(4000)=null
@last_export nvarchar(20)=null
as
--select @last_export = null
Create table #temp_keys (Id uniqueidentifier)
--if rtrim(isnull(@evt_keys, ''))=''
--insert into #temp_keys select evt_key from...
July 13, 2012 at 12:56 pm
You need to provide ddl, sample data and desired output. Take a look at the first link in my signature for best practices when posting questions.
July 13, 2012 at 12:53 pm
Lynn Pettis (7/13/2012)
kaspencer (7/13/2012)
Once again we are down to the process whereby questions are vetted and approved or disapproved for publication. This must be improved.Kenneth Spencer
Are you volunteering to do...
July 13, 2012 at 12:08 pm
shovankar (7/13/2012)
Could anyone please help me understand what is Constant scan operator and how it affects the performance of a query ?
A small background -
I am...
July 13, 2012 at 11:58 am
Matt Miller (#4) (7/13/2012)
Look to move the process over to SSIS. There are some simply options on capturing the records in a source file causing errors.
Well that would certainly...
July 13, 2012 at 9:43 am
Sounds like you have a collation difference between two tables or columns. Most likely in a join somewhere.
You can force the collation in the comparison like this.
table1.Column COLLATE DATABASE_DEFAULT =...
July 13, 2012 at 9:37 am
Lowell is spot on the with the FOR XML way.
I think your original "no value" is possibly because you are concatenating strings and not accounting for NULL. In other...
July 13, 2012 at 9:24 am
Well that doesn't really solve the OP's issue. They have an insert and want to know which line in the data is causing the issue. I modified your example to...
July 13, 2012 at 9:21 am
The worst part of the ambiguous question and answer is that if you wanted to test knowledge about the OS max then the OS should be specified. The "correct" answer...
July 13, 2012 at 7:22 am
David Lester (7/12/2012)
Yes, yes they are.I have spent many many years attempting to save them from themselves.
Not sure if you saw the attachment to my previous post. You should print...
July 12, 2012 at 12:45 pm
I wouldn't even bother trying to script this for 10 machines. It would take longer to figure out the scripts then it will to just set them up.
Honestly I wouldn't...
July 12, 2012 at 12:42 pm
2 weeks later
User "Why can't you just get it right the first time?"
:crazy:
Do you tell them that you did get it right? I got it 100% correct according to my...
July 12, 2012 at 12:28 pm
OK so you have a single sql account. How do you want them to connect? My crystal ball is out for repair at the moment so you are going to...
July 12, 2012 at 12:24 pm
Your question is very unclear. You have 10 users that want to connect to SQL Server from Access? Do they all need a different username/password? If you can explain clearly...
July 12, 2012 at 12:14 pm
Viewing 15 posts - 11,356 through 11,370 (of 15,381 total)