Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by BogdanRo
-
SQL Question
In SQL Server 2000 first you must create a function SSum (string sum): CREATE FUNCTION SSum (@id AS INT) RETURNS VARCHAR(255) AS BEGIN DECLARE @text AS VARCHAR(255) DECLARE @rez AS VARCHAR(255) DECLARE crs CURSOR FOR SELECT TaskName FROM ... WHERE StockID = @id OPEN crs FETCH NEXT FROM...- BogdanRo
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Viewing Access queries in SQL
Hi MS Access 2000 (not 97) has a new project type : *.adp Access data project which permits to connect directly to a SQL Server. You may manage tables, views, stored procedures (stored in a SQL Server database) from this type of project and you may create also forms, report, modules, macros...- BogdanRo
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Problems with a delete mdf file
Your dba is an IDIOT. You may restore your database from a backup. If you have a backup for database. If no ... by by db Sorry !- BogdanRo
- Post #2
- Forum: Microsoft SQL Server: Programming
-
IIF IN A VIEW QUESTION
SELECT ID, Name, Stock, IIF( Stock >= 1000 , "ok" , "not ok" ) FROM Product in MS Access- BogdanRo
- Post #4
- Forum: Microsoft SQL Server: Programming
-
IIF IN A VIEW QUESTION
You may use "CASE WHEN ... ". For example if you have a table Product( ID , Name , Stock ) where id = primary key SELECT ID, Name , Stock , Info = CASE WHEN Stock >= 1000 THEN 'OK' ELSE 'not ok' FROM Product (SQL Server version) is equivalent with SELECT ID, Name...- BogdanRo
- Post #3
- Forum: Microsoft SQL Server: Programming
