RE: Snaking columns
Don't know if it would make a difference, but I have only created this kind of report using a table control, not the list control...have you tried it that way?
2005-02-04
ODBC
If/else statement in a Stored Procedure
A couple of questions about a stored procedure that is not acting like I think it should... (I won't print out the whole thing because of the length, unless I need to do so later.)Question 1: When using an if...else in a stored procedure, can you have more than one else?For example... what I have […]
2005-02-02
RE: getting the results of execute sql task
Hi Bellis, Thanks for the immediate response. Can you please post the sample script to execute more than one sql statements inside active x script. right now i'm trying like this but it is giving errors. Function Main() Set myConn = CreateObject("ADODB.Connection") Set myRS = CreateObject("ADODB.Recordset") myConn.ConnectionString = "Provider=SQLOLEDB;Data Source=OLYMPOS\RMSWORK; Initial Catalog=Rubys;Trusted_Connection=Yes" 'myConn.ConnectionTimeout = 0 […]
2004-11-30
RE: System Object SysColumns not found
Trt select * from dbo.syscolumnIs your SQL Server be setup as case sensitive?
2004-08-18
RE: Query Help
Am I missing something here? what is wrong with this:Update o Set mynbr = datediff(d,(select min(mydate) from testt t where t.empid = o.Empid ),o.mydate) from testt o Tests:create table testt (recnbr int , mynbr int, mydate datetime, empid varchar(50)) goinsert into testt (recnbr, mynbr,mydate,empid) Values (1, 0 , '1/1/2001', 'bob') insert into testt (recnbr, mynbr,mydate,empid) […]
2004-07-26
Report Parameters Wont Go Away
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-23
RE: Please HELP
The Ver is 6.5 I cannot open trough Enterprices but I can do connect wiht ISQL and when I try to drop the database it gives me same error...so I tried to do DBCC DBREPAIR but it says its not marked as suspect mode? Dimpal Dimpal Patel
2003-08-22
RE: Indexes
quote: One of our nice developers has managed to create over 300 indexes with a fill factor of 90 (good eh) on a db that is about 15Gb in size. I would like to drop all the indexes and recreate them with a fill factor of 10. Can anyone give me a hand in scripting […]
2003-07-10
1 reads
RE: NULL values in source table don't add up
The fact table has many columns, including currency_code as well as, for example gross_profit. One row may have a NULL value for currency_code, but there will be a value for the gross_profit. If I try sum(gross_profit) where currency_code NOT NULL AND date = 'JUNE', for example, as per your suggestion, eljeffo, the value returned for […]
2003-07-09
RE: Search Engine Type Query - Please help
thanks Turpin, I thought I may be over complicating it. I'll give that a go. Cheers Nic
2003-07-08
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers