Search results for query: *

yes, that looks better, and I could turn it into a UDF, so that it became select dbo.myweek(datefield) ...

No, but I would love to hear about one.

I finally found this: http://groups.google.dk/groups?hl=da&lr=&ie=UTF-8&oe=UTF-8&selm=OwxJxipYDHA.736%40TK2MSFTNGP09.phx.gbl&rnum=5 and it has pointed me in the right direction. I can now detect if my pc is running client.exe, and ignore if the pc next door is running client.exe (both under...

rosenk, It looks like a good approach, but it returns my name instead of the real user that I can see in Task Manager. obislavu, the problem is the "...if it is not running ...". How do I determine this when using Citrix? I hope that you have further suggestions, as I at a loss on...

I'm using GetProcessByName to try to figure out if another program is already running on the users pc. It works; I can see if "client.exe" is running, and if not, I can start it. I now have a client that is using Citrix. Here my call to GetProcessByName is listing for all users...

That was fast, and it works too. Thank you very much.

Our users have different screen sizes, and we would like to run our application in two different sizes; 24x80 and 30x132 lines/columns. Our terminal software (K95) supports this. Our software supports this, but need to have two envirronment variables set (LINES and COLS). I would like our...

pulsar6, I think I would add an integer field, with a auto-incrementing number on it. As in [testfield] [int] IDENTITY (1, 1) NOT NULL and use this as a primary key on all 4 tables. Deletions are a lot easier when you can select out a single record. Regards Henrik

Leon, They do run in sequential order, as you have found out. I've found out the hard way, because I had a spoc sending out an email. The email system got stuck, and my SQL server frose up right behind it. We changed the system, so that the sproc inserted a record in a new table. Then we had a...

Derick, How? Just assemble your SQL string with the name of the view instead of the table name. As in Select * from CustomerAll where CustomerAll is the name of the view. or to use your example Update dbo.CustomerAll SET REF = CASE LEFT(ORDER, 7) WHEN '123123' THEN 23 +...

Hi Derick, On one of my database, I've a table for each calendar year and month. As in Order2003_09, Order2003_08 etc. I've set up a view that spans all these tables. It goes create view myview as select * from Order2003_09 UNION ALL select * from Order2003_08 go When a new table is...