Viewing 15 posts - 31 through 45 (of 314 total)
Would u have any records with time part in uMonth column:
'9/1/2006 00:15:00' or '9/1/2006 23:55:59'
If you have time part then your between won't get u all the data as neither...
October 27, 2006 at 11:42 am
Have u looked at the indexes to find out if thats causing the issue.
October 27, 2006 at 11:04 am
I think this is where the problem is:
and t.uMonth between convert(datetime, '01-Sep-2006') and convert(datetime, '01-Sep-2006')
what does t.uMonth have? Is it date field? If so do u have values other than...
October 27, 2006 at 10:41 am
Need more Explaination:
1. whats the key on table1.
2. are there any other field in table2 to join against table1.
Here is what I think u have.
Table1
-------
StudentID Name Address
1111 AAAA XYZADDRESS
2222 BBBB ...
October 26, 2006 at 4:28 pm
I don't know why you would want dynamic sql. I hope I understand ur question. Here is a code based on pubs database.
Declare @SvcNameValue varchar(40)
Declare @FromString varchar(50)
Declare @ToString varchar(50)
SET @FromString...
October 26, 2006 at 4:19 pm
If its a simple on demand query u can set up an excel with "Import External Data" query and they can run on demand.
October 26, 2006 at 11:01 am
During parent table insert you have to create one child or have a trigger on parent to create one child.
Similarly have a delete trigger on Child and if the child...
October 26, 2006 at 10:56 am
Try this:
SELECT DISTINCT [SelectionValue] FROM [CIATStaging].[dbo].[ResponseSelectionDictionary] WHERE isnull([SelectionValue],'') NOT
October 25, 2006 at 2:42 pm
I don't have an excat answer. I know this works for a particular category.
DECLARE @ProductName VARCHAR(1000)
set @ProductName =''
SELECT @ProductName =@ProductName + ', ' +
ProductName
from Products where CategoryID = 20
select...
October 24, 2006 at 4:17 pm
Select Customer.vcCustomer,Sum(Case when vcCustomer ='A' Then 1 Else 0 End) as ACustCounts,
Sum(Case when vcCustomer ='B' Then 1 Else 0 End) as BCustCounts,
Sum(Case when vcCustomer ='C' Then 1 Else 0 End)...
October 23, 2006 at 4:31 pm
Here you go:
ALTER FUNCTION [capsf].[GetAttorneys]
(
@NewCaseId varchar(25)
)
RETURNS VARCHAR(2000)
AS
BEGIN
DECLARE @itemList VARCHAR(8000)
SET @itemList = ''
SELECT @itemList = @itemList + DefenseAttyDesc.FName + ' ' + DefenseAttyDesc.LName + ', ' + char(13)
from CaseToDefenseAttorneyMapping,DefenseAttyDesc
where CaseToDefenseAttorneyMapping.DefAttyId =...
October 23, 2006 at 4:18 pm
I don't see ur paramter being used to filter any data(Its not in where clause). Looks like u are using it to decide what the value of status is going...
October 23, 2006 at 4:09 pm
Viewing 15 posts - 31 through 45 (of 314 total)