Search results for query: *

so after most of a days work I have all but my WHERE statment completed. Use TestDB SELECT TS as ID, Step, [Date_Completed] as [Date Completed], Step2, [Follow_Up] as [Follow up Date] FROM (SELECT ID, LG_Note_Ordered_C as [LG Note Ordered], SCRA_Referral_C as [SCRA Referral], LG_Recvd_C as...

okay, I've figured out that what I was looking for was the unpivot command. From the example I was given I can unpiviot half of what I need to do. I've listed the two queries I need to merge so I end up with columns: TS, Step, Date_Completed, Follow_Up_Date SELECT TS, Step, [Date_Completed]...

By Horizontal I mean Column 1 -6 would be normal columns in a table. I need to take a normal table Column1,Column2,Column3,Column14,Column5,Column6, Date Started, DateCompleted Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data, Data...

Hello, Not sure if there is any basic info you need to know...I'm running SQL Server 2008 Standard. I need to create a query that has data from multiple columns (Columns 1-6 with coresponding Date started and Date Completed data) displayed vertically, but also has the column name the...

Hello, Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end. I need to find a way to attach documents via my access front end. I've done some research and there seems to be quite the debate about how this should be done. I don't have a full understanding about the...

How do bound my form to more than one table using a SQL statement when I need to do an update? Do you have any simple examples I can look at? Thank you! David92595

Hello, Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end. I need to find a way of opening up a form that is joined to more than one table in the backend. The users have to be able to enter information and update the corresponding tables with the new data in the...

Thanks, I'm still new to this site...

Hello, Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end. I need to find a way of opening up a form that is joined to more than one table in the backend. The users have to be able to enter information and update the corresponding tables with the new data in the...

One of our clients is now requiring us to harden (I think is the correct term) our network and user PC's. More specifically our client PC's, I need to find a guide to lock down everything from screen savers to access to the control panel and network tree. Does anyone know of a reputable site...

I get them from a report on our SBS Server (Parent Server) David92595

I recently had to archive a users Outlookthat reached it's 2gb limit on the exchange server. To my suprise when I looked at how much space he was still using it had only gone from 2,049.2mb to 1,638.8mb. I archived everything older than 3 months ago and I know for a fact that he has not gotten...