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 95
Search took 0.01 seconds.
Search: Posts Made By: Gert
Forum: SQL Server 2005 July 3rd, 2009, 07:57 AM
Replies: 1
Views: 627
Posted By Gert
You can not join a varchar column with a numeric...

You can not join a varchar column with a numeric column, How ever, it should work if you convert the numeric-column to varchar in the join.
Forum: SQL Language May 29th, 2008, 03:22 AM
Replies: 2
Views: 1,026
Posted By Gert
If you use punctuation, it might be a little...

If you use punctuation, it might be a little easier for others to read your post.
Forum: SQL Server 2005 December 17th, 2007, 11:10 AM
Replies: 9
Views: 1,278
Posted By Gert
Hi. Are you sure Jeff's code doesn't do what...

Hi.

Are you sure Jeff's code doesn't do what you want?
Since he is joining the [Tablename] with the #myhead-table on the distinctive Tel-coloumn, then only the last of the updates for a duplicate...
Forum: SQL Server 2000 August 17th, 2007, 05:13 AM
Replies: 10
Views: 2,776
Posted By Gert
Yes indeed, and I have no objection to your...

Yes indeed, and I have no objection to your objection :)

I really did like your solution better, so the praising was well meant... no ulterior motive behind that.

Keep up the good work.

Gert
Forum: SQL Server 2000 August 17th, 2007, 03:42 AM
Replies: 10
Views: 2,776
Posted By Gert
Hmm, I must admit that your solution was a bit...

Hmm, I must admit that your solution was a bit more clever than mine, Peter, but since the OP was grateful for ANY help (and no one had given it), I went for the solution I could come up with at the...
Forum: SQL Server 2000 August 16th, 2007, 04:01 AM
Replies: 10
Views: 2,776
Posted By Gert
Hi. The following code will return the next...

Hi.

The following code will return the next saturday for any @@DATEFIRST settings. If the given date IS a saturday, then it will return the saturday a week later. There is no need to adjust for...
Forum: SQL Server 2005 August 7th, 2007, 05:38 AM
Replies: 3
Views: 631
Posted By Gert
Hi. As far as I know, you need to use both...

Hi.

As far as I know, you need to use both update and insert.
For the insert you could try something like this:

INSERT INTO Table1(ID,product1,...)
SELECT ID, product1,...
FROM Table2 t2...
Forum: SQL Language February 16th, 2007, 04:33 AM
Replies: 3
Views: 755
Posted By Gert
Hi. Can't you just group by the id's, and...

Hi.

Can't you just group by the id's, and then do a join against the user table afterwards to get the names?

best regards
Gert
Forum: SQL Server 2000 September 5th, 2006, 07:17 AM
Replies: 8
Views: 1,796
Posted By Gert
Hi. You could do like this: select...

Hi.

You could do like this:

select cast(convert(varchar,getdate()-2,103 ) as datetime)

Gert
Forum: Visual C++ August 28th, 2006, 12:58 AM
Replies: 1
Views: 1,148
Posted By Gert
http://p2p.wrox.com/topic.asp?TOPIC_ID=46719

http://p2p.wrox.com/topic.asp?TOPIC_ID=46719
Forum: SQL Server 2000 August 24th, 2006, 05:15 AM
Replies: 11
Views: 7,968
Posted By Gert
Hi. Try to use the format YYYYMMDD instead. ...

Hi.

Try to use the format YYYYMMDD instead.

Gert
Forum: SQL Server 2000 August 22nd, 2006, 11:10 AM
Replies: 11
Views: 7,968
Posted By Gert
Hi. As Peso says, you do not need dynamic...

Hi.

As Peso says, you do not need dynamic SQL. Your in-parameter is of type DateTime and does not need to be converted. But, you need to make sure that if you use a string when calling the...
Forum: SQL Server 2000 August 15th, 2006, 09:04 AM
Replies: 4
Views: 900
Posted By Gert
Hi You could look at the CASE statement in...

Hi

You could look at the CASE statement in BOL. That might help you out.

Gert
Forum: SQL Server 2000 August 11th, 2006, 08:12 AM
Replies: 2
Views: 3,029
Posted By Gert
I belive the ON clause should come after every...

I belive the ON clause should come after every join..

FROM tblClient INNER JOIN tblCredit ON tblClient.WorkFileNo = tblCredit.WorkFileNo INNER JOIN tblDebit ON tblClient.WorkFileNo =...
Forum: Visual C++ August 1st, 2006, 08:25 AM
Replies: 1
Views: 2,916
Posted By Gert
Hi. You need to use a callback function i...

Hi.

You need to use a callback function i think (long time since I did this myself). Try to find some useful tips at Codeproject.com

http://www.codeproject.com/listctrl/

Gert
Forum: SQL Server 2000 August 1st, 2006, 02:28 AM
Replies: 3
Views: 1,123
Posted By Gert
Peso, isn't that what for instance SQL Management...

Peso, isn't that what for instance SQL Management Studio does when you open a query-window against a DB? Will not that connection be held for the duration of the query-window?

best regards
Gert
Forum: SQL Language June 21st, 2006, 12:56 AM
Replies: 2
Views: 6,102
Posted By Gert
Hi. Maybe you should try posting in a C#...

Hi.

Maybe you should try posting in a C# forum? This is SQL Language.

Gert
Forum: SQL Server 2005 May 26th, 2006, 03:55 AM
Replies: 4
Views: 1,119
Posted By Gert
Hi, and thanks to both of you for your replies. I...

Hi, and thanks to both of you for your replies. I have been away since last friday, and have not seen your posts until today.

I apologize if my explanation of the problem was poor, but Davids...
Forum: SQL Server 2005 May 19th, 2006, 04:03 AM
Replies: 4
Views: 1,119
Posted By Gert
Overlapping id's problem

Hi.

Hi have this problem that will be a bit difficult to explain, but I will do my best:


I have a temp-table with following columns (all int):

TempId LogId AlternativeLogId

None...
Forum: SQL Server 2000 May 13th, 2006, 03:28 AM
Replies: 1
Views: 5,748
Posted By Gert
Hi The percentage of (t.regularhours) in...

Hi

The percentage of (t.regularhours) in relation to what? You need to have a base in order to calculate percentage.

If you have 10 hours, it doesn't make sence to say: "how many percentage is...
Forum: SQL Language May 10th, 2006, 02:48 AM
Replies: 0
Views: 762
Posted By Gert
Finding min(FromDate) and max(ToDate)

Hi.

I have at table (in SQL-SErver 2005) with the following fields:

PlantId - varchar
FromDate - datetime
ToDate - datetime
Amount - decimal
Forum: SQL Server 2005 April 26th, 2006, 01:47 PM
Replies: 5
Views: 2,840
Posted By Gert
Thanks ALOT David. This is just what I was...

Thanks ALOT David. This is just what I was looking for...

It also works with copy/paste into Excel.

:-)

Gert
Forum: SQL Server 2000 April 22nd, 2006, 05:16 AM
Replies: 4
Views: 14,135
Posted By Gert
Scott, I belive the ISOWeek function gives you...

Scott, I belive the ISOWeek function gives you the weeknumber of the year, not the month as Kavita asks for.

Gert
Forum: SQL Server 2005 April 19th, 2006, 03:45 AM
Replies: 5
Views: 2,840
Posted By Gert
Thanks for your replies. Allthough these are...

Thanks for your replies.

Allthough these are good sugestions, it seems to me that if I want the info into Excel, it doesn't work just as I need it too. In excel all the row data ends up in the...
Forum: SQL Server 2000 April 3rd, 2006, 08:03 AM
Replies: 9
Views: 1,197
Posted By Gert
Hi again. Maybe something like this? ...

Hi again.

Maybe something like this?

Select @MidVchar = @MidVchar + RIGHT('00000'+convert(varchar(10),@PreId),5)

Gert
Showing results 1 to 25 of 95

 


All times are GMT -4. The time now is 10:13 AM.


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