Viewing 15 posts - 11,356 through 11,370 (of 15,376 total)
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
Or maybe when they forget the join condition in a where clause and get a cross join on 2 tables with 1M+ rows each. 😀
Two main reasons:
1) Code is...
July 12, 2012 at 10:56 am
LOL we have all been there. 😉 Glad that helped.
July 12, 2012 at 10:52 am
You can do this pretty easily with a tally table.
select OrderId, ProductId, 1
from #OrderItems o
join Tally t on t.N <= o.Quantity
You can read about a tally table here. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D
July 12, 2012 at 10:45 am
bernard75 (7/12/2012)
I guess this somehow landed in the wrong forum. :blush:ELT(): Return string at index number.
Anyway that query returns one of the strings.
ELT is MySql not sql server. I had...
July 12, 2012 at 10:38 am
Viewing 15 posts - 11,356 through 11,370 (of 15,376 total)