Viewing 15 posts - 166 through 180 (of 581 total)
You can use the search functionality in windows explorer. Not sure if you can script this as a Windows command batch, though.
June 29, 2006 at 7:21 am
Logically speaking, the join order per se is irrelevant to the optimiser, unless you use join hints or the force_order query hint, inwhich case the joins are performed in the...
June 29, 2006 at 6:39 am
You can't do what describe since a SQL statement is a transactuion which will succeed or fail as a whole.
Changing the UPDATE to a SELECT would tell you whether the...
June 29, 2006 at 6:25 am
You definitely don't need any sort of split function.
The code you posted is fine, with the (optional) amendments I suggested above.
Getting rid of the ISNULLs would definitely help. Locigally speaking,...
June 29, 2006 at 5:06 am
If you do the scan often, and if the table's not too big, you could consider using DBCC PINTABLE on startup to ensure the table stays in memory. Be warned that this could...
June 27, 2006 at 5:49 pm
The events to which DML triggers can respond are: UPDATE, INSERT, DELETE.
A DML trigger may also cause any of these 'events' to occur, too, if it performs UPDATE, INSERT or DELETE...
June 27, 2006 at 5:42 pm
All tables are flat. The question is whether the data in the table is itself flat. If the data isn't really flat but has been flattened to fit in a rectangular...
June 27, 2006 at 5:24 pm
Here's how I would change the first SELECT. As mentioned above, it would help if the zip columns could be compared without wrapping them in isnull(). What exactly are the rules...
June 27, 2006 at 5:15 pm
You only need to use split if you are forced to accept comma-divided strings by (a)circumstances beyond your control (pre-existing data, legacy system), or (b) the fact that it is impossible to...
June 27, 2006 at 3:42 pm
Based on what i can deduce about your requirement, and if this is for single rows only, this would do it:
pseudocode:
update table1
if rowcount is 0, insert table1
...
June 27, 2006 at 3:27 pm
If you want to report data for whole calendar months, why not use
datediff(month, salesDate, getdate())<6
?
June 27, 2006 at 11:16 am
Restriction to the current year means that too little data will be returned if the query is run before july.
Use of datepart(month,...) means that dates outside the last 6-month (i.e. approx...
June 27, 2006 at 9:51 am
@querylboundinc datetime, @queryuboundex datetime, @halfhourstart datetime
June 27, 2006 at 9:19 am
Typo in your first INSERT statement. TBL_LINK_GROUP_OBJECT_OBJECTID has an S added to make TBL_LINK_GROUP_OBJECTS_OBJECTID.
The error message and a look at the declarations section confirmed this was the case; a...
June 27, 2006 at 8:51 am
Viewing 15 posts - 166 through 180 (of 581 total)