Viewing 15 posts - 5,446 through 5,460 (of 9,722 total)
What you posted, and the title of your post, are two different things. I don't think you need to loop at all.
What you need is to write up your OUTER...
July 28, 2011 at 6:05 am
Kiara (7/28/2011)
Brandie Tarvin (7/28/2011)
So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.
I can offer two day old peanut butter and...
July 28, 2011 at 6:01 am
As Gail said, SQL Server makes the choice in the deadlock situation. You don't get to pick. The only way you could pick is to do it manually, but usually...
July 28, 2011 at 5:59 am
I agree with the others. Something else is calling this job or starting it.
Check msdb.dbo.sysjobs joined to msdb.dbo.sysjobsteps to find any job steps that use the sp_start_job proc or call...
July 28, 2011 at 5:57 am
forsqlserver (7/28/2011)
2008 R2Are u sure Backup compression is not used in 2008?
1) Please don't use text or L33T speak in the forums. There's enough acronyms and such flying around these...
July 28, 2011 at 5:49 am
Your phrasing is unclear. What do you mean by join two tables using wildcards?
What have you tried? What is your table ddl? Give us create table statements, sample data, and...
July 28, 2011 at 5:44 am
Run PerfMon and a server-side sql trace. You might also check the default trace, see if it has enough back log to show you what was going on the last...
July 28, 2011 at 5:42 am
GilaMonster (7/28/2011)
Brandie Tarvin (7/28/2011)
So, are there any pastries or donuts at the water cooler today? I am in desperate need of sugar.
I have hot cross buns. And I'm not sharing.
Grrrrrrr!
😛
July 28, 2011 at 5:17 am
I'm seeing two things. 1) In your result set, you refer to customer 9181, who doesn't exist in the test data. I'm assuming you meant 9151 and this is just...
July 28, 2011 at 5:13 am
Eugene Elutin (7/28/2011)
1. If you re using SSRS to produce report, grouping can be done in SSRD itself
FYI: I agree with the above statement. In fact, in SSRS, you can...
July 28, 2011 at 5:00 am
I'm taking a look at this now.
Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. If you...
July 28, 2011 at 4:57 am
WhineWhine, RantRant, ComplainComplain.
Why does morning have to come so early? Can't it wait until I wake up for real?
[/rant]
So, are there any pastries or donuts at the water cooler today?...
July 28, 2011 at 4:48 am
Paul,
Thank you for that post. It was very informative.
July 28, 2011 at 4:39 am
Ah. Thank you for pointing that out.
July 27, 2011 at 12:07 pm
Viewing 15 posts - 5,446 through 5,460 (of 9,722 total)