Viewing 15 posts - 4,321 through 4,335 (of 6,036 total)
SELECT COUNT(case when Trans_Date >= '04/01/2007' AND Trans_Date = '05/01/2007' AND Trans_Date < '06/01/2007' then ID_col else NULL end) as [05/07],
....
May 9, 2007 at 11:46 pm
What's the size of recordset returned in QA?
Where it goes when you run query from osql?
May 9, 2007 at 2:42 pm
Yes, you can.
If you don't plan to have more than couple of hundreds records in this table.
You you expect the tabe to grow you need to fix table design and...
May 9, 2007 at 6:12 am
1st, date must be stored in database in datetime datatype. No format involved.
2nd, open BOL and type in "Index" keyword CAST, press Enter twice and read about converting strings to...
May 9, 2007 at 6:07 am
Run
exec master..xp_fixeddrives
What is the result?
May 8, 2007 at 11:48 pm
SELECT slNo, Name, Description
FROM dbo.MyTable
GROUP BY slNo, Name, Description
HAVING COUNT(*) = 1
May 8, 2007 at 11:12 pm
Can you run the same command from QA?
May 8, 2007 at 10:29 pm
> I just created a workbook with over 1500 worksheets.
Good revenge!
![]()
May 8, 2007 at 9:27 pm
ChrisMoix,
how do you know that item transferred from 7 to 8 is the same item transferred from 5 to 7?
How you gonna distinguish 2 deliveries from 7 to 8 happened...
May 8, 2007 at 6:41 pm
Sounds like "Whatever"
Do you have any idea what kind of resultset you're trying to retrieve?
Can you explain it in plain English?
May 8, 2007 at 6:15 pm
Problem with this you MUST know the name of the sheet inside of Excel Workbook.
And users use to rename/delete those sheets without asking permissions from those bloody developers.
May 8, 2007 at 6:10 pm
INDEX SCAN will be used every time you query for a range of values from a column not having clustered index on it.
BETWEEN means CLUSTERED INDEX.
End of story.
May 8, 2007 at 6:02 pm
Don't include queries to system tables into procedures called by regular users.
It's not allowed in every environment.
Check BOL for "system functions", "security functions"
select suser_sname(), CURRENT_USER, system_user, host_name(), etc.
will give...
May 8, 2007 at 4:30 pm
Clustered index must be on logWritten column.
And use join anyway.
May 8, 2007 at 7:52 am
Viewing 15 posts - 4,321 through 4,335 (of 6,036 total)