Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 475
Search took 0.03 seconds.
Search: Posts Made By: Jeff Moden
Forum: SQL Server 2000 September 6th, 2018, 01:16 PM
Replies: 8
Views: 224,131
Posted By Jeff Moden
Don't bother... previous poster is a low life spammer

Title of this post says it all...
Forum: SQL Server 2000 March 7th, 2017, 01:08 AM
Replies: 10
Views: 76,909
Posted By Jeff Moden
Sorry I'm late...

I don't know why this forum doesn't send me an email any more but, Ryan, thank you for your feedback about two years ago. Much appreciated.
Forum: SQL Server 2005 June 25th, 2011, 09:31 PM
Replies: 1
Views: 2,775
Posted By Jeff Moden
You can't use CASE as if it were an IF in any...

You can't use CASE as if it were an IF in any language. It has to be a part of an "assignment". Give the following a try and see if it does what you want.

...
Forum: SQL Server 2000 June 24th, 2011, 08:29 AM
Replies: 10
Views: 1,918
Posted By Jeff Moden
Hi Rob, There's no difference between 2000...

Hi Rob,

There's no difference between 2000 and 2005 if the DBA allows for the Tally and Calendar (which can be expanded for other utility) tables. If the DBA doesn't allow it, then the use of a...
Forum: SQL Server 2000 June 23rd, 2011, 08:26 AM
Replies: 10
Views: 1,918
Posted By Jeff Moden
Here we go. As always for me, the explanation for...

Here we go. As always for me, the explanation for everything is in the code. For more information about how a Tally table works, please see the following URL. A Calendar table works in a similar...
Forum: SQL Server 2000 June 23rd, 2011, 07:17 AM
Replies: 10
Views: 1,918
Posted By Jeff Moden
Nope. That'll do it. One solution for SQL...

Nope. That'll do it. One solution for SQL Server 2000 coming right up. This would be a bit easier in SQL Server 2005 and up but it's relatively simple in SQL Server 2000.
Forum: SQL Server 2000 June 22nd, 2011, 03:22 PM
Replies: 10
Views: 1,918
Posted By Jeff Moden
Hi Rob, My recommendation is that, although...

Hi Rob,

My recommendation is that, although quite clever, using a VB app for this very simple task is the wrong way to do it.

Again, if you'll post some data as INSERT statements, I'll show...
Forum: SQL Server 2000 June 22nd, 2011, 10:42 AM
Replies: 10
Views: 1,918
Posted By Jeff Moden
Rob, I'm on my way to work and I can't get...

Rob,

I'm on my way to work and I can't get to this right now. If you could post, say, 10 rows of test data (in the form of INSERT statements for a table would be really great!), it would save me...
Forum: SQL Server 2005 February 16th, 2011, 10:22 PM
Replies: 6
Views: 1,141
Posted By Jeff Moden
BWAA-HAAA!!! I just saw who posted this! Long...

BWAA-HAAA!!! I just saw who posted this! Long time no see, Tony! Still working at the same site, I see.
Forum: SQL Server 2005 February 16th, 2011, 10:19 PM
Replies: 6
Views: 1,141
Posted By Jeff Moden
Note to self and anyone else who likes formatted...

Note to self and anyone else who likes formatted code. You have to copy from SSMS into NotePad and then paste between the CODE tags to get proper space indentation. Of course, that removes all...
Forum: SQL Server 2005 February 16th, 2011, 10:18 PM
Replies: 6
Views: 1,141
Posted By Jeff Moden
Just trying a formatted post again to see what...

Just trying a formatted post again to see what gives.

SELECT CASE
WHEN CHARINDEX('BBOY', Name) > 0
THEN NULLIF(SUBSTRING(Name, CHARINDEX('BBoy' , Name) + 4, 1), ' ')
...
Forum: SQL Server 2005 February 16th, 2011, 10:16 PM
Replies: 6
Views: 1,141
Posted By Jeff Moden
As a side bar, the CODE formatter for this site...

As a side bar, the CODE formatter for this site really messes up code. It's one of the reasons I don't post here often.
Forum: SQL Server 2005 February 16th, 2011, 10:15 PM
Replies: 6
Views: 1,141
Posted By Jeff Moden
Your solution returns space, B, T for me. ...

Your solution returns space, B, T for me.

Try this instead...

SELECT CASE WHEN CHARINDEX('BBOY', Name) > 0
THEN NULLIF(SUBSTRING(Name, CHARINDEX('BBoy' , Name) + 4, 1), '...
Forum: SQL Server 2000 January 22nd, 2011, 01:02 PM
Replies: 3
Views: 1,930
Posted By Jeff Moden
You're very welcome. Thank you for the feedback.

You're very welcome. Thank you for the feedback.
Forum: SQL Server 2000 January 11th, 2011, 12:53 PM
Replies: 3
Views: 1,930
Posted By Jeff Moden
SELECT DATEDIFF(dd,'2010-12-25','2011-1-25') ...

SELECT DATEDIFF(dd,'2010-12-25','2011-1-25')

Your choice as to whether to add "1" to that or not.
Forum: SQL Server 2000 November 16th, 2010, 11:11 PM
Replies: 3
Views: 4,453
Posted By Jeff Moden
Ummm.... passwords use hashing in that table....

Ummm.... passwords use hashing in that table. Pardon the pun but a simple conversion isn't going hack it.
Forum: SQL Server 2000 November 16th, 2010, 03:51 AM
Replies: 3
Views: 4,453
Posted By Jeff Moden
Did you try converting using NVARCHAR? It's...

Did you try converting using NVARCHAR?

It's hard to tell what's happening with your code unless you post the Varbinary value.
Forum: SQL Server 2005 September 16th, 2010, 06:58 PM
Replies: 3
Views: 538
Posted By Jeff Moden
And, no... it's not a 100% equivalent. There's...

And, no... it's not a 100% equivalent. There's not much that's 100% equivalent between Oracle and SQL Server.
Forum: SQL Server 2005 September 16th, 2010, 06:54 PM
Replies: 3
Views: 538
Posted By Jeff Moden
I believe that what you're looking for is OSQL....

I believe that what you're looking for is OSQL. Either that or you can create a "graphical" script using SSIS. Read about both in Books Online which is the help system that comes with SQL Server.
Forum: SQL Server 2005 August 18th, 2010, 06:05 PM
Replies: 7
Views: 1,144
Posted By Jeff Moden
Full Text Search???

Wouldn't it be better to instantiate Full Text Search for this?
Forum: SQL Server 2000 December 6th, 2009, 10:46 PM
Replies: 11
Views: 4,651
Posted By Jeff Moden
You have two FROM clauses and two WHERE clauses. ...

You have two FROM clauses and two WHERE clauses. If you want to reference two tables, you must do some sort of JOIN between the two tables (INNER, OUTER, whatever) with an ON clause and any WHERE...
Forum: SQL Server 2005 September 8th, 2009, 11:14 PM
Replies: 5
Views: 1,295
Posted By Jeff Moden
I have to tell you that storing formatted data in...

I have to tell you that storing formatted data in a database is absolutely one of the very worst things you can do to a database. Stop and think about what such left padding will do to simple WHERE...
Forum: SQL Server 2000 September 6th, 2009, 06:39 AM
Replies: 3
Views: 1,587
Posted By Jeff Moden
Possibly... the first thing to do would be to...

Possibly... the first thing to do would be to check the trigger code (or course). Would you post the trigger code, please?
Forum: SQL Server 2005 August 17th, 2009, 10:26 AM
Replies: 2
Views: 1,469
Posted By Jeff Moden
Yes... it's not only possible but it's easy to...

Yes... it's not only possible but it's easy to do, as well. I'm at work and don't have the time (right now) to write some code for your specific example, but here's a pretty good article on it.
...
Forum: SQL Server 2005 June 1st, 2009, 01:18 AM
Replies: 3
Views: 4,454
Posted By Jeff Moden
Heh... cool. Just don't mispell Chlorine like I...

Heh... cool. Just don't mispell Chlorine like I did. [:D]
Showing results 1 to 25 of 475

 


All times are GMT -4. The time now is 03:33 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.