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 Chriss Miller 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 emueth
-
Multi-step query question
Let me back up a bit and give a broader view of what I'm getting at. The client makes widgets and each widget can have multiple employees associated with it. This is stored in a table: Widget Employee 1 7700 1 7590 1 7549 This application tracks bug reports... -
Multi-step query question
I need to run the following query. The code runs fine in SQL but I'm not sure what to do with it in Cold Fusion. I am using SQL 7 and CF5. The query (with hardcoded values instead of variables) is: DECLARE @emps varchar(50) SELECT @emps = COALESCE(@emps + ';', '') + e.last_name FROM... -
Bit query in SQL
I have a Cold Fusion application with a SQL 7 database. The database has an employee table with a bit field for storing certain permissions. How do I write my sql statement to, for example, return all employees that meet the criteria of a bitand on the fourth bit? Thanks in advance for the help. -
SQL bit query
I have a Cold Fusion application with a SQL 7 database. The database has an employee table with a bit field for storing certain permissions. How do I write my sql statement to, for example, return all employees that meet the criteria of a bitand on the fourth bit? Thanks in advance for the help.- emueth
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
