Viewing 15 posts - 751 through 765 (of 3,348 total)
In the second query, you build a query string and then insert that string into a table. I assume that you actually meant to execute that string.
Before going down this...
February 28, 2016 at 2:30 am
Yes, please do take the time to ensure you understand what the code is doing. Code-writiing by copy/paste has been the downfall of many companies already. If you don't understand...
February 27, 2016 at 6:29 am
Not sure I understand the question correctly. But here goes.
First - from a design standpoint, there is nothing wrong with a column that has the value 1 for one row...
February 27, 2016 at 6:24 am
That error means that a single row in the destination table has multiple matches in the source table. It's like telling you that John is 18 years old, Mary is...
February 27, 2016 at 6:10 am
EDIT: I forgot to mention that my code returns some three-zone options for order 4; your expected results show four zones. I hope that this is because you made a...
February 27, 2016 at 6:04 am
Okay, two disclaimers up front. First, I agree with Lynn that "random" does not sound as a very precise specification. It is also very hard to pull off in SQL...
February 27, 2016 at 6:00 am
Jon.Morisi (2/26/2016)
I didn't read all your code, sorry.Is this helpful?
(common alternative to a cursor)
while @RowCnt <= @MaxRows
begin
...
Select @RowCnt = @RowCnt + 1
end
No, it's not. Your code...
February 27, 2016 at 3:02 am
benjamin.reyes (2/26/2016)
February 26, 2016 at 12:25 pm
gorripativ (2/26/2016)
Even if I take tlog backups for every 15 min why my initial size is growing is my concern?
What is returned when you run this query in the...
February 26, 2016 at 12:22 pm
Oh, missed that. Since your only concern was the locking on the source table, not on the destination table.
Alternative #1 - use an intermediate table. Do the select on the...
February 26, 2016 at 12:18 pm
Please post a CREATE TABLE statement for the table, post a few handful rows of sample data as INSERT statements, and post the exact results you want returned from that...
February 26, 2016 at 12:11 pm
Sorry. I've been looking at this, but I have no clue at all as to what you are trying to do.
Is there a way for you to repost your problem,...
February 26, 2016 at 12:04 pm
dva2007 (2/26/2016)
February 26, 2016 at 11:55 am
glabrecque (2/26/2016)
(...)I have been able to do it using multiple joins.
So what exactly is your question, then?
If you are looking for a way to simplify your query, I believe the...
February 26, 2016 at 11:34 am
In addition to Steve's reply: you have to understand that the query runs on the server, not on your workstation. That may impact the interpretation of the path.
Also, the file...
February 26, 2016 at 11:19 am
Viewing 15 posts - 751 through 765 (of 3,348 total)