Viewing 15 posts - 7,456 through 7,470 (of 13,460 total)
well based on your data, see what this does for you:
it's assuming less than 10 on the quantity, but it's close;
the assumption of 12 char descrip doesn't work as...
June 3, 2011 at 3:30 pm
kinda fun guessing for now:
assuming you inserted the data into a table with an indeity, i'm joining on found rows to get the price;
it also looks like the descriptiuon is...
June 3, 2011 at 2:26 pm
ahhh ok; definitely more helpful;
State 38 is:
Reason: Failed to open the database specified in the login properties.
June 3, 2011 at 1:44 pm
if you only need the UPC, it looks like you could search for the # sign, and either a space or the end of the row.
this example SEEMs to work...
June 3, 2011 at 1:37 pm
bhoff (6/3/2011)
yeah, I was just thinking about that. The configurations for each are identical in the "HyperBac Configuration Manager", so I don't see how it could matter
i don't either, and...
June 3, 2011 at 11:37 am
only difference i see, beside the REPLACE command at the end, is the wizard script uses file extensions of .vndf and yours is .vmdf
June 3, 2011 at 11:26 am
Guras (6/3/2011)
In SQl server management studio
running sp_who2 active ...
June 3, 2011 at 11:16 am
the example converts string to datetime...then if you want a specific format, you've got to convert it back again:
--Results
/*
2007-07-30
*/
Select convert(varchar(10),convert(datetime, N'30-07-2007', 105) ,120)
June 3, 2011 at 11:06 am
i would swear at one of the SQL Pass sessions, they mentioned that the SSMS 2005 GUI would not save multiple plans, and that they fixed in in 2008 and...
June 3, 2011 at 10:58 am
yep...you've got to try to get away from cursor/loop line by line thinking.
does this work like you expect?
INSERT INTO #names([Name])
...
June 3, 2011 at 10:24 am
can you put the code on a web page, wether an intra- or internet?
that'd be simplest...single source, accessible from each desktop, web page could provide results and error...
June 3, 2011 at 8:07 am
just the obvious:
sql server management studio replacement
what's wrong with the Microsoft tools again?
June 3, 2011 at 6:47 am
obvious choice would be to simply install the SSMS Client tools.
Another option would be an application like LinqPad, which has most of the things you'd look for in an app:...
June 3, 2011 at 6:32 am
duplicate post.
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1119355-146-1.aspx
June 3, 2011 at 6:28 am
EM as in SQL 2000 Enterprise Manager?
can you explain a little better what you want? are you looking for a GUI application to access SQL 2008? like SQL Server Management...
June 3, 2011 at 6:25 am
Viewing 15 posts - 7,456 through 7,470 (of 13,460 total)