Viewing 15 posts - 301 through 315 (of 621 total)
Daryl, if you post some table structure and sample data, someone can probably help you figure it out.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 27, 2009 at 6:07 pm
I'm no expert on this stuff by any means, but BOL says...
text
Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters....
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 21, 2009 at 8:27 am
You need to know the dimensions of the bottles, not necessarily only the volume. Why don't you make one of each size box, and see which one holds the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 20, 2009 at 3:13 pm
Probably should be one "datum" 🙂
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 20, 2009 at 2:54 pm
Maybe you could just add it as another parameter in one of your stored procedures?
USE [OHT]
GO
/****** Object: StoredProcedure [dbo].[GetLookingFor] Script Date: 05/18/2009 11:09:30 ******/
SET ANSI_NULLS ON
GO
SET...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 19, 2009 at 10:48 am
GSquared (5/19/2009)
Get rid of the semicolons, the function will still run, it's just less "clean".
I often see code with semicolons here, but usually without. I have queried in DB2...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 19, 2009 at 10:36 am
Check out Books On Line for "expanding heirarchies"
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 18, 2009 at 3:57 pm
Chris, this seems like a much better solution than mine. After messing around with it a bit, I can understand what it is doing for the most part, but...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 9:12 am
Lynn Pettis (5/14/2009)
It is a scope issue.
Ah ha. Not too familiar with what scope is, or how it affects things. Thanks for the tip.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 8:39 am
Christopher Stobbs (5/14/2009)
Here is a dynamic unpivot solution with not temp tables or table variables.
I must admit that I found this code...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 8:36 am
mdowns (5/14/2009)
Why not just...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 7:51 am
Christopher Stobbs (5/14/2009)
Or you could try this:
DECLARE @sql VARCHAR(200)
SELECT @sql = 'DECLARE @table TABLE
(
col1 CHAR(1)
)
INSERT INTO @table...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 7:49 am
Thanks both, but its back to the drawing board. When I tried your solutions, I got...
Server: Msg 197, Level 15, State 1, Line 7
EXECUTE cannot be used as a...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 14, 2009 at 6:49 am
Well, I guess I can now also take the liberty of assuming maybe this is not what the OP was looking for. (crickets chirping)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 13, 2009 at 3:56 pm
See if this article does not give you what you need.
http://www.sqlservercentral.com/articles/Test+Data/61572/
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 13, 2009 at 7:39 am
Viewing 15 posts - 301 through 315 (of 621 total)