Viewing 15 posts - 11,176 through 11,190 (of 15,376 total)
Lynn Pettis (7/27/2012)
Sean Lange (7/27/2012)
Not sure what the issue with posting the code so I will help that. 😀...
Not sure, Sean, but I know I had issues with some of...
July 27, 2012 at 1:06 pm
OK now we all have the same code to work from. Nice job posting readily consumable ddl and sample data. What I don't understand is what you want for output....
July 27, 2012 at 12:43 pm
Not sure what the issue with posting the code so I will help that. 😀
CREATE TABLE [dbo].[tempholes](
[id] [int] IDENTITY(1,1) NOT NULL,
[number] [int] NOT NULL,
[par] [int] NOT NULL,
CONSTRAINT [PK_tempholes] PRIMARY KEY...
July 27, 2012 at 12:41 pm
pixelwiz (7/27/2012)
July 27, 2012 at 9:56 am
I know you really need some sample data and outputs to be able to help the best, but that's not easy to provide for this question
That pretty much sums...
July 27, 2012 at 9:01 am
Toreador (7/27/2012)
A contender for the worst QotD ever 😉
Did you already forget about the indexes question from last week? There have been plenty others that are far worse than this...
July 27, 2012 at 7:30 am
SQLTestUser (7/26/2012)
July 26, 2012 at 1:12 pm
Stefan Krzywicki (7/26/2012)
GilaMonster (7/26/2012)
And the vague question of the week award goes to: http://www.sqlservercentral.com/Forums/Topic1336028-391-1.aspx
The very phrasing of the question makes me think this person isn't up to the task. I...
July 26, 2012 at 12:59 pm
morepainot (7/26/2012)
July 26, 2012 at 11:31 am
L' Eomot Inversé (7/26/2012)
Sean Lange (7/26/2012)
July 26, 2012 at 11:08 am
It is pretty hard to help much without something to work with. We would need to see ddl, some sample data and desired output. Obfuscate your data to protect real...
July 26, 2012 at 10:59 am
cox1ray (7/26/2012)
July 26, 2012 at 10:04 am
capn.hector (7/26/2012)
vchandm23 (7/25/2012)
@whereSql nvarchar(256)
AS
EXEC('SELECT [fields] FROM WHERE ' + @whereSql)
GO
From stackOverflow website. This is what i was looking for. I am sharing this...
July 26, 2012 at 9:28 am
Stefan Krzywicki (7/26/2012)
Sean Lange (7/26/2012)
Stefan Krzywicki (7/26/2012)
Sean Lange (7/26/2012)
July 26, 2012 at 9:12 am
manub22 (7/26/2012)
It is true you can make cursors more optimal than a while loop but why bother with them at all? In your examples there is absolutely nothing that can't...
July 26, 2012 at 9:07 am
Viewing 15 posts - 11,176 through 11,190 (of 15,376 total)