CREATE VIEW V_TESTAS SELECT * FROM CH1.DB1.TEST1 UNION ALL SELECT * FROM CH2.DB2.TEST2 By using profiler, we can confirm that query establish connection on CH1 and CH2 simultaneously, but run it serially.
2004-10-14
Assuming that 'transaction_date' in your example is the date in which you need to find the fiscal week of, its a matter of determining the difference between 4/1 and that date. You can use DATEDIFF(day,<startdate>,<enddate> to find the difference, then divide by 7. You may, however, need to do some additional interrogation for partial weeks […]
2004-09-23
1 reads
There is blat, was this what you were using? The advantage of xpsmtp is you can make a call from within a T-SQL batch without resorting to xp_cmdshell. So it has uses as a closer replacement to xp mail extended stored procedures.
2004-08-02
Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]
2004-07-29
On our most active server I do weekly fulls nightly diffs and tlogs every 15 minutes. I've never had a problem at all with the schedule. I've been running that kind of schedule on as many as 60 servers since sql 7 came out and have never experienced a disjointed tlog(I'm not real sure what […]
2004-07-23
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-07-12
And for my second question have you got an idee?'cos i can't do this :SET @strReq = 'SELECT DLZ_EMAIL.EMAIL_LIB, @Nb = COUNT(*) FROM DLZ_EMAIL WHERE DLZ_EMAIL.DATE_DEB <= GETDATE()'@Nb is an OUTPUT parameter and i need to have the column EMAIL_LIB in my request.Thx again
2004-06-22
Network Appliance is our NAS vendor. They also do SAN, it just depends on the controller(s) used in the device.http://www.netapp.com/solutions/nas.htmlhttp://searchstorage.techtarget.com/sDefinition/0,,sid5_gci214410,00.htmlhttp://searchstorage.techtarget.com/qna/0,289202,sid5_gci916335,00.htmlChris
2004-06-09
You could flatten the hierarchical data, and use this flattened view for the reporting requirements. I dont know enopough about the database schema and the reporting requirements, but anyway, here is a sample method of flattening the hierarchy:select [Executive Director].empcod as [Executive Director Cd], [Executive Director].name as [Executive Director Name], [President].empcod as [President Cd], [President].name […]
2004-05-31
HRm, though you're error message doesn't indicate this to be the problem - is the path to the test.xls file relative to the server? For example, if the test.xls resides on a department share and the logged in user has an R: drive mapped to that share, the server doesn't have a mapped R: drive […]
2004-05-26
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers