Viewing 15 posts - 496 through 510 (of 620 total)
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...
November 13, 2007 at 5:11 pm
siboyd07 (11/13/2007)
This is my first time at creating a function. What is the @list supposed to...
November 13, 2007 at 2:13 pm
siboyd07 (11/13/2007)
Try using select dbo.fnSplitMsg(msg).
November 13, 2007 at 2:00 pm
http://www.sqlservercentral.com/Forums/Topic242919-8-1.aspx
I think this is the post you are talking about
November 13, 2007 at 1:50 pm
jones.justinw (11/13/2007)
November 13, 2007 at 1:46 pm
Matt Miller (11/13/2007)
November 13, 2007 at 11:53 am
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...
November 13, 2007 at 10:30 am
Jeff Moden (11/13/2007)
Andy, what the max number of parts a given assembly can have? There's a reason why...
November 13, 2007 at 8:11 am
andy.dawson (11/13/2007)
Even if this did exactly what I wanted, I wouldn't be able to administer it because I just 'don't get...
November 13, 2007 at 7:05 am
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...
November 12, 2007 at 9:44 am
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. ...
November 12, 2007 at 7:00 am
Jeff Moden (11/9/2007)
Matt Miller (11/9/2007)
November 9, 2007 at 10:40 pm
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 =...
November 9, 2007 at 5:32 pm
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. ...
November 9, 2007 at 2:08 pm
Ok, i'm a little confused. Your query,...
andy.dawson (10/24/2007)
FROM BOM INNER JOIN Stock ON BOM.Field3=Stock.stStockCode
WHERE (((BOM.Field1)=[Enter Part...
November 9, 2007 at 9:48 am
Viewing 15 posts - 496 through 510 (of 620 total)