Greg Snidow

Forum Replies Created

Viewing 15 posts - 496 through 510 (of 621 total)

RE: INSERT into Excel leaves values as text

Why don't you use linked spreadsheets rather than exporting to Excel? If you have to send the same report out every week, or whenever, you could use a linked...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 5:11 pm

#750892
RE: Splitting a msg field with delimiter and creating a function to separate the field to multiple lines

siboyd07 (11/13/2007)
But I don't get any error messages when I create and execute the function.
This is my first time at creating a function. What is the @list supposed to...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 2:13 pm

#750839
RE: Splitting a msg field with delimiter and creating a function to separate the field to multiple lines

siboyd07 (11/13/2007)
select fnSplitMsg[msg])... /quote]
Try using select dbo.fnSplitMsg(msg).
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 2:00 pm

#750836
RE: Pivot Table Help

http://www.sqlservercentral.com/Forums/Topic242919-8-1.aspx
I think this is the post you are talking about
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 1:50 pm

#750832
RE: Pivot Table Help

jones.justinw (11/13/2007)
The work that I have to date done on this problem is based on another topic in these forums. I cannot recall the name of the person on...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 1:46 pm

#750830
RE: Using join in delete operation

Matt Miller (11/13/2007)
Greg - it DOES explain why. It's just hard to make an explanation of a confusing syntax not also be confusing:) Note that this link has...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 11:53 am

#750794
RE: Using join in delete operation

BOL does list that you can have two from clauses in a delete statement, but it does not really say why, at least not in English. It is kind...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 10:30 am

#750762
RE: Recursive query for a Bill of Materials table

Jeff Moden (11/13/2007)
Guess I'm just gonna have to document that proc from BOL... 😛
Andy, what the max number of parts a given assembly can have? There's a reason why...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 8:11 am

#750703
RE: Recursive query for a Bill of Materials table

andy.dawson (11/13/2007)
I might have to bail out on this one! 🙁
Even if this did exactly what I wanted, I wouldn't be able to administer it because I just 'don't get...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 13, 2007 at 7:05 am

#750661
RE: Recursive query for a Bill of Materials table

andy.dawson (11/12/2007)
Thanks for taking the time to have a closer look.
When I use your code I get an error:
"Error 208: Invalid object name 'expand'"
Any ideas?
Sorry, you need to change the...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 12, 2007 at 9:44 am

#750306
RE: Recursive query for a Bill of Materials table

Jeff Moden (11/11/2007)
You didn't listen to me... lookup "expanding hierarchies" in Books Online and adapt it. It WILL do as you ask.
Jeff, once again you were exactly correct. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 12, 2007 at 7:00 am

#750232
RE: Recursive query for a Bill of Materials table

Jeff Moden (11/9/2007)
Matt Miller (11/9/2007)
If it's a process THIS expensive, you should consider making this a permanent table. Meaning - keep the existing table just as it is, and...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 9, 2007 at 10:40 pm

#750038
RE: insert

Sergiy (11/9/2007)
WRONG!!!
Greg, your script will update whole tableA with occasional values from tableB.
[Code]
UPDATE a
SET jobno = b.jobno,
jobname =...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 9, 2007 at 5:32 pm

#750019
RE: Recursive query for a Bill of Materials table

Andy. I was messing around with your spreadsheet today and this is what I came up with in my attempt to understand what the BOL procedure is doing. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 9, 2007 at 2:08 pm

#749989
RE: Recursive query for a Bill of Materials table

Ok, i'm a little confused. Your query,...
andy.dawson (10/24/2007)
SELECT [Field5]*[Enter Build Quantity] AS Expr1, BOM.Field1, BOM.Field2, BOM.Field3, BOM.Field4, BOM.Field5, BOM.Field6, Stock.stTempBinLocation, Stock.stUser1
FROM BOM INNER JOIN Stock ON BOM.Field3=Stock.stStockCode
WHERE (((BOM.Field1)=[Enter Part...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.

November 9, 2007 at 9:48 am

#749911

Viewing 15 posts - 496 through 510 (of 621 total)