I presume that LSeries can be any value or is it as per your example limited to 999?But why a nested cursor!One cursor to get distinct LSeries and do a set based update to update target table. Unfortunately this would involve using dynamic sql ( yes I know to be avoided at all costs but... […]
2005-01-19
Is there a way that I can alias or create a synonym for a table? Any help would be greatly appreciated. Thanks…
2005-01-19
Don't forget the thing about change control. It's better to work on that as well, so it is ready when you're done with the mapping. If not, it may be too tempting to go around it while waiting for it to become real, and before you know it, you might have to do the work […]
2005-01-19
or you could use this:select convert(varchar(12),getdate()) + right(convert(varchar,getdate(),126),len(convert(varchar,getdate(),126))-charindex('T',convert(varchar,getdate(),126)))result = Jan 19 2005 08:48:19.397 depending on your preferencing for displaying the date to your users. regards, Mark Baekdal http://www.dbghost.com+44 (0)208 241 1762 Database change management for SQL Server
2005-01-19
Hi, Happy New Year There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)). In both options you have a precedence order so […]
2005-01-05
From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05. It also looks like it doesn't matter when they will be checking out. Try the following query:Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'
2005-01-04
Why do you want to do this? What are the requirements? Here is a fun "Select" SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())
2004-12-27
1 reads
Ever thought of encrypting that sensitive data? That won't stop someone with sa privileges from watching the data, but he will not understand what he sees.
2004-12-16
I have INSERT tbl2 SELECT id,fname,lname from tbl1 WHERE ref# = '123' This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS in that column).
2004-12-16
Very impressed with this test. Thanks, Wes. I am in the market for one of these products and was liking the results of MiniSQLBackup shown in your test. I am, however, confused as to why it took 500% longer to backup with MiniSQLBackup compared to the standard SQL Server backup. Isn't one of the features […]
2004-12-07
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