I found some code that creates a Proper Case function for SQL 2005 - however, not being a SQL Server 2005 expert, I am confused by what type of function to create - Table-Valued, Scalar, In-li...
Hi, I'm trying to write a stored procedure to select data from multiple tables based on date.
Example (in kinda psuedo):
I want to select the [EventID] and [Title] from dbo.Events
Where...
Hi Experts
I have a mysql database set up on my server. It is set yo the US format yyyy-mm-dd. I want it to be changed to UK format dd-mm-yyy.
The reason for this is when we do inserts into ...
Hello,
I'm using ASP and MS Access.
I would like to retrieve value from same field name with different table.
I have tables called Categories and Items
Both tables contain field name ca...
Hi, can anybody tell me what's wrong with this SQL? Is driving me crazy already.
I keep getting the Syntax error (missing operator) in query expression.
I'm developing in VS and in one form I would like to display a list (which can grow) of services which can be ticked or unticked related to the customer table.
Wihtin SQL I would like to kn...
I'm having problem with getting right value in Comment and ImageID.
SELECT
C.*,
E.*,
B1.ImageID AS LatestImageID,
B2.Comment AS LatestComment
FROM ((Customers C LEFT JOIN E...
this query is calculating the Sum of "total line items" for each "Cat_Com"
and populating it as "This Week"
is it possible to calculate the Sum of "total line items" for each "Processor"
?
I have two tables tblTemplateClinicalData and tlkpClinical. I am trying to write a query that will show all data in tlkpClinical where it has an ItemType of SiteOfOrigin. I then want to show a...
I have 2 columns and i want to find whihc one is the max date out of the 2 columns. Idealy i need the max date to then be put in a third column so that i can use this column to run an update.
...
The best way to ask my question is to present an example:
I have a view called List_Of_Active_Combined_Respondents_With_Counts
It has columns and sample data as follows:
Respondent_Email ...
I an trying to select some information and it is telling me the following.
Syntax error converting datetime from character string. It is wher I am saying the dtPayProcessed should be NULL, b...
Hi,
I am trying to use formula templates in my application
I have table with the formula templates for different scenarios. TableName = CorrRules. Each scenario has a scenarioID in this ...
I have a query in Access that uses a function to get the month and year from a date field. I pasted the query below. I checked the data type in the table it is querying, and the field is defin...
Is there a tool to easily convert Excel columns into SQL Create Table
Ex: I have col1,col2,col3 and want to
CREATE TABLE table_name
(
col1 data_type,
col2 data_type,
col3 data_type
)
I have a Union query that will not return duplicate records. If I run each select statement by itsel,f I get a record with a que_rpt_Schedule_s1.ID (first field) of 11605. In the union query ...
Looking for some help with trying to write a stored procedure that will update 2 columns with values from another tables columns. I have a table that holds inventory items for both wherehouse ...
Posted - 12/07/2007 : 20:29:52
--------------------------------------------------------------------------------
Dear all,
I have an app that tracks all projects and captures thos...
Hi,
I am using ms sql server 2005. I am running queries into Server Management Studio Express.
If I make two queries, one for one column, the second for all columns, why are the results...
I have a table that contains several thousand members. I am trying to hash the existing password column. I have created a new, empty password column to contain the hashed passwords (Password...
I have a table tb_nmp_ascii_h which has columns metric_month, metric_num, clec_id and tperm_score
Another table is tb_nmp_ascii_prod which has the same columns.
I need to update tperm_scor...
Team,
I have 2 columns of data in a table. Column A contains dates and column B also contains dates. What I would like to do is output a third column which tells me the latest of the 2 date...
i want to exclude and n/a or blank values in this statement, possible?
thanks
I need help transforming a weird data structure into another weird data structure. If anyone has any ideas, I would really appreciate them.
THANKS!
Starting Table
Name Address Phone ...
I have a query that I want to count all the dates less than a month old and then a query that I want to count all the dates in the last calendar year
