Viewing 15 posts - 17,896 through 17,910 (of 18,926 total)
I've never done reporting in .net. I don't think it's gonna be easy to convert that project to .net if you've never worked with it.
Also access has been created...
May 4, 2005 at 11:39 am
SELECT EmployeeID, LastName, FirstName, MiddleInit, CAST(0 AS Decimal(10,4)) AS Salary FROM dbo.Employees
May 4, 2005 at 11:36 am
DataBase Command Console
Don't know what really happens in a shrink... I'll let someone else answer this one.
May 4, 2005 at 11:35 am
You can't do it that way without a reporting tool like access or crystal report. You'll have to manually open the recordset with a command object and then present...
May 4, 2005 at 11:33 am
It's basically a recordset that you can open/manipulate on the server. It's also viewed as an evil by good coders/dbas because it takes much more time to execute things...
May 4, 2005 at 11:32 am
Well if you created views then yes. You need to create stored procedures that have parameters to filter the result set.
One other thing you could do is an Access...
May 4, 2005 at 11:22 am
I think you didn't read the thing or you just need to have the last word. The plan is created B4 the execution. The plan also has to...
May 4, 2005 at 9:26 am
Can you run the debugger and tell us which line give you this error?
May 4, 2005 at 9:15 am
select * from tblOrders where orderDate > '2004-12-31' and FREE = '1' AND [Order code] 'ABC'
May 4, 2005 at 9:15 am
Actually : Change the ANSI_NULLS to OFF
but I still wouldn't recommend that option... You need to learn to work with the null values.
May 4, 2005 at 8:28 am
Select * from TBL_A where (Col_1 = @DateSubmitted OR @DateSubmitted IS NULL AND Col_1 IS NULL)
Anything = null will return null so you'll never get any results unless you set...
May 4, 2005 at 7:46 am
BETWEEN '01/03/2005' AND '31/03/2005'
is the same as doing
BETWEEN '01/03/2005' AND '31/03/2005 00:00:00'. That's why you are missing all the records from that day.
BTW your query will run...
May 4, 2005 at 7:12 am
I could make this fancy but it's too simple :
May 4, 2005 at 6:48 am
Can you create a link in the home folder that points to the image folder's image?
May 4, 2005 at 6:41 am
Viewing 15 posts - 17,896 through 17,910 (of 18,926 total)