Viewing 15 posts - 421 through 435 (of 595 total)
What does the selection field represent? I am having trouble understanding what you want to output from your query, and what you want it ordered by...
May 16, 2003 at 6:31 am
I have a sneaking suspicion that one of the dob data values is screwy. The column wouldn't happen to be NULLABLE would it?
May 15, 2003 at 12:07 pm
When you paste data into the cell, be sure to clear all other data out of it before you paste. There may be spaces in the cell before you...
May 15, 2003 at 12:02 pm
Interesting. Could you post the test script? Thanks,
Jay
May 15, 2003 at 11:58 am
Maybe try:
SELECT
A.entitycode,
B.Lastname,
B.dob as DOB,
dbo.f_get_age(CAST(B.dob AS SMALLDATETIME), getdate())
? Don't really know what it is...
May 15, 2003 at 11:51 am
2 Things...
First, Is there really a need for DATETIME parameters? I think SMALLDATETIME should be sufficient for Birthdates, since I doubt many people keep track of when they were...
May 15, 2003 at 8:11 am
Try this syntax:
UPDATE a
SET COLUMN1 = POWER(10 , ISNULL(b.COLUMN1, 0))
FROM TABLE1 a
INNER JOIN TABLE2 b
ON a.COLUMN2 = b.COLUMN2
AND a.COLUMN3 = b.COLUMN3
AND a.COLUMN4 = b.COLUMN4
Also, you do...
May 15, 2003 at 7:42 am
You could run this script periodically:
UPDATE s
SET s.storeName = s.storeName + ' (b)'
FROM tblStore s
INNER JOIN tblStoreProfile p
ON s.storeID = p.storeID
WHERE p.isBigStore = 1
Or you could...
May 14, 2003 at 6:48 am
Try a cast around the entire case statement:
Select
DisplayName= CAST(
(Case @SortOrder
when 1 then
Cast(CSI.CSICode as varchar(10))+ ' ' + CSI.CSIName
when 2 then
Submittal.SubmittalStatusID
when 3 then Company.CompanyNameelseSubmittal.SubmittalName
END)...
May 14, 2003 at 6:14 am
quote:
...Could you give an example with this column structure. I just want to make sure I understand...
May 14, 2003 at 5:40 am
Is there some unique identifier on your saved_property table? If not, it would behoove you to add an identity field to it. After having done that, you can...
May 13, 2003 at 1:32 pm
Let SQL Server do what it's been designed for. Use a BEGIN TRAN / COMMIT TRAN block around the steps, with ROLLBACK checks after each step. This will...
May 13, 2003 at 12:45 pm
Are you talking about a SQL Job or a stored procedure? If you change a stored procedure that is run by a SQL Agent job, then the job will...
May 13, 2003 at 12:43 pm
Why are you selecting the name, and then setting equal to null? Do you mean to check whether the value is null? If so, try:
May 13, 2003 at 12:15 pm
It is true that you could use LIKE:
WHERE KeywordField LIKE '%Software%'
Or, you could use PATINDEX:
WHERE PATINDEX('%Software%', KeywordField) > 0
Or,...
May 8, 2003 at 6:53 am
Viewing 15 posts - 421 through 435 (of 595 total)