Thank you for replying...The conversion of the dates into the appropriate format does work, as I am using VBScript to rearrange the dates and they are accepted into the second table as datetime.I would love to see some sample code, however, as most of the rest of this thing is all up in the air...if […]
2004-09-28
@NEXT_YEAR is an integer and causes string concatenation problems. CAST or CONVERT it to a varchar.'7/1/' + CONVERT(varchar, @NEXT_YEAR),'7/31/' + CONVERT(varchar, @NEXT_YEAR)
2004-09-23
I'd agree that there's nothing confusing about this question ... it just has to be read and interpreted carefully, and in a way that honors this particular question's context more than other contexts that may not apply here. 2 GB is not the "default maximum" just because it shows up in a column labeled "maximum" […]
2004-09-09
try doing datediff for number of days instead.Beer is the answer to all the world's woes.
2004-08-20
I have a DB that is around 250GB that is growing rapidly. It is running on a 4 proc clustered server with EMC SAN for storage. The entire database resides on a single data file within a RAID 5 partition, and as of right now it is performing very well. However, I am wondering if I should create […]
2004-08-13
8 reads
We are talking faster here. how fast is it?if the different only 1/100 second then what does it make different for the user?as a developer it will be easier to write withour owner name and we can make our sql statement compatible with other db.
2004-08-10
I've found that shrinkfile can sometimes "hang", if I can I switch the database model to simple before shrinking the file(s) I realise that sometimes this isn't possible but it works !You could also try issuing a checkpoint before the shrink.
2004-08-05
First option:Make 1st view and in that view calculate COUNT_STATE. Then write the 2nd view on top of the 1st view and here you can do your GROUP by clause on COUNT_STATE.2nd Option:Write a UDF like GetCountSTATE(CUST_ADDRESS.STATE) and do the case statement in that UDF. Then you can do the GROUP BY on GetCountSTATE(CUST_ADDRESS.STATE).
2004-08-04
Triggers is what you need! Just rememeber to place the NOT FOR REPLICATION statement in the Triggers!
2004-08-03
2004-07-29
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