Here is a sproc I wrote to handle a similar problem: /* This can execute dynamically generated SQL statements up to approx 156000 chars in length. Since you can't pass this as a variable the proc takes the table and fieldname of a text value to execute. A where statement can be included and should […]
2003-08-21
1 reads
I can't see why they would be displayed in dd/mm/yyyy format, order from earliest to latest. Can you post an example of out of sequence dates?
2003-07-10
1 reads
quote: Hi All, I want to backup one SQLServer machine (Source) to another SQLServer machine (Backup). Once this is done, I want to have the backup machine updated on a daily basis to reflect changes to tables and procedures on the source machine. Is there a standard and automated way of doing this? Thanks. Agnaldo […]
2003-07-09
sir I clearly specified in my earlier mails is Billingdate is a char type .I want to compare it with two date values once again writing my query select * from table where Billingdate between date1 And date2 i am not bothering about date1 and date2 the part troubling me is char billingdate i want […]
2003-07-04
Try this update f set f.groupid = 213 from o_file as f where f.columnx = 215 and exists (select * from stutable1 a where f.fileid = a.o_objid)
2003-05-21
2 reads
I forgot to mention that these are cluster environments. Kelly Ennis
2003-05-21
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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